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

2 votes315 views2 answers
Route codeigniter
PHP CodeIgniter
2 votes295 views1 answer
Get user ip laravel
PHP Laravel
3 votes307 views6 answers
Laravel jwt token
PHP Laravel
0 vote263 views1 answer
Laravel imap - Set message flags
PHP
0 vote268 views1 answer
'laravel'
PHP Laravel
0 vote213 views1 answer
Laravel sintax
PHP
1 vote250 views2 answers
Install php unzip
PHP
0 vote260 views1 answer
If order has product id in array
PHP
9 votes251 views2 answers
Laravel query count raw
PHP
0 vote200 views1 answer
Wp php get rows number from mysql
PHP