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

1 vote156 views1 answer
Google translate api php
PHP
0 vote153 views1 answer
Image not save laravel
PHP Laravel
5 votes153 views3 answers
Php.ini location mac
PHP
2 votes163 views2 answers
How unset request parameter in laravel
PHP Laravel
2 votes153 views2 answers
Php artisan serve specify ip
PHP
2 votes134 views1 answer
How copy database from phpmyadmin
PHP
0 vote135 views1 answer
JQuery is not defined load-scripts.php
PHP
0 vote237 views3 answers
Best wordpress functions to include
PHP
0 vote124 views1 answer
Laravel access storage attachment
PHP
12 votes179 views4 answers
Wordpress get post thumbnail
PHP