private function readExcelFile( $inputFileName )
{
$inputFileType = 'Xls';
{
$inputFileType = 'Xls';
$reader = IOFactory::createReader($inputFileType);
$reader->setReadDataOnly( true );
$spreadsheet = $reader->load($inputFileName);
$sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
return $sheetData;
}
there is nothing specific with ZF3
oh, and of course triple-check that you
require_once 'vendor/autoload.php'; somewhere in your project, but that must be already the case if you use ZF3
on a final note, use triple backticks (`) blocks to properly format code in this chat
Returns NULL Whats wrong?
If somebody can help, that would be super nice
I just made the migration of a project using PHPExcel to PHPSpreadsheet, and all is fine BUT one thing
Messed up Cell Background Color
and it's driving me crazy because it has a high visual impac
I load an Excel Template Sheet, then Fill it in, then Save it
and in the process, without even touching some cell, it changes some of their background color
which did not happen at all in PHPExcel
so I guess there is something off with PHPSpreadsheet way of handling Cell Background Color
@jeremie.asaro_gitlab the best would be to create a Minimal, Complete, and Verifiable example of code that exhibits this issue and submit an issue, or even better a PR for it.
I have a .xlsx file which looks to be generated by SpreadsheetLight (based on looking at the theme.xml file). PhpSpreadsheet is not accurately opening it. Has anyone else seen issues like this? Where do I begin to debug this?
Note LibreOffice opens the file just fine without any type of warnings or issues.
Note LibreOffice opens the file just fine without any type of warnings or issues.
I have a .xls file having a formula in formula bar, when i am trying to read it out by calculated value getting formula error.
I have an SQL query that returns the rows in json format, I'd like to just convert it straight to csv, or xls and generate a download
@xeon826 no, it's not, see https://github.com/PHPOffice/PhpSpreadsheet/issues/28#issuecomment-399120802 and the other related posts over there
@jerikothomas you have an example of line chart here that I guess you can adapt to your data. https://github.com/PHPOffice/PhpSpreadsheet/blob/master/samples/Chart/33_Chart_create_line.php
Hi , I am using phpspreadsheet library in Zedn 3 Framework.
I have copied the folder and pasted it in my vendor directory, now how can I register this library and use its namespaces in my own module
I have copied the folder and pasted it in my vendor directory, now how can I register this library and use its namespaces in my own module
Is there anywhere documenting the Release process and Schedule? I see the next milestone is for 2.0; however, the last release was 1.6 on Jan 1. There are very useful commits on master fixing bugs within the codebase. Will there be a 1.6.1 or 1.7 which come out before 2.0 ?
@rammogal copying the folder will not work, instead delete the things you copied and follow the instruction there: https://phpspreadsheet.readthedocs.io/en/latest/#installation
@isleshocky77 there is no formal release schedule. I try to release roughly every month, but I've been particularly busy lately. I'll see what I can do in the coming days...
@PowerKiKi Awesome.. Yeah, I saw you were releasing monthly if not bi-monthly for the last part of 2018 (which got me excited), but that release is now Jan 1. I've pinned my dependency to dev-master#commitish for now. Thanks for the response and for the hard work. Interesting enough I came across the
getHighestColumn() bug today and thought I must be crazy or using it wrong. Then I found the Unit test and fix for it which happened very recently. Worked like a charm.
