N
Nikron
Hi,
I need some advice for an application that I need to write.
The application is web based and has a grid type interface for the user
to manipulate and save. The user wants to be able to export this grid
data into an excel spreadsheet whilst on the web app (on the grid
imparticular). They then want it to open in excel on the client machine
and have the client edit it within excel, after which they want to click
a button and this is then saved back to the app.
So my idea is as follows:
When they click on the export button, write code that extracts the data
from the db and maps it into excels format (i've heard 2007 now is xml)
and then save it temporarily on the HDD of the server and send the link
down to the client machine. Upon clicking the link the excel doc opens
and the user can edit whatever they want. Then I'm going to create a
ribbon bar button that must be installed on their machines and upon
clicking it it sends this data back through a webservice into the database.
Now I need to know what is the best way to do this, I've heard that
excel 2007 supports xml and reckon this is the best way to store the
data inside the database, does anybody have any ideas around this.
Much appreciated
Nikron
I need some advice for an application that I need to write.
The application is web based and has a grid type interface for the user
to manipulate and save. The user wants to be able to export this grid
data into an excel spreadsheet whilst on the web app (on the grid
imparticular). They then want it to open in excel on the client machine
and have the client edit it within excel, after which they want to click
a button and this is then saved back to the app.
So my idea is as follows:
When they click on the export button, write code that extracts the data
from the db and maps it into excels format (i've heard 2007 now is xml)
and then save it temporarily on the HDD of the server and send the link
down to the client machine. Upon clicking the link the excel doc opens
and the user can edit whatever they want. Then I'm going to create a
ribbon bar button that must be installed on their machines and upon
clicking it it sends this data back through a webservice into the database.
Now I need to know what is the best way to do this, I've heard that
excel 2007 supports xml and reckon this is the best way to store the
data inside the database, does anybody have any ideas around this.
Much appreciated
Nikron