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

16 votes335 views2 answers
Php get first character of each word
PHP
1 vote314 views2 answers
Phpmailer addAttachment
PHP
5 votes326 views3 answers
Laravel permission denied storage log
PHP Laravel
-1 vote324 views1 answer
Can i install php7.4 inside vagrant homestead
PHP
4 votes411 views2 answers
Laravel attach
PHP Laravel
0 vote359 views1 answer
Disable sidebar widget wordpress 5.8
PHP Wordpress
7 votes377 views6 answers
Show featured image in post wordpress
PHP Wordpress
13 votes344 views3 answers
Php split string by underscore and dot
PHP
5 votes313 views2 answers
How to clear session in laravel
PHP
0 vote313 views1 answer
Remove text keep numbers only php
PHP