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 vote181 views1 answer
Laravel project htaccess redirect to public path
PHP Laravel
0 vote122 views1 answer
Php remove line starting with
PHP
7 votes162 views1 answer
Unable to read key from file file
PHP
3 votes170 views2 answers
Insert into laravel 8
PHP
0 vote151 views1 answer
How to include page specific css in xphp smart header
PHP
0 vote143 views1 answer
Regex get text between braces
PHP
37 votes171 views4 answers
Php replace every occurrence of character in string
PHP
1 vote163 views4 answers
In_array validation laravel
PHP
0 vote172 views1 answer
Pdo mysqli error handling
PHP
0 vote158 views1 answer
Compare in wp
PHP