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 Excel sheets that I need to perform calculations with.
I am using PHPSpreadsheet to read and write, as PHPExcel is now deprecated.
The problem I am experiencing is in getting values from a specific column to perform calculations.
After going…
I'm using PhpSpreadsheet to generate Excel (.xls) file.
then I realize the mimetype of the generated file was application/vnd.ms-office.
Test with two methods:
Using this to direct download to server dir:
I am generating a XLSX file using PhpSpreadSheet and downloading it successfully by visiting a specific route like this:
$writer = new Xlsx($spreadsheet);
$writer->save('TTD-HMO-ARSUB.xlsx');
return response()->download('TTD-HMO-ARSUB.xlsx');
I see…
Problem:
What I am trying to achieve is to copy a selected range of cells from one excel spreadsheet and insert it into a newly generated one using laravel-excel and phpspreadsheet libraries. So far, the code that I've got, sort of does that but not…
I have a Laravel application deployed to Google App Engine. Per GAE's architecture rules, you cannot save files to a local path. I am using PHP Spreadsheet to generate Xlsx files and download them for the user. So this works locally but not in the…
I have my LAMP cluster with PHP7.2. I am trying to install PHPSpreadsheet, but I keep coming up with errors.
`
# composer require phpoffice/phpspreadsheet
Using version ^1.4 for phpoffice/phpspreadsheet
./composer.json has been…
I've got to generate and post a xls file to a server via curl. I just get my data from db, make the first version of the file and save it on my server, then read it and post it via curl to the remote server.
Apparently I'm having some issue with the…
I'm at my wit's end.
I installed PhpOffice using composer on my local dev machine and it works fine.
I uploaded my app code to a remote test server, then installed PhpOffice using composer on that server.
On both my local machine and the remote…
I am trying to generate a report with phpspreadsheet in two formats (xlsx and pdf). When I run my code and save in xlsx the table from the document has border but when I save it in pdf it has no border. All other things are generated in…
Im creating some new joomla components, all of them need to work exporting data into Excel, so I think PhpSpreadsheet is a good library for that requirement, but how can I install it inside of joomla? in that way all my components can use that…
I have been trying out PhpSpreadsheet, and so far it's working well. However, I'm stuck on adding an image to the spreadsheet. In my database, I have both external image URLs (ex: http://somewhere.com/imagename.png) and base64 image data. Is it…
I am currently working on a project that requires me to take an uploaded spreadsheet file (XLSX, XLS, etc), place it into an array, then based off of the parent child relationship, build an HTML table structured to display the MLM referral…
i've two php array that i want to export on an excel.
i tried this:
$tab=array_merge($tab1,$tab2);
$activeSheet = $spreadsheet->getActiveSheet()
->fromArray( $tab,
NULL,
'A1' );
and i got…
I use PhpSpreadsheet to read and write an Excel files, I would like to save the file with the style (picture, font style, color, etc).
I don't find the way in the doc of PhpSpreadsheet
I can save the file with just the data and not all the style :…
I am using the PHPSpreadsheet library to convert a generated XLSX file into a PDF. The XLSX conversion and download is working fine, but when I try to convert this XLSX into PDF I am getting empty PDF file, when I try to Opening it, it says the…
