Invoking Excel on Client browser
Posted: Sun Feb 03, 2008 9:43 am
I have fields in a mysql database that contain the contents of excel spreadsheets that were originally saved in html format. Excel can load them, make changes and resave them without problems while they are kept as files.
What I 'want' to do is the following:
1) via php and mysql on the server side, extract the full html structured data of the sheet.
2) send it to the client (inside an iframe) in a way that will launch excel with that data embedded in the iframe.
3) have them make whatever changes needed to the data and when ready save it back into the database in its html format.
I have done this using a dedicated application (VB) and using the Microsoft Web Components that come with Office, but now I am migrating the app to run under a browser (and with several users).
Open to any suggestions on how/where to get started with this portion of the conversion!
Oops, should have mentioned:
all client browsers will be IE 6 or higher
all clients will be windows with office 2003 installed.
server is linux with php v5 and mysql v5 and apache 2.2.2
TIA
Martyn
What I 'want' to do is the following:
1) via php and mysql on the server side, extract the full html structured data of the sheet.
2) send it to the client (inside an iframe) in a way that will launch excel with that data embedded in the iframe.
3) have them make whatever changes needed to the data and when ready save it back into the database in its html format.
I have done this using a dedicated application (VB) and using the Microsoft Web Components that come with Office, but now I am migrating the app to run under a browser (and with several users).
Open to any suggestions on how/where to get started with this portion of the conversion!
Oops, should have mentioned:
all client browsers will be IE 6 or higher
all clients will be windows with office 2003 installed.
server is linux with php v5 and mysql v5 and apache 2.2.2
TIA
Martyn