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 installed phpspreadsheet on my subdirectory banana(OMG.com/fruits/banana).
And tried to open its sample page.(banana/vendor/phpoffice/phpspreadsheet/samples/index.php)
But it didn't work.
So I followed source, and changed css and js path on…
This isn't particularly a coding question.
I have a script running locally (PHP V5.6) and it's absolutely perfect.
However, I FTPd it to our dev server to run as a cron and it failed. Our server has php v5.5 running for dependancy issues. Is there…
I have a php script that creates an excel file with 2 worksheets. The first sheet is perfect because it's formulating values for records belonging to individual users, so I've used an associative array using their user Id as the index.
The 2nd sheet…
Looking at programs like PHP Excel and the newer PHPSpreadsheet, I'm hoping to send results from my mysqli query to Excel in a formatted workbook. However, rather than having the data come into rows, I need each record to display in…
How I can use PhpSpreadsheet (new version of PHPExcel) but without install Composer.
I trying to use with Third_party but print an error like this:
"Fatal error: Class 'PhpOffice\PhpSpreadsheet\Spreadsheet' not found in…
I'm trying to finish a script that I've been working on for a while now and I just can't get this last part figured out.
Currently, the script below gives me this output:
Which is correct except after each users' records I only have the header row…
I have an issue with getting image and text data from excel file.Well currentlly i'm using PHPspreadsheet library for getting data from excel. So it's gives me image data but not giving me text data. if i looking for text data than it was not…
I can read an xlsx file using PHPSpreadsheet just fine. The problem is that when I try to write it out to PDF the result is blank when I bring it up in Acrobat, even though the PDF file is about 840K.
I have tried Mpdf and Dompdf but they either…
I'm currently trying to fix this script to create a spreadsheet with formulas based on the current data coming from a mySql query. The query is getting excatly what it should and I finally got my loops to print the rows correctly.
Here's an image of…
I'm still stuck with symfony2 and phpexcel..
First I don't know why my HTML writer doesn't generate tags..
I don't understand why blanks columns still displaying as you can see on this screenshot, a ReadFilter is applied:
I just want…
i convert an excel file to HTML Table with PHPExcel
(PHPspreadsheet) with Symfony 2.5
I'm trying to set a filter to only load the range ('A','N') , the first 13 columns. not working..
I'm also trying to set the Width of the 'N' Column. not…
I'm using PhpSpreadsheet Library ( https://github.com/PHPOffice/PhpSpreadsheet ) to read uploaded excel file. The excel files contains html tags and html special characters. Im getting wrong results as my function iterate through the cells.
Sample…
I am working on "export to excel" sheet functionality using "PhpOffice\PhpSpreadsheet" library, till export to excel sheet working fine but My Problem here is that I have a total amount column where I have to add Indian currency symbol. I searched…
We were using Excel but now started using Spreadsheet as it is the future.
Recently in our app, i have to make a change,
This is our excel file logic.
FROM
var $excel_start_row_index=1;
var $excel_start_column_index=0;
TO
var…
I am trying to use text Rotation to 90 to have cell with vertical text, but it is not working, all text shown horizontally, maybe I make something wrong?
Here is my php code
$spreadsheet = new Spreadsheet();
// Create a new worksheet called…
