PHPOffice/PhpSpreadsheet

A pure PHP library for reading and writing spreadsheet files

Santosh Patel

@newblend_no8_twitter

Hi, using Phpspreadsheet to read Excel files and consume the data/metadata (not excel anymore). Is there a way to suppress adding _xlfn. to functions that Phpspreadsheet does not recognize? Getting an issue with CONCAT.

William Minerva

@WilliamMinerva3_twitter

hello

Andriy Khyliuk

@Smartop

how get row by sheet index $sheet->getRowIterator() , for example i need get only second row in current sheet without foreach?

VertZu

@VertZu

What I want is - If I have date (A2:A5) for example 1.4.2019 and I want that day's expenses (B2:B5) in format of B2+B3+B4... and so on
And if they are paid with credit card (C2:C5), I want them in same format also C2+C4+C5.. they might not have been paid with card so that needs to be left out
I want business expenses + paid with card to same row where the is already put date when they were made to another Excel file without making a new excel, just updating existing one. Is this possible with phpspreadsheet?

Adrien Crivelli

@PowerKiKi

@Smartop try something similar to:

$row = new Row($sheet, 2);

Michel Ojeda

@kristofermagic

Hello Everyone

I'm just trying to use the PhpOffice/PhpSpreadsheet with ZF3. I installed by composer and when I used then : $inputFileType = 'Xls';

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

my application show the following error: Class 'PhpOffice\PhpSpreadsheet\IOFactory' not found

Michel Ojeda

@kristofermagic

etc, etc

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 ?

Where communities thrive

People

Repo info

Activity