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

18 votes111 views5 answers
If statement in laravel blade
PHP
36 votes106 views3 answers
Php current date get
PHP
0 vote104 views1 answer
Php curl upload linkedin image
PHP
0 vote143 views1 answer
Laravel permission spatie cache clear
PHP Laravel
1 vote106 views1 answer
Php inline if null check
PHP
5 votes116 views2 answers
Check session in blade laravel
PHP
0 vote112 views1 answer
Preg_split
PHP
0 vote125 views2 answers
Update user role wordpress
PHP Wordpress
4 votes172 views2 answers
Laravel collection count
PHP
0 vote115 views1 answer
Php 8 loadmodule
PHP