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 vote110 views1 answer
Php tools for visual studio package did not load correctly
PHP
0 vote109 views1 answer
Wordpress pagination custom arrow
PHP Wordpress
0 vote90 views1 answer
Php isset post
PHP
1 vote113 views2 answers
Symfony get current datetime
PHP
11 votes160 views5 answers
Php get json array
PHP
20 votes100 views6 answers
Php array sort by key
PHP
7 votes123 views2 answers
Date time format for laravel validation
PHP Laravel
3 votes96 views3 answers
Php pluck from array of objects
PHP
2 votes104 views2 answers
Twig ternary
PHP
0 vote100 views1 answer
Multiplication des variables sur laravel
PHP