Excel Exporter: How to export multiple sheets with an existing excel file(Template)
Hello. I would like to export multiple sheets. Now, It is possible to export multiple sheets without an existing excel file. However, when I upload existing excel file, only first sheet has data and other sheets are empty. Is it impossible to export multiple excel sheets with existing file? thank you in advance.
This can be solved by setting the sequence number (MxSheet.Sequence) in the sheet settings correctly.
When a sheet is created, all sequence numbers are set to the default value of 1.
Also, in the edit screen (MxSheet_NewEdit), the Sequence item is not editable, so it cannot be changed.
Please change the screen so that you can edit it, and try to set the sequence number according to the existing Excel sheet order.