Need to export data to Excel template contains VBA code and data validation in PHP?
Try to do it using PHPExcel library but it is removing all the VBA code and data validations from the template. Another library I try to use that it PHPReport still didn't get proper solution.
Template contains multiple worksheets and there are inter dependent on each other, eg:
Worksheet 1 contains employee data, then worksheet 2 contains there salary with respect to employee name.
分享 I have spent a great deal of time working on this problem, and the problem of memory consumption for large data sets. All of the PHP libs I have found keep all of the cells in memory, which is not viable for anything more than a small sheet.
What I ended up doing was writing a set of Java utilities using Apache POI and packaged them with PHP/Java Bridge so I can call them from PHP. This will allow you to create a new workbook based upon a template, keeping the macros intact. You can also use POI's streaming API, so you can handle massive data sets without crashing your server.
If you have Java chops, I highly recommend going this route, it's really the only way to do brain surgery on Excel files from PHP.
If you have any questions about how to do this or would like some example code, I'll be glad to help.
分享
