質問: I've been looking for ways to do this and haven't found a good solution to this. I'm trying to copy a sheet in an .xlsx file that has macros to another workbook. I know I could do this if the sheet contained data in each cell but that's not the case. The sheet contains checkboxes and SOME text. Is there a way to do this in python (or any other language for that matter?) I just need it done programmatically as it will be part of a larger script.
回答: 「Excelのオプション」 「詳細設定」 「切り取り、コピー、貼り付け」欄 「挿入したオブジェクトをセルと共に切り取り、コピー、並び替えを行う」にチェックを入れることで チェックボックスを含みシートをコピーできます Excelマクロで「Application.CopyObjectsWithCells = True」とすれば設定できます。