@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.
@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
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.
if know any person help me and other my question PHPExcel used any framework or core php?
Hi, how do I embed PHPEXCEL code in a drop-down list in HTML?
Hi everyone, is there anyone done excel file import with dynamic progress bar for large excel files?
@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
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?
'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
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?
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.
John F. Arroyave Gutiérrez
Another way to create Excel files (or spreadsheets) without this library and the RAM problem that you say is writing a file directly, write it like an HTML table or CSV format and the spreadsheet will open it normally. I used that method for files bigger than 60MB and works in seconds. I hope this help.
The Yank #BlueWave2018
I have data being written into hidden rows. I noticed that if I have a formula that references a hidden cell, the formula doesn't run unless I unhide the row. Is there an easy fix for this?
I have a problem. in XLSX, I set some text to bold, when I read excle, use getBold() to read the font-weight, but some cell is work , some doesn't. I am using phpoffice/PhpSpreadsheet: 1.2, someone else know how to read correct?
Hey guys! How to read a xls file with this library? Is there any tutorial?
Hello! i want to save my excel file in mysql with cakePHP, how to do that?
PHPExcel is dead, don't use it
hey guys - added PR PHPOffice/PhpSpreadsheet#595
function EXACT implementation, let me know if there is anything i should change / improve - this function is kinda important for my current project i'm working on.
btw, is there any date for next release ?
some tests are failing on develop branch, PhpOffice\PhpSpreadsheetTests\Helper\SampleTest::testSample 1) 37 ('../samples/Basic/26_Utf8.php') 2) 83 ('../samples/Pdf/21_Pdf_Domdf.php')
@rolandsusans you're in the wrong room, you should move to PhpSpreadsheet room instead
do you have sample on sending file from ajax request to phpspreadsheet, i have the problem sending the exact path of the file, it looks like this "c:/fakepath/sample.xls"
Felix Ivan Romero Rodríguez
Greetings, I am trying to load an excel file, but always throws me the error of calling children function on a boolean result. This occurs calling internal drawings. I can only load if I set true the readDataOnly flag. What can I do to load properly? Best regards. Using php7.0
Excuse me，How to set the minimum value of the coordinate axis in the excel radar map?Who knows?
Someone know why SWITCH function is not supported (my supposition is based on lib/Phpspreadsheet/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Writer/Xls/Parser.php:215)
and do you have any alternative better that IF imbrication... like this : =IF(plop,1,IF(flip,2,IF(clac,3,0))))
Excel formulas is not auto-calculated the value when we are trying to generate excel file using phpexcel if you have any suggestion regarding this please let me know.
we are waiting for your reply.
phpexcel is dead, you should not use it anymore
I included phpexcel, created an object and loaded a file. However, there are 500 errors in the reader making section. Help. Error: Request failed with status code 500 at e.exports (spread.js:25) at e.exports (spread.js:25) at XMLHttpRequest.l.onreadystatechange (spread.js:25)