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 vote288 views1 answer
How to remove notice error in php
PHP
0 vote280 views1 answer
Php jquery plus 1 day
PHP
0 vote281 views1 answer
Envoyer des donnees js a php
PHP
0 vote260 views1 answer
How to get yearly chart in laravel
PHP
1 vote315 views4 answers
Brew downgrade php
PHP
0 vote288 views1 answer
Numeros positivos input laravel
PHP
14 votes404 views6 answers
Get featured image url in wordpress
PHP Wordpress
0 vote288 views1 answer
Laravel blade php variable concatenate javascript variable
PHP
0 vote280 views1 answer
Php decode stdclass object
PHP
7 votes290 views4 answers
Laravel chunk
PHP Laravel