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

10 votes328 views6 answers
Format time laravel
PHP
0 vote321 views1 answer
Test php for errors terminal
PHP
0 vote333 views1 answer
\PDO::ATTR_EMULATE_PREPARES => true Security issue
PHP
21 votes338 views4 answers
How to host a php server
PHP
0 vote328 views1 answer
Get data from model in chunks laravel
PHP
0 vote388 views1 answer
Creating random number betwwen ranges in php
PHP
0 vote313 views3 answers
Php find multiple value in array
PHP
19 votes358 views6 answers
Query builder laravel
PHP Laravel
0 vote323 views1 answer
Curl error handling
PHP
0 vote336 views1 answer
Best web server for php
PHP