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 have an Xlsx file content in a string, loaded from the database.
Currently, I create the spreadsheet using a temp file:
file_put_contents($fileName, $bundle['package_blank']);
$wobook =…
I have used Composer to install phpoffice/phpspreadsheet. It was installed in a base 'vendor' directory. However where I am needing to use it is in a subdomain directory.
I manually moved it to a different 'vendor' directory.
a bit deeper…
I am really mad at PHPSpreadsheet, and why the functions are not named as in PHPExcel, or why in documentation doesn't mention something about "PHPExcel_Worksheet_Drawing", where can I find it in PHPSpreadsheet?.
In PHPExcel I have this:
$objDrawing…
I'm trying to get value from a cell using getFormattedValue, in the cell it is showing as 22 5/8 and the value I'm getting from getFormattedValue is 23\ ?/8
If I use getCalculatedValue I'm getting the value 22.64
How I can fix this issue?
I am using PhpSpreasdheet php library. I have done almost everything i want to sum the particular column and want to show total of that column.. See My output is coming below:-
My expected output like below:-
I have tried below code:-
$spreadsheet…
Is this possible? or must one use a PHP library such as thephpleague/csv?
Example, according to PhpSpreadsheet's documentation:
$reader = new \PhpOffice\PhpSpreadsheet\Reader\Csv();
$spreadsheet = $reader->load($file);
$writer = new…
Hi I have a little problem with this plugin, this is the code that makes an error
Sheet::macro('setPageMargins', function (Sheet $sheet, float $top = 1, float $right = 0.75, float $bottom = 1, float $left = 0.75) {
…
I am trying to populate a mysql database with an excel file using phpspreadsheet library. I am doing it in the following way but I get just the first row. How can I do it for all the rows
$spreadsheet =…
I'm currently using PhpSpreadSheet Library and I wanna write into an existing spreadSheet. Is that possible?
If yes, how? I didn't see any possibility in the documentation.
Thanks!
What I want to realize
I will use PhpSpreadsheet in a PHP web application development,
I am trying to configure PHP Zip extension necessary for PhpSpreadsheet to be enabled on the server.
I tried two methods, but I could not set it well, so I would…
I'm trying to read an XLSX file by chunks. But some of the chunks are empty on the var_dump out put.
I'm using PHP7.2 and Laravel 5.5 framework.
That is what I've tried so far:
Filter
class ChunkReadFilter implements IReadFilter
{
private $startRow…
I am using PHPSpreadsheet now, I am trying to get rows to auto height. It is working fine in MSOffice But Not work in LibreOffice.
Question How to make the row auto height work in LibreOffice latest version. Works fine in…
I am using PhpSpreadsheet to modify an existing file and send it to the browser, but every time I download the file excel gives me the following error:
We found a problem with some content in filename.xlsx. Do you want us to try and recover as much…