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

2 votes284 views1 answer
Laravel create txt file
PHP Laravel
2 votes291 views1 answer
Php convert minutes to hours and minutes
PHP
0 vote574 views1 answer
How to get n days from today in php
PHP
-1 vote281 views2 answers
Map array php
PHP
1 vote246 views2 answers
Select max laravel
PHP
0 vote361 views2 answers
Symfony get query param
PHP
0 vote282 views1 answer
How to get many of quensation php programming language
PHP
0 vote313 views1 answer
Php mysqli connect to two databases pdo
PHP
0 vote308 views1 answer
Doctrine query builder order by multiple
PHP
1 vote285 views1 answer
Behamin bresource collection
PHP