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

23 votes169 views2 answers
Serve php file
PHP
7 votes176 views1 answer
Laravel db seed specific class
PHP
-1 vote204 views1 answer
Tackel discount in javascript
PHP
1 vote185 views2 answers
Return response at failedValidation() in request laravel
PHP Laravel
-2 votes183 views3 answers
Laravel when condition
PHP
0 vote241 views1 answer
Laravel collection intersectKey
PHP Laravel
12 votes188 views6 answers
Php convert datetime to timestamp
PHP
0 vote194 views1 answer
Php fire an event
PHP
104 votes299 views6 answers
String length php
PHP
1 vote133 views1 answer
How to string value count words without use count value in php
PHP