869
questions
1
vote
1
answer
39
views
PhpSpreadsheet Date Export Issue 1900/1904
I'm trying to generate a downloadable Excel file that includes Excel dates generated from PHP timestamps. The issue is that Excel for Windows and Mac use two different base dates which are also ...
- 879
-2
votes
1
answer
64
views
PhpSpreadsheet put value of a repeated MYSQL record in a previously inserted EXCEL column
I edit the code since I managed to insert the MYSQL records into Excel, and put the data of DESCRIPCION and DIA (if tipoActividad=1) and NOMBRE_SESION and DIA (if tipoActividad=2) in their place (...
- 11
0
votes
0
answers
26
views
Issues with Drawing and Formula in PHPSpreadsheet When Modifying XLSX Template
I am working with a pre-existing XLSX workbook template that contains multiple sheets and defined charts. When I read the template and attempt to write data back into it, I encounter several issues, ...
-3
votes
0
answers
61
views
How do I load and work with PHPspreadsheet via AJAX filepath?
I'm trying to pass a filepath and sheetname via an AJAX request into my PHP script. The AJAX is working, and this is a multi-step file operation: file upload, reading of sheet tabs which get echoed ...
0
votes
0
answers
30
views
PhpSpreadsheet > Xls > Remove empty rows
I'm dealing with file 10k rows+ and I wan't to delete some of rows.
Using method removeRow from ReaderXls taking to much time and kills execution of script, so I decided to empty those rows, celby ...
- 183
0
votes
0
answers
31
views
Writing to a multi-sheet excel file using phpSpreadsheet
Is there a way to write to a specific sheet in an excel multi-sheet file using PhpSpreadsheet without the sheets in said excel file being wiped out?
The write function in phpSpreadsheet always creates ...
- 1
1
vote
0
answers
73
views
Display two HTML Tables side-by-side in Excel using PHP Spreadsheet
I am trying to display two tables side by side in an excel worksheet but the tables are getting displayed one below each other, is there a particular format I need to follow while writing the html ...
0
votes
0
answers
62
views
Error in MS Excel after filling XLSX form with PhpOffice\PhpSpreadsheet
I am using the PhpOffice\PhpSpreadsheet package to fill the fields of a SEPA.xlsx form. The fields are filled successfully, but when the filled form is saved to a new file, opening that file in MS ...
0
votes
0
answers
48
views
Combining 2 norm tables with common columns
I have a test that consists of subtests. After the user answers the questions the total of each subtest is calculated. The total is then used against norm tables to get specific data. This is one of ...
- 9
1
vote
0
answers
44
views
PHPSpreadsheet, how do I set different layout for each series in a composite graph?
I am trying to create charts in excel using the PHP library PHPSpreadSheet. But when I generate a composite graph with multiple types of graphs together, I get overlapping data labels.
Stacked bar + ...
- 11
0
votes
0
answers
51
views
PHPSpreadsheet Scatter Charts not working consistently
I am trying to (re)create a scatter chart in PhpSpreadsheet but currently there are a few things not working. I do understand that not all Excel features are implemented in PhpSpreadsheet, but I ...
- 113
0
votes
1
answer
50
views
PhpOffice\PhpSpreadsheet\Reader\Xlsx getSheetByName not working
I hate posting this because I feel like this should be simple, but I have investigated and tested many things. My script has been working fine if I want the first sheet to be read. Again, that works ...
- 409
0
votes
0
answers
137
views
Unable to access External Workbook PhpSpreadsheet on laravel
I have this issues where i get this error "Unable to access External Workbook".
I'm trying to convert an xlsx file into a pdf or html but on writer save i get this error.
I tryed in two ways:...
0
votes
0
answers
61
views
PHPSpreadSheet - Converting .xls to .xlsx or .html not copying charts or images
I'm using PHP 8.2 and PHPSPreadsheet 2.1.0 with MtJpGraphRenderer library still no luck in converting the file. Also I've tried converting it to .html still no luck.
I need solution for either .xlsx ...
- 340
0
votes
0
answers
29
views
Running PHPSpreadsheet via crontab on DigitalOcean - not saving
When I run the following script via a browser using the URL, all emails are sent, the XLSX is saved where it should be and the result is very quick.
However, when it runs via crontab, it sends me the ...
- 1,096