QtXlsxWriter
QtXlsxWriter copied to clipboard
Copy a sheet from one xlsx-file into another
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.
Nobody knows???
@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.
Has this problem solved?