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

5 votes272 views5 answers
Install php version 7.3 ubuntu
PHP
3 votes274 views1 answer
Laravel firstOrFail
PHP
2 votes331 views2 answers
Laravel foreach first
PHP Laravel
0 vote337 views1 answer
Laravel request input default value
PHP Laravel
0 vote309 views2 answers
Laravel store file
PHP
0 vote273 views1 answer
Php get cookie by name preg_match
PHP
1 vote278 views2 answers
Laravel blade dump
PHP
34 votes328 views6 answers
Laravel create controller with methods
PHP Laravel
0 vote297 views1 answer
Message mkdir() invalid path filename drivers/session_files_driver.php
PHP
0 vote283 views1 answer
If any comma in string in php
PHP