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 votes237 views2 answers
Server array in php
PHP
3 votes236 views1 answer
How to get video duration in php
PHP
19 votes254 views3 answers
Check if array is empty php
PHP
0 vote224 views1 answer
Larvel check two password
PHP
0 vote218 views1 answer
Geoip php sample
PHP
2 votes257 views1 answer
Laravel Call to a member function diffForHumans() on string
PHP Laravel
6 votes263 views5 answers
Check php version linux terminal
PHP
0 vote270 views1 answer
Laravel check if model relation exists
PHP Laravel
1 vote241 views1 answer
Validate timestamp php
PHP
0 vote230 views3 answers
GetClientOriginalExtension laravel
PHP