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

1 vote320 views2 answers
Shorthand to assign multiple variable to same value in php
PHP
0 vote404 views1 answer
Drop foreign key laravel eloquent
PHP Laravel
0 vote435 views1 answer
Php auto reset score
PHP
40 votes330 views2 answers
$dom->getElementById
PHP
2 votes328 views2 answers
Wordpress is admin
PHP
3 votes355 views1 answer
Enie letter validation laravel regex
PHP
15 votes366 views6 answers
Remove spaces from string php
PHP
5 votes368 views3 answers
Delete all rows in table laravel foreign key
PHP
-1 vote342 views3 answers
@forelse laravel
PHP
1 vote387 views1 answer
Laravel createmany example
PHP Laravel