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

9 votes158 views7 answers
How to get plugin directory path in wordpress
PHP
0 vote169 views1 answer
Php draw line pixel
PHP
0 vote200 views1 answer
Filter from taggable laravel
PHP Laravel
0 vote154 views1 answer
Return only one column data from table in codeigniter
PHP
51 votes178 views6 answers
Join in laravel eloquent
PHP
1 vote194 views1 answer
Laravel model increase the value by one
PHP Laravel
0 vote161 views1 answer
Year shortcode wordpress
PHP
0 vote169 views1 answer
Yii 2 create migration with fields
PHP
10 votes204 views2 answers
Get current date laravel
PHP Laravel
3 votes187 views2 answers
How to change laravel port
PHP Laravel