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
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
if so im needin help with some PHP code
jleslie
@jleslie

Hello Everyone,

I am using PHPExcel as part of a platform that takes in xlsx and csv files and uploads them to our system. We are having trouble with
PHPExcel_IOFactory::load($sheet);

It is throwing Scale must be greater than or equal to 1.

From what I can see there is no way to set the zoom scale other than in excel, however we cannot guarantee our clients will all do this properly. Is there a way around this short of forking PHPExcel (which we'd rather not do...)?

Unfortunately the only solutions I have found on stack overflow are people forking and writing their own fix.

jleslie
@jleslie
I know PHPExcel is no longer in development, but I do have a PR in that could fix this problem (and has on my local copy in our system)
Kobus Myburgh
@Bliksempie
Hi everyone. I see that PHPExcel is not maintained anymore, and the current build is failing as per Github. What is the last stable version of PHPExcel that I can use? I am working on a live environment with thousands of users per hour, so I can't live on the edge with PHPSpreadsheet :-D
Adrien Crivelli
@PowerKiKi
@Bliksempie, PHPSpreadsheet actually is the best version of PHPExcel you can get. As long as you lock your dependencies you shouldn't have any surprise from your dev env to your prod env
web24dev
@web24dev

method setReadDataOnly not found

why does not it work?

Anders Lindén
@AndersBillLinden
Is there an example of how to read an excel file? 07reader.php was not it, apparently
Adrien Crivelli
@PowerKiKi
@AndersBillLinden maybe you want to read that too: http://phpspreadsheet.readthedocs.io/en/develop/topics/accessing-cells/
Anders Lindén
@AndersBillLinden
Maybe PhpSpreadsheet is the only way to go, even if it is alpha
oh, it was beta actually
Adrien Crivelli
@PowerKiKi
@AndersBillLinden if you are starting something new, then PhpSpreadsheet is definitely the way to go
Richárd Biró
@Xyzor
Hello,
I have an excel with bill items. In the first column are the IDs of the stores. Every store can have multiple bills. I'd like to create an excel file for every store, containing that store's bills. Is it possible with phpexcel?
Someething like this: https://stackoverflow.com/questions/36506151/extracting-all-rows-based-on-a-value-of-cell-without-vba
Adrien Crivelli
@PowerKiKi
@Xyzor yes, it would be possible to do iterate over all rows, regroup data by store ID and then ouput a file for each store. However if you are starting something new, I'd suggest to start with PhpSpreadsheet
Richárd Biró
@Xyzor
@PowerKiKi Thanks for the suggestion, I'll definitely check it, but the environment is php 5.4 :(. I'd like to make this with only excel commands through PHPExcel. It would be possible, for example to create a new sheet for the store ID and copy the store's bills to that sheet, so then I could just create a new excel file from that sheet.