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

0 vote202 views1 answer
Laravel Deployment to google cloud app engine flexible environment app.yaml file
PHP
8 votes164 views2 answers
Store file into specific directory laravel using storage facade
PHP
0 vote155 views1 answer
Laravel: Unknown: Failed opening required 'server.php' (include_path='php\PEAR
PHP
0 vote196 views1 answer
Livewire modal to datetime-local
PHP
0 vote169 views1 answer
How to print image just on side where upload php
PHP
0 vote196 views1 answer
How to pass token with post request laravel
PHP Laravel
0 vote145 views1 answer
How to make:trait in commend line in laravel
PHP
1 vote160 views1 answer
Php translate url wpml
PHP
1 vote178 views1 answer
Date format in laravel month name day name
PHP Laravel
0 vote159 views1 answer
Larevel version artisan
PHP