Our software is designed to track work hours, so we need to generate Excel files that include negative time values. According to the PhpSpreadsheet documentation: Note that the baseline date itself is day 1; so strictly speaking, the base date…
I Have a function that reads a xls on php, transforms it, and returns it in csv, heres the html <!DOCTYPE html> <html> <head> <title>Import</title> </head> <body> <h1>File upload</h1> <form method="POST" action="process.php" enctype="multipart/form-data"> <label>File</label> <input type="file" name="arquivo"><br><br> <input type="submit" value="send">…
I use the following small PHP script using the PhpSpreadsheet library 1.29. Unfortunately I can't get the script to open an excel sheet. I don't get any error messages. On my Windows PC I use XAMPP Version: 8.2.4 On the…
I am running Win 11 and here are the versions of the relevant components, I believe X:MacifMikeBricePHPappsMacif>composer -V Composer version 2.5.4 2023-02-15 13:10:06 X:MacifMikeBricePHPappsMacif>php -v PHP 8.3.0 (cli) (built: Nov 21 2023 17:48:00) (NTS Visual C++ 2019 x64) Copyright (c)…
I'm using PhpSpreadsheet to read a specific value from a local xlsx file, but it's taking 510ms, which is too slow. I need it to be under 20ms, similar to reading from a CSV file with the same data in…
I have two modules (myModuleA and myModuleB) on a PrestaShop website that are using different version of the library phpofficephpspreadsheet. The problem is that when I call a method from phpofficephpspreadsheet in myModuleA, it's start using myModuleB phpofficephpspreadsheet method. Example:…
I'm facing an issue while exporting Excel using PHP Spreadsheet and CodeIgniter 3 in PHP 8.2. The error message is shown in the following image: Here is the code snippet that I'm using: $fileName = 'activityReport.xlsx'; $this->load->library('ciSpreadsheet'); $spreadsheet = new…
installing maatwebsite/excel with Laravel 9 but getting phpoffice and PHP version issues. I am using PHP 8.1, I downgrade to PHP 8.0 but still doesn't work. Even I enable the gd extention from the php.ini file. I am installing maatwebsite…
I have tested this on 7.2 and it's working. When I move this code to 7.3 it's not working. I installed PHPSpreadsheet without using composer <?php namespace PhpOffice; include ".PhpOfficeautoload.php"; use PhpOfficePhpSpreadsheetSpreadsheet; use PhpOfficePhpSpreadsheetWriterXlsx; use PhpOfficePhpSpreadsheetStyleBorder; use PhpOfficePhpSpreadsheetStyleColor; $htmlString =…