Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Jan 02 2019 01:38

    PowerKiKi on 1.8

    Permanently archive the project… (compare)

  • Dec 25 2018 02:52
    yuyuanxia opened #1433
  • Dec 18 2018 18:19
    arya108 commented #443
  • Dec 17 2018 22:01
    dpbuzz opened #1432
  • Dec 17 2018 16:17
    csrnontol commented #1351
  • Dec 17 2018 13:20
    sirber commented #1351
  • Dec 17 2018 04:22
    csrnontol opened #1431
  • Dec 17 2018 04:05
    csrnontol commented #1351
  • Dec 14 2018 06:57
    radekdostal closed #1430
  • Dec 14 2018 06:57
    radekdostal commented #1430
  • Dec 14 2018 06:48
    radekdostal opened #1430
  • Dec 10 2018 09:02
    cifren closed #205
  • Dec 07 2018 05:09
    mrmoll commented #1429
  • Dec 07 2018 05:07
    mrmoll opened #1429
  • Dec 06 2018 10:51
    pranavwhiz commented #1304
  • Dec 06 2018 10:50
    pranavwhiz commented #1304
  • Dec 05 2018 13:46
    enfoqueNativo opened #1428
  • Dec 05 2018 08:15
    myloveGy edited #1427
  • Dec 05 2018 08:10
    myloveGy opened #1427
  • Dec 05 2018 05:46
    billynoah commented #1096
Mark Baker
@MarkBaker
XfIndex is a pointer to the style for the cell
Ghost
@ghost~55a299745e0d51bd787b23e9
will PHP excel be discontinued since phpspreadsheet is around?
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
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
Hi
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?