search

jmcnamara / XlsxWriter

A Python module for creating Excel XLSX files.
https://xlsxwriter.readthedocs.io
BSD 2-Clause "Simplified" License
3.66k stars 631 forks source link

Add full worksheet copying method #1062

Closed Floppa2003 closed 7 months ago

Floppa2003 commented 7 months ago

Feature Request

Hello everyone. Let's say I need to copy sheet "Sheet1" from file_1.xlsx, sheet "Sheet2" from file_2.xlsx and sheet "Sheet3" from file_3.xlsx into 3 separate sheets in Excel file merged.xlsx The sheets have some formatting, merged cells, specific row and column width, zoom, etc., so simple value copying isn't an option. Is there a quick way to do this with xlsxwriter?

jmcnamara commented 7 months ago

Is there a quick way to do this with xlsxwriter?

There is no way to do this with XlsxWriter. It is only for creating new xlsx files.

You may be able to do what you want with Pandas and/or OpenPyXL.