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 |
All times are GMT +1. The time now is 10:48 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com