PHPOffice/PhpSpreadsheet

A pure PHP library for reading and writing spreadsheet files

Dan Eveland

@duckydan

@kristofermagic Hi, this might be super basic, but did you put in the “Use” lines to load the classes?

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

Michel Ojeda

@kristofermagic

yes, I did!

use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;

private function readExcelFile( $inputFileName )
{
$inputFileType = 'Xls';

    $reader = IOFactory::createReader($inputFileType);

    $reader->setReadDataOnly( true );
    $spreadsheet = $reader->load($inputFileName);

    $sheetData = $spreadsheet->getActiveSheet()->toArray(null, true, true, true);
    return $sheetData;
}

Dan Eveland

@duckydan

@kristofermagic I just started working with this yesterday. Wish I could help.

Michel Ojeda

@kristofermagic

thanks a lot. Me too. I was developing some test from my local and it worked pretty good, but with ZF3, I could not.

Michel Ojeda

@kristofermagic

Somehow, the IDE perfectly recognizes the namespace and take me to the scripts definitions when I click it over without no problem. would it be something related to autoload.

Michel Ojeda

@kristofermagic

@PowerKiKi How can I use this in ZF3??

Adrien Crivelli

@PowerKiKi

@kristofermagic try composer install so that composer re-generate the autoloader

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

VertZu

@VertZu

$KolumnDate = 1; // kolumn 1 = B
for ($RowDate = 1; $getOrder->getCellByColumnAndRow($KolumnDate,
$RowDate)->getFormattedValue() == "4/1/2019"; $RowDate++) {
if ($getOrder->getCellByColumnAndRow($KolumnDate, $RowDate)->getFormattedValue() == "4/1/2019" );
{
echo $RowDate;
}
}

Returns NULL Whats wrong?

Adrien Crivelli

@PowerKiKi

@VertZu please format your code correctly with markdown syntax if you wanna get helped

Michel Ojeda

@kristofermagic

@PowerKiKi Thanks a lot. I appreciate your help. I'll try and let you know about it.

Michel Ojeda

@kristofermagic

@PowerKiKi Sorry it does not work for me. I tried but I was checking on my z-ray and I saw in the classes map and I could not be able to see PhpSpreadsheet for anywhere.

Jérémie Asaro

@jeremie.asaro_gitlab

Hello everybody

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

Jérémie Asaro

@jeremie.asaro_gitlab

if i switch the template from XLS to XLSX, i get different cell changed & different color result

if i open & save the template with LibreOffice, same

so I guess there is something off with PHPSpreadsheet way of handling Cell Background Color

Adrien Crivelli

@PowerKiKi

@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.

Stephen Ostrow

@isleshocky77

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.

hemant123misha

@hemant123misha

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.

xeon826

@xeon826

Is it possible to generate the download to php://output without writing it to the file system first?

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

Adrien Crivelli

@PowerKiKi

@xeon826 no, it's not, see https://github.com/PHPOffice/PhpSpreadsheet/issues/28#issuecomment-399120802 and the other related posts over there

Timothy

@tdawes33

Is there a way to get the hash of a sheet before loading it? It seems like listWorksheetInfo() would provide that if it exists Doing a compare between two identical (and complex) sheets requires loading/processing the entire sheet according to my understanding.

Thomas Kristian Jeriko

@jerikothomas

is there a way to create chart from time (over 24 hours) base values ?

Fräntz Miccoli

@frantzmiccoli

@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

Ram Mogal

@rammogal

Hi , I am using phpspreadsheet library in Zedn 3 Framework.

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

Stephen Ostrow

@isleshocky77

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 ?

Adrien Crivelli

@PowerKiKi

@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...

Stephen Ostrow

@isleshocky77

@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.

Rico29

@Rico29

Hello, I'm trying for hours to get the background color of a cell in an ODS file. I tried many many ways, but I never found what I'm looking for. can somebody point me in the right direction please ?

Rico29

@Rico29

It works fine when converting file to xlsx, with $spreadsheet->getActiveSheet()->getStyle('B2')->getFill()->getStartColor()->getRGB();

deepakjoshii

@deepakjoshii

3.00 values changes to 3 in excel sheet

graslo

@graslogamer_twitter

Just installed with composer. Trying out samples but can't find them. Where is the /tmp/ folder supposed to be?
Running sample tells me: "20:49:40 Write Xlsx format to /tmp/phpspreadsheet/01_Simple.xlsx in 0.0325 seconds"
But can't find that anywhere

Adrien Crivelli

@PowerKiKi

@graslogamer_twitter /tmp/phpspreadsheet/01_Simple.xlsx is an absolute path. It exists at the root of your filesystem, not in your current folder/project. Copy/paste that path exactly as is in your favorite spreadsheet editor and it should be able to find it

Where communities thrive

People

Repo info

Activity