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

3 votes152 views1 answer
Php extensions for laravel
PHP Laravel
3 votes163 views2 answers
Laravel required if it meet some value from another field
PHP
0 vote142 views1 answer
Request file create cammand laravel
PHP
0 vote166 views1 answer
Concat ternary operator
PHP
0 vote182 views2 answers
Laravel collection first
PHP
0 vote98 views1 answer
Php str_contains
PHP
51 votes147 views6 answers
Laravel make seeder
PHP
4 votes153 views2 answers
Check request header laravel
PHP
0 vote129 views2 answers
Laravel return new tab
PHP
25 votes158 views3 answers
Radio selected
PHP