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 vote337 views1 answer
Drupal 9 how to pass arguments to custom blocks
PHP
0 vote367 views2 answers
Global variable in laravel controller
PHP Laravel
47 votes414 views6 answers
How to add new column in laravel migration
PHP Laravel
0 vote359 views1 answer
Php.hello
PHP
0 vote319 views1 answer
Eager realationship in laravel
PHP
2 votes315 views1 answer
Laravel migration with primary key
PHP
0 vote389 views1 answer
Laravel mysql specified key was too long
PHP Laravel
0 vote323 views1 answer
Undefined offset 0
PHP
0 vote318 views1 answer
Como destruir uma variavel de sessão
PHP
11 votes363 views2 answers
Wp-config override site url
PHP