Phpspreadsheet edit excel file

<?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');

Similar codes

0 vote139 views1 answer
Laravel make migration controller resource mcr
PHP Laravel
0 vote119 views1 answer
Datatables compactible with bootstrap v4
PHP
0 vote119 views1 answer
Smarty foreach
PHP
3 votes104 views2 answers
Php date timestamp now
PHP
5 votes154 views2 answers
Laravel migration change column length
PHP Laravel
0 vote129 views1 answer
Add floater to open a modal in wordpress
PHP
0 vote127 views1 answer
Php simple html dom
PHP
1 vote224 views1 answer
Drupal 9 enable PHP errors
PHP Drupal
0 vote131 views2 answers
How do i use php read excel file
PHP
0 vote135 views2 answers
Laravel allow all fillable
PHP Laravel