Export Excel Data - Worksheets by date.

jvalen9362

First I want to said thank you to all the staff, very clean and knowledgeable Site.

I want to ask if is possible to export excel report with multiple worksheets, base on dates?

for example:
if I filter my search by month, I want to export excel file, but I need worksheets by dates.

Thank You in advance.

allan

Currently, no sorry. Out XSLX exporter is intentionally really simple (it isn't out main project after all). You'd need to use another library such as SheetJS to create more complex Excel files. You can get all the export information from the table by using buttons.exportData() (which is what our Excel exporter uses). The data would then need to be set out as required by SheetJS or whatever you use.

Regards,
Allan

jvalen9362

Thank you Allan. let me research more.