PhpSpreadsheet is a library written in pure PHP and providing a set of classes that allow you to read from and to write to different spreadsheet file formats, like Excel and LibreOffice Calc.
I'm having trouble saving the file xlsx when the data has function
[E22] = PMT (D20 / 12, D19, -E23, D7.0)
environment:
laravel 5.8
php 7.1
phpoffice/phpspreadsheet [1.7.0] - 2019-05-26
public function gen_file_download_tt(&$result) {
…
I use the PhpSpreadsheet library to create a xls and download it but the file is corrupted. The xls will be written in the output stream, no file is created.
I tried to create an empty spreadsheet and it fails. You can see it in the following code…
I have written code to import data from excel sheet and for that I want to count total number of rows and columns.
I am using this SpreadsheetReader library.
Here is my code:
$uploadFilePath =…
I am using PhpSpreadsheet within a Laravel app to output a spreadsheet that needs fairly strict controls around it in order to allow that same spreadsheet to be input back into the app after data has been entered.
I can control the data types and…
Learning Laravel, I face now Excel export.
Searching in the Intenet Laravel Excel (docs.laravel-excel.com) seems to be the better choice, but I'm findind it very difficult to style the sheets (colors, fonts, sizes, etc.)
I'm using global event…
At work, we use PhpSpreadsheet to generate some Excel file (we use it to be able to provide some export).
Here is the simple code I use (based on some example given but PhpSpreadsheet) to generate a file:
I have a problem with my code. I generate an excel file unsing PhpSpreadsheet lib. So i can write my data and it worked fine. I add a data validation list in a cell using an other worksheet and it work too. So I try to add in a cell a formula which…
I have cell content looks like "$ 1440" or "€ 970"
But on formula-field (after select cell) value looks like simple number "1440" or "970".
How can I get currency sign ($ or €) by using PhpSpreadsheet?
I tried code
$reader =…
I'm trying to insert dinamically an image in the footer of an Xlsx document, using PHPSpreadsheet library.
I tried to modify the sample of documentation, but nothing appears when I print the doc.
$inputFileName = './tpl1.xlsx';
$spreadsheet =…
I am working on a project, in which XLS file needs to be uploaded to the server and extract its content. When I worked on my localhost it was working perfectly, but after I uploaded the project on the server, phpSpreadSheet library started not…
I have dynamic data. So my data can change
besides that I also have a data signature that cannot be separated.
This signature data must be on the same page. See the red mark in this image :
It is a unit and cannot be separated. Signature…
OK, so I have an Excel spreadsheet with 15 sheets full of formulae. I am under an NDA and cannot show you the spreadsheet. I am required to programmatically input values submitted by web users, calculate the outputs and return the results to the…
I have created a AJAX function that runs on a click event on the front end. Inside this function I want to be able to generate a XLS Spreadsheet but I am unable to do this inside the function. I believe its to do with me declaring the use statements…
I am using 33_Chart_create_scatter.php to generate a XY scatter chart. I am closing in on completion. All I have left is inducing the linest function. Would someone please provide some code on the use of linest in phpspreadsheet?
I've done a lot of…
I'm exporting a list of some resource into a xlsx file, where each resource has both English and Hebrew fields.
The problem is that scrolling the worksheet is utterly slow.
The slowness has been experienced using Microsoft Excel in multiple PCs,…
