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 vote122 views2 answers
Twig filter array
PHP
6 votes151 views6 answers
Array to String Conversion in PHP
PHP
10 votes142 views3 answers
Php how to loop through array_rand
PHP
0 vote127 views1 answer
Php dump to page
PHP
4 votes160 views5 answers
Laravel storage
PHP
2 votes167 views1 answer
Install php dom extension ubuntu
PHP
7 votes152 views3 answers
Wordpress echo the date in post
PHP Wordpress
0 vote124 views1 answer
Laravel validate number to be at least 3 digits
PHP
2 votes143 views1 answer
Php download rate limit
PHP
0 vote142 views1 answer
Laravel echo html
PHP Laravel