Generate multiple tabs in Excel file during export...

jaygrayson

Hi! I love the product! Great job!

Is there any way to create multiple tabs in the Excel file when exporting? What I am using is multiple datatables within a tab control. Each tab has a separate datatable, which works fine. That was a little bit of a chore figuring that out... Anyway, when I click export, it exports the datatable properly for each tab but, I want to be able to export all of the datatables from the tab contol into separate tabs on ONE exported Excel file. Basically, the tabs from the website will become tabs within the Excel file.

I can figure out the UI export, I just want to know if there is a way to create additional tabs during the export without reaching out to PHPExcel or something similar?

Thanks!

allan

It is possible, but only through the customize method of the excelHtml5 button type. That provides access to manipulate the XML that the Excel file is made up of, so if you know how to create the required XML for the Open Spreadsheet format, it can be done.

The Excel export is not designed to provide a nice simple API for that kind of function - that would be a whole project in its own right!

Regards,
Allan