I’ve got an array of hotels below. I’m planning to export it to a spreadsheet using Php spreadsheet. My goal is to get 1 spreadsheet per hotel so in the array $hotels below, I’d expect 2 spreadsheets will be created. This is what I wanted to render in each spreadsheet. Spreadsheet 1: Spreadsheet 2: But what I’ve got so far
Tag: spreadsheet
Center all text in PHPSpreadsheet and make the cells expand to fill up with context
I struggle a bit to make all the cells set the context to center and to autoexpand so it doesnt overlap each other. So what I try to do is: Set the info in every cell to be centered since it makes …
PHPExcel very slow – ways to improve?
I am generating reports in .xlsx using PHPExcel. It was okay in the initial testing stages with small data sets (tens of rows, 3 sheets), but now when using it on a real production data with over 500 rows in each sheet, it becomes incredibly slow. 48 seconds to generate a file, and when running a report that combines more