Is it possible to write in an existing spreadSheet with PhpSpreadSheet?

php spreadsheet phpspreadsheet
Alexandre Corvino picture Alexandre Corvino · May 30, 2018 · Viewed 7.6k times · Source

I'm currently using PhpSpreadSheet Library and I wanna write into an existing spreadSheet. Is that possible?

If yes, how? I didn't see any possibility in the documentation.

Thanks!

Answer

Evil_skunk picture Evil_skunk · May 30, 2018
  • Load the existing Spreadsheet-File
  • Change something
  • Write it again to Filesystem

Code:

<?php

//load spreadsheet
$spreadsheet = \PhpOffice\PhpSpreadsheet\IOFactory::load("yourspreadsheet.xlsx");

//change it
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', 'New Value');

//write it again to Filesystem with the same name (=replace)
$writer = new Xlsx($spreadsheet);
$writer->save('yourspreadsheet.xlsx');

Related questions

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 …

Read More
How to generate an Excel document with multiple worksheets from PHP?

I want to generate an MS Excel file from PHP. I know one can do something like this: header ( "Content-type: application/vnd.ms-excel" ); header ( "Content-Disposition: attachment; filename=foo_bar.xls" ); But it will generate a file with just one Sheet. …

Read More
How to generate an .xlsx using php

I need to generate an Excel file with extension .xlsx. Here is my simple code: $file = "test.xlsx"; header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); header('Content-Disposition: attachment; filename='.$file); $content = "Col1\tCol2\tCol3\t\n"; $content .= "test1\ttest1\…

Read More