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 vote189 views1 answer
Send var in header php
PHP
0 vote231 views1 answer
Drupal 9 how to render a view block from render array with arguments
PHP Drupal
1 vote337 views1 answer
Include a file in laravel controller
PHP Laravel
0 vote253 views1 answer
How to disable a button in a blade file
PHP
0 vote227 views1 answer
Laravel permission create role
PHP Laravel
0 vote205 views1 answer
Wordpress wpdb delete
PHP Wordpress
0 vote193 views10 answers
Laravel sanctum
PHP
0 vote269 views1 answer
Enqueue font awesome wordpress
PHP
0 vote185 views1 answer
Php pdo setting error modes
PHP
0 vote334 views1 answer
Php differenza giorni tra date
PHP