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
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?
hello
Adrien Crivelli
@PowerKiKi
@jb181991 there is no hosted demo, but the doc is over there: http://phpspreadsheet.readthedocs.io
and the repo contains lots of samples that can easily be ran locally, see http://phpspreadsheet.readthedocs.io/en/develop/#learn-by-example
@jb181991 oh, I just realized I am talking about the wrong project. But docs and samples for PhpSpreadsheet are very similar to PHPExcel. And anyway if you are starting now, you better go with PhpSpreadsheet instead of PHPExcel
Dmitry Wolf
@diimdeep
@PowerKiKi Hello, I see there is no tags and releases on github for phpspreadsheet. In case of PHPexcel at least we can pull latest release and be sure that nothing is broken due to dev cycle
Adrien Crivelli
@PowerKiKi
@diimdeep PhpSpreadsheet 1.0.0-beta was just released
nmfarshad
@nmfarshad
Is PHPexcel deprecated and loosing support ?
17tlhon
@17tlhon
Hello. I'm reading the documentation and I can't find anything on adjusting the orientation of a cell? I want to set a cell's orientation to "Rotate Text Down" is that possible?
Adrien Crivelli
@PowerKiKi
@nmfarshad yes PHPExcel is deprecated and loosing support very soon. You should start planning a migration to PhpSpreadsheet, and for new project start directly with PhpSpreadsheet
@17tlhon setTextRotation() might be what you are looking for: https://phpspreadsheet.readthedocs.io/en/develop/topics/recipes/#formatting-cells
HachimIDRISSI
@HachimIDRISSI
Hello
Please can you help me SOS
I am using PHPEXCEL and I can't generat Linear chart with logarithmic scale !
Please Do you have any idea ?
jbax
@jb181991
@PowerKiKi Hi, thank you anyway but I figured it out already :) and I'm done creating HTML to excel using PHPExcel but I'm about to change that to PHPSpreadsheet as you've said its better :)
daflecardoso
@daflecardoso
@daflecardoso
hi there
i have a problem, i using PHPExcel ..
I need generate a report, when i use this
$this->objPHPExcel->getActiveSheet()->getStyle("A$baseRow:DT$baseRow")->getAlignment()->setWrapText(true);
my report its ready after 54 secs, when i comment this line, it is genereted in 4 secs
how can i resolve this, i need give wrap in all lines, this line, is in loop, a get the number line by var $baseRow
exists another way ?
Abhishek Jain
@abbyjaze

Hi Can you guys help me?
I am having trouble saving the excel file in mysql database, It contains enter(new line) inside a cell and symbols & superscripts as well. But it stores as plain text only.
$objReader = new PHPExcel_Reader_Excel5();
$objPHPExcel = $objReader->load($inputFileName);
$sheetData = $objPHPExcel->getActiveSheet()->toArray(null, true, true, true);

then i read some data and use
reset($sheetData);
to reset the pointer.
and again use foreach loop, to add the data into an array and insert that array to mysql table. Does any of these steps remove pre-formatting?(superscript/subscript/new line inside a cell and bold/italics) and How can I put the data in the table exactly as in the excel?
Edit: I am using v1.8 of PHPExcel, v5.4 of PHP and MySQL v5.6

Adrien Crivelli
@PowerKiKi
@abbyjaze toArraydoes not return formatted strings. It only format numbers. So it won't work as you expect.
Abhishek Jain
@abbyjaze
@PowerKiKi Thanks! Can you suggest an alternate for my solution??
Adrien Crivelli
@PowerKiKi
@abbyjaze not really. You will have to come up with your own way to extract and serialize/structure whatever styles you are interested in
Abhishek Jain
@abbyjaze
@PowerKiKi okay, thanks!
Slawson1986
@Slawson1986
Hey everyone
im new here i would like to know if this would work with pro plus