QtXlsxWriter icon indicating copy to clipboard operation
QtXlsxWriter copied to clipboard

Copy a sheet from one xlsx-file into another

Open qproger opened this issue 10 years ago • 3 comments

Hello! How to copy a sheet from one xlsx-file into another? For example: I have an xlsx-file called "Book.xlsx". It contains a sheet (for example "MySheet"). Also I have another file - "AnotherBook.xlsx". And I want to copy "MySheet" into "AnotherBook.xlsx". How to do this? Or how to make a full copy of contents of "MySheet" (text, formulas, styles of cells...) and then put it into a sheet in "AnotherBook.xlsx"?

Thank you.

qproger avatar Jan 18 '15 10:01 qproger

Nobody knows???

qproger avatar Jan 23 '15 10:01 qproger

@dbzhang800 How about add a function in xlsxworksheet.h named copyToWorkbook by specifying another workbook?

But actually there is a function named copy in xlsxworksheet.h, you could create a new workbook and insert the copied worksheet into the workbook using function insertSheet in xlsxdocument.h.

hugle avatar Jul 16 '15 10:07 hugle

Has this problem solved?

FrimanDub avatar Dec 17 '20 08:12 FrimanDub