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

6 votes231 views6 answers
Install php 7.3 ubuntu
PHP
0 vote224 views1 answer
$name = $name; "Robert" echo;
PHP
1 vote224 views1 answer
How to use md5 in php
PHP
1 vote223 views3 answers
Get all post meta
PHP
0 vote240 views1 answer
Laravel in array blade
PHP Laravel
11 votes219 views4 answers
Laravel create resource controller
PHP Laravel
1 vote225 views4 answers
Laravel flash message
PHP
0 vote276 views2 answers
Symfony get query param
PHP Symfony
22 votes217 views6 answers
Php write to file
PHP
9 votes218 views3 answers
Laravel download
PHP Laravel