I have a php system which has a MySql database which I can access in many number of ways.
I have an existing spreadsheet with multiple worksheets in it. I need data streamed into the First Worksheet only but need to keep the integrity of the additional worksheets.
I dont' need formatting and don't require anything else but the data to be streamed into certain cells on the first worksheet and keep all the additional worksheets intact.
Keywords:
PHP, MySql, Excel
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
4) I want a script that I can run that will allow me to send to data to a certain cell with certain format and data I choose. Potentially will run that process up to 50 times to get the data into one Excel File.
## Platform
Redhat Linux (not important)
PHP 4.x
MySql Database (not important)
I have experience with open source PHPExcel. This allows me/us to write directly into a specific cell.
Are the cells where data is to be written to fixed (ie always write to cell B2, K13 and L54)? or should there be an option to have the target cells more flexible?
Is the data to be written to the same spreadsheet over and over again or are copies to be saved after each dataload? Is dataload done once a day? Should the dataload be done via a cron job or is it to be started manually?
My idea is to first get aquinted with the environment (establish connection etc). Next I want to prepare and install PHPExcel in the settings that you have provided me. Once done I will make a program to load data to excel. If you agree on the correct working of that, I will extend the update/write to all defined by you.