Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Advice for generating excel spreadsheet through asp.net preferablywith excel 2007
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Solver Internal Error When Generating Answer Report | Excel Discussion (Misc queries) | |||
emailing part of spreadsheet using Excel 2007 and Outlook 2007 | Excel Discussion (Misc queries) | |||
hyperlink in Excel 2007 spreadsheet cell, to a Powerpoint 2007 sli | Excel Discussion (Misc queries) | |||
Need chart generating advice! | Charts and Charting in Excel | |||
Legal advice on selling Excel spreadsheet program file | Excel Programming |