Creating a spreadsheet in a spreadsheet using PHPExcel

Question

Looking for an answer, I found many questions regarding turning a table into a spreadsheet or outputting a table into a spreadsheet, but did nothing about creating an Excel spreadsheet in a spreadsheet using PHPExcel.

I would like to create a table in Excel, that is, I would like to highlight the cell / data section from the rest of the table so that the data can be sorted and filtered regardless of the rest of the worksheet. This is the same as doing Insert → Table in Excel.

This seems pretty common, but I can't find a way to do this in the PHPExcel documentation.

How to create a spreadsheet in a spreadsheet using PHPExcel?

Answer 1

The Insert / Table is just a GUI shortcut for styling and setting autofilters for a block of cells. Both can be performed as separate tasks using PHPExcel, but the library does not provide a “shortcut” way to do this with a single method call.

Take a look at section 4.6.25 of the developer documentation and the 10autofilter.php example in the / Tests directory of the distribution