PHPOffice/PHPExcel

DEPRECATED - instead go to https://gitter.im/PHPOffice/PhpSpreadsheet

Adrien Crivelli

@PowerKiKi

@gavinkalika yes it eventually will be

Ghost

@ghost~55a299745e0d51bd787b23e9

cool

@PowerKiKi is there a timeline of when that would happen?

Adrien Crivelli

@PowerKiKi

"soon" for a beta is the best I can do for now

Ahmed Attia

@ahmed0007

hi all iam new here

wind

@502923093

when i use wps edit the xlsx files ,then it loaded error happens

like this :ERROR: Allowed memory size of 335544320 bytes exhausted

i add it in class PHPExcel_Worksheet function: public function shrinkRangeToFit $range = str_replace('$', '', strtoupper($range)); it fixed the bug,but i don't know it can take other bugs?

Miko Chu

@meSmashsta

hello guys!

I have some questions about PHPExcel

Is anyone online?

Adrien Crivelli

@PowerKiKi

@meSmashsta, ask your question and somebody might answer

Miko Chu

@meSmashsta

How do I show the Excel file to the browser? You know like a preview before exporting it

Adrien Crivelli

@PowerKiKi

This could work:

$objWriter = new PHPExcel_Writer_HTML($workbook);
$objWriter->save('php://output');

Miko Chu

@meSmashsta

@PowerKiKi And that will show it to my browser like a pdf? Do I need to change the header too?

Adrien Crivelli

@PowerKiKi

Have look at http://phpspreadsheet.readthedocs.io/en/develop/topics/reading-and-writing-to-file/#html. That doc also applies to PHPExcel. And yes you'll have to remove any special headers you might be using when exporting Xls/Xlsx

Miko Chu

@meSmashsta

@PowerKiKi I'm using PHPExcel, which is not PHPSpreadsheet, can I do that in PHPExcel?

Adrien Crivelli

@PowerKiKi

read my message

Miko Chu

@meSmashsta

how do I do this $reader = new \PhpOffice\PhpSpreadsheet\Reader\Html(); in PHPExcel?

Adrien Crivelli

@PowerKiKi

new PHPExcel_Reader_HTML

you'll find the same doc in PHPExcel repository with correct code by the way if you look for it

Miko Chu

@meSmashsta

Thanks man!

Adrien Crivelli

@PowerKiKi

no worries

Miko Chu

@meSmashsta

How can I style the table? I can't seem to find it in the docs

Adrien Crivelli

@PowerKiKi

I don't think there is anything special about it

It's not really the point. You should format things via PHPExcel features, not via CSS

Miko Chu

@meSmashsta

In Github I can't find the documentation that shows how to format things via PHPExcel features, which section is it in?

Currently I am viewing the examples to know how to format stuff but reading the docs would be nicer xD

Adrien Crivelli

@PowerKiKi

should be around there: https://phpspreadsheet.readthedocs.io/en/develop/topics/recipes/#styles

Miko Chu

@meSmashsta

Thanks @PowerKiKi, you're godsend.

panjidia995

@panjidia995

hello guys , i'm new at phpexcel, i have a question, is there any possible way to use phpspreadsheet without using composer?, because i'm using shared hosting right now, thanks before

Adrien Crivelli

@PowerKiKi

@panjidia995 no, there is no way. But you can use composer locally and upload everything, including ./vendor to your host

panjidia995

@panjidia995

oh thanks @PowerKiKi , i got it, that means i can search for package that needed and add it manually?

Adrien Crivelli

@PowerKiKi

no, it means you do everything locally, by using composer the normal way. And when everything is done, you zip the entire project and upload everything to your host

panjidia995

@panjidia995

@PowerKiKi oh i'm sorry i didn't got it before, but thanks saving my day it work

andreipreotu

@andreipreotu

Hi all! I have a problem with updating cell reference in another worksheet after adding columns and rows

Example: Sheet AAA : cell D4, Sheet BBB: cell A! with value AAA!D4 . After adding rows and columns in sheet AAA i would like that in sheet BBB the reference of D4 to change to the current location. So after adding rows and columns in AAA sheet, the cell moves from D4 to E6, but in sheet BBB it still remains D4. Could you help please?

Adrien Crivelli

@PowerKiKi

@andreipreotu so the formula using cells from another sheet is not correctly updated when columns/rows are inserted into that sheet ? This might be a bug. I believe PHPExcel should update formula in this case, at least for formulas on the same sheet. Maybe you could check for that first. Does it work on the same sheet ? and if yes, why doesn't it on a different sheet ?

andreipreotu

@andreipreotu

@PowerKiKi the formula is updating for the same sheet. It's not updated when it refers to other sheets ex: =Sheet1!C5

Adrien Crivelli

@PowerKiKi

@andreipreotu can you reproduce all of that with PhpSpreadsheet also ?

Mark Baker

@MarkBaker

PHPExcel has never adjusted formulae on other sheets when inserting/deleting rows/columns in one sheet because it's a big performance overhead. Unlike MS Excel itself which uses a reference map to link all formulae referencing a cell making it easy to identify which cells need updating, we can't afford the memory that requires; so we use a brute force approach checking every cell... to keep execution times as low as possible, we made a decision to only apply that brute force check to the current worksheet

Rianley

@Rianley

I need help！

Anybody here?

Paulo Victor Leite Lima Gomes

@pvgomes

Hi @Rianley what do you need?

Daniel Hernán Vargas Osorio

@danvaros

Hi, any there?

Adrien Crivelli

@PowerKiKi

@danvaros, and everyone else in the future, you better ask your questions right away, instead of waiting for someone to say hi. That way you'll save both our time

jbax

@jb181991

is there a demo for PHPexcel?

hello

Adrien Crivelli

@PowerKiKi

@jb181991 there is no hosted demo, but the doc is over there: http://phpspreadsheet.readthedocs.io

Where communities thrive

People

Repo info

Activity