php excel阅读多个标签

Question

I am using this code http://code.google.com/p/php-excel-reader for reading excel files with PHP.

It works great, but problem is when I open multiple tabs file with this code, it makes the page very large.

When I open a single tab file its work fine.

I need the tabs to look like excel as shows.

check above image. I need tabs like screenshot left image and right image, I open same file but don't have tabs actually that same file but the left original excel image show with tabs and right php script that i am sing not showing tabs..

I need any script which reads excel file the same as excel does and show all same as excel shows current script work fine but its not work with multiple tabs file the extention i am using is .xls

Answer 1

require_once 'Classes/PHPExcel.php';
$objPHPExcel = PHPExcel_IOFactory::load("myExcelFile.xls");
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'HTML');
$objWriter->writeAllSheets();
$objWriter->save('php://output');

You can play with the styling if you want the sheet list as tabs, and add a bit of js to hide/unhide the individual sheets by modifying PHPExcel/Writer/HTML.php