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 vote128 views1 answer
Laravel allow null records relationship
PHP Laravel
7 votes127 views2 answers
Transaction commit rollback in laravel
PHP Laravel
1 vote273 views1 answer
Symfony convert entity to array
PHP Symfony
18 votes124 views6 answers
Laravel model
PHP Laravel
0 vote100 views1 answer
On keyup jquery for search php on basis of class name
PHP
4 votes117 views5 answers
Wordpress logout link
PHP Wordpress
22 votes103 views5 answers
Get logged user id laravel
PHP
0 vote124 views1 answer
Take and skip in laravel
PHP Laravel
2 votes100 views2 answers
Xamp to test on mobile
PHP
0 vote99 views1 answer
How to add javascript in php
PHP