Select Multiple Worksheets

Topics: Developer Forum, User Forum
May 15, 2012 at 3:20 PM



i search the PHPExcel Documentation, but i could not find any function to select multiple / select all Worksheets.

Is there any possibility to select multpile Worksheets before saving the Workbook?

I would need this feature very urgently!




May 15, 2012 at 5:57 PM

Unsure exactly what you mean. If by selected sheets you mean setting more than one active sheet, then this is not practical... only one sheet can ever be the active sheet at any one moment.

If you mean you only want to save certain worksheets, then you need to remove unwanted sheets from the PHPExcel object before saving.

May 16, 2012 at 3:56 PM

Thanks for answering!!

I need to select all sheets before saving because the user (or program) that opens my excel sheets later should be able to print all sheets directly (for example into a pdf).

If you use Excel you can do this manually by right-clicking any excel-sheet and then clicking on select all sheets. This funktionality of excel would be useful for my work...