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 vote119 views1 answer
Set laravel local time to indonesia
PHP Laravel
-1 vote117 views3 answers
Delete rows by migration laravel
PHP
0 vote117 views4 answers
Prestashop 1.7 smarty global variables
PHP
0 vote138 views1 answer
Laravel redis sentinel
PHP Laravel
8 votes129 views4 answers
Laravel model soft delete
PHP Laravel
6 votes132 views3 answers
Laravel passport login with username
PHP Laravel
0 vote109 views1 answer
Php convert string to chars
PHP
0 vote114 views1 answer
Remove dashboard mya ccount
PHP
0 vote136 views1 answer
Move post to draft php wordpress
PHP Wordpress
0 vote153 views1 answer
How to auto calculate price in mysql table and php
PHP