Could you tell me the package for working with Excel templates,
There are a few Excel tables (invoice, invoice act-vipw works), that is, the files are not large. In fact, change only the values of some cells and to duplicate a string with the name of the goods. (1-5 lines)
Google is basically on PHPExcel which is DEPRECATED and now called PhpSpreadsheet. PhpSpreadsheet creates documents fine, but to take an Excel file to change the values cannot (if you are resaving and posleduyushim opened in Excel complains that not the right file extension or file corrupted), even copy-paste code examples from the documentation peresherstit damaged files that Excel cannot open.
Copy and paste the code from the docks PhpSpreadsheet
$spreadsheet = \\PhpOffice\\PhpSpreadsheet\\IOFactory::load('template.xlsx'); $worksheet = $spreadsheet->getActiveSheet(); $worksheet->getCell('A1')->setValue('John'); $worksheet->getCell('A2')->setValue('Smith'); $writer = \\PhpOffice\\PhpSpreadsheet\\IOFactory::createWriter($spreadsheet, 'Xls'); $writer->save('write.xls');
It looks like one Excel file from multiple
Tried to save an html table as .xls, Excel complains but opens up but then printing from it is very difficult (table riding on a few villages and it is difficult to reconcile the size)