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

19 votes148 views6 answers
Query builder laravel
PHP Laravel
0 vote146 views1 answer
Add user role to wp admin page css
PHP
2 votes142 views2 answers
Php mysql update all rows in table new values
PHP
0 vote127 views1 answer
What’s New in PHP 8
PHP
0 vote182 views2 answers
DB::raw update query in laravel
PHP Laravel
0 vote126 views1 answer
Except String and Numbers replace all special characters in php
PHP
0 vote91 views1 answer
Php pcntl
PHP
2 votes92 views1 answer
Wp_dequeue_style
PHP
1 vote155 views1 answer
Change the method name in resource in laravel
PHP
0 vote121 views2 answers
Php multi elseif statement ternary
PHP