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 vote186 views1 answer
Laravel 8 db like query
PHP
10 votes200 views6 answers
Php time()
PHP
35 votes186 views5 answers
Remove the Last Character From a String in PHP
PHP
0 vote201 views1 answer
Php compare strings case insensitive
PHP
3 votes203 views1 answer
Laravel check if array is empty
PHP
0 vote230 views1 answer
Return json in middleware laravel
PHP Laravel
0 vote193 views1 answer
How to pass variable to an event listener laravel
PHP
1 vote220 views2 answers
419 unknown status
PHP
0 vote236 views1 answer
Heroku deploy php
PHP
0 vote250 views1 answer
Php rotate image
PHP