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

7 votes253 views2 answers
Laravel check sql query
PHP
0 vote298 views1 answer
How to display the taxonomy image in wordpress
PHP Wordpress
12 votes260 views3 answers
For else laravel
PHP
0 vote262 views4 answers
Share var in a maser layout laravel
PHP
2 votes243 views1 answer
Php format int to 9 digits with preceding zeroes
PHP
1 vote302 views1 answer
Clear cache using laravel controller
PHP Laravel
0 vote235 views2 answers
Can't instal php 7.3 linux
PHP
1 vote249 views3 answers
Laravel auth check login
PHP
4 votes237 views6 answers
Remove index.php in codeigniter
PHP
0 vote253 views1 answer
Laravel npm run dev mix error FIX
PHP