Search code examples
phphtmltabsexport-to-excel

Create a multi-tabs Excel file

My PHP script have to create a multi-tabs Excel file with a report in each tab, but those reports already exists as HTML pages, so I don't want to duplicate code and work. I know I can rename a HTML file to .xls, and Excel/OpenOffice Calc will open it as a spreadsheet, but I don't know how to have severals tabs.

I do not even know if it is possible.

I already know Biffwriter and others PHP libs to create Excel file, but I am looking for a smarter solution.

Thanks, Cédric

Solution

  • Pear Excel Spreadsheet Writer has a function to create new Worksheets if thats what you are looking for.