Create a PHP script that will export your MySQL database to Excel spreadsheets
Explore the marketplace!
What you get with this Offer
1. Formulas
2. Protected cells
3. Linked cells
4. Single or multiple worksheets
Depending on your requirements, the PHPExcel script will be designed to run from within your web site or from the command line as a shell script. If your template needs to export data based on specific criteria, a basic HTML form will be provided to demonstrate how the script can be incorporated into your web site (if you require any assistance in integrating the script please provide further details).
If any have any questions about this service or its suitability in relation to your requirements please get in contact.
Legal Notice:
The provider of this service is not affiliated with, sponsored or endorsed by The PHP Group, PHPExcel, Oracle Corporation or Microsoft Corporation. The use of registered trademarks and product names in the promotion of this service is in accordance with each company's legal guidelines.
What the Freelancer needs to start the work
Please note that the following restrictions apply with this service:
Unless stated otherwise, it is assumed that the PHPExcel library and PHP export script will be installed on your own web server(s).
The PHPExcel library has certain software dependencies that must be met before spreadsheets can be generated. A test script can be supplied to you before work commences on your project to determine whether there are likely to be any compatibility issues.
Performance overhead and RAM usage is extremely high when trying to output very large record sets to Excel spreadsheets using the PHPExcel library, therefore it would be helpful if you could provide an indication of the database size before purchasing this service.
Within Excel there are in-built limitations that stop very large amounts of text saved to individual cells from being directly viewable or editable in their entirety, even though they will be saved correctly (this can be confirmed by using the data export options).