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
HachimIDRISSI
@HachimIDRISSI
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.
Adrien Crivelli
@PowerKiKi
@Xyzor I cannot help you with excel commands only. You'll have to refer to Excel documentation first, and then try to apply the solution via PHPExcel
Richárd Biró
@Xyzor
ok
Anders Lindén
@AndersBillLinden
It seems like PHPSpreadSheet is "useless" for reading documents.
It stores cells in its index by A1, A2 etc, not optimal for reading line by line.
It seems to be designed for writing, so it should really be named phpexcelwriter.
Adrien Crivelli
@PowerKiKi
salih hanifeoglu
@hanifeoglu_twitter
hi i m need help for PHPExcel for mac osx
i want use import PHPExcel how to install on mac
if know any person help me and other my question PHPExcel used any framework or core php?
Richi33
@Richi33
Hi, how do I embed PHPEXCEL code in a drop-down list in HTML?
Vipul Lakhtariya
@vipullakhtariya
Hi everyone,
is there anyone done excel file import with dynamic progress bar for large excel files?
Adrien Crivelli
@PowerKiKi
@vipullakhtariya I did some kind of fake progress for Excel file download. It would probably be similar, but it is far from trivial, and gives rather poor result for a lot of effort. If I had to do it again, I would not do it at all
Adrien Crivelli
@PowerKiKi
@/all PhpSpreadsheet 1.0.0 was released yesterday. That means PHPExcel should no longer be used, and users should start migrating to PhpSpreadsheet (or other alternatives)
ling
@wl1508702360
Why add header () code in the code to set up the HTTP header,use save('php://output') does not achieve the xlsx worksheet in the web page?
Adrien Crivelli
@PowerKiKi
'php://output' will correctly send some bytes representing the XLSX file to the browser, but the browser must be told what kind of data he is receiving. The browser may not be able to guess that the bytes received are an XLSX file. This is what headers are for
ling
@wl1508702360
image.png
madsbe
@madsbe
Hi, I'm working on a project where I collect info and some I need to put in my Excel spreadsheet in a specific sheet.
The data comes in, gets stored in MySQL and output some fields to the Excel sheet while its open.
Can I do this with PHPSpreadsheet?
Adrien Crivelli
@PowerKiKi
@madsbe I am not sure what you mean by "while its open", but most likely you should be able to write Excl files. Also use that room: https://gitter.im/PHPOffice/PhpSpreadsheet
madsbe
@madsbe
@PowerKiKi, ok, I will post overthere...
Ashish Deora
@deoraashish
Hello there
I am not able to understand which one to use - PHPExcel or PHPSpreadsheet?
Adrien Crivelli
@PowerKiKi
Yursksf1
@Yursksf1
Hello!
someone else know how load a bigfile on PHP Excel?
too create a big file, because i use a PHP_XLSXWriter (https://github.com/mk-j/PHP_XLSXWriter). when can create a big files with out overfloat the ram, but i would like know if anyone know if exist another metohd to work with big files on PHP Excel.
specific load files.
Thanks.