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 vote122 views1 answer
Install a package only composer dont update
PHP
1 vote125 views1 answer
Http error 500 phpmyadmin
PHP
0 vote144 views3 answers
Laravel model where in
PHP
0 vote176 views1 answer
Comment créer automatiquement une méta description à partir de votre contenu dans WordPress
PHP
0 vote119 views1 answer
Symfony header token authorization
PHP
2 votes129 views1 answer
Admin bar hide
PHP
0 vote148 views4 answers
Laravel old value for select option
PHP Laravel
0 vote145 views1 answer
Laravel relationship retrieve data
PHP Laravel
2 votes122 views2 answers
Laravel validate form data unique
PHP
0 vote156 views1 answer
Ubuntu 18.04 php is not working
PHP