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 vote241 views2 answers
Redirect previous page
PHP
1 vote186 views1 answer
Wp_redirect to home page
PHP
0 vote191 views1 answer
How to find the name of login user in laravel
PHP Laravel
1 vote285 views1 answer
Laravel mongodb delete
PHP
0 vote239 views1 answer
Pass address of array in php
PHP
3 votes191 views2 answers
Create .env file in laravel with cmd
PHP
-1 vote220 views3 answers
Install php debian 10
PHP
0 vote376 views1 answer
Wordpress get archive title
PHP
0 vote158 views1 answer
Part of url php
PHP
3 votes248 views2 answers
Laravel 7 view @php
PHP Laravel