Web Development

Ask something
Discussion Locked

Use ASP save Data in Excel via IE to SQL

0 helpful
5 replies

by cedric king 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I would like to display data via Excel on IE using ASP. I would like the user to be able to edit the data, extracted from SQL, from within the browser.

The major problem is the next step, Save. How do I allow the user to save the changesmade in the Excel preferably directly into SQL? If not, then as a local file in the Web
Server?

Will the code be in ASP or within the Excel that opens up in IE? I prefer the code to be in ASP.

Thanks.

Regards,
Cedric

5 replies

by bojidar alexandrov

How do you want to edit data with Excel??
As you state - if you return an xls file from ASP then Excel on client will open in IE but you can't after that to return it back to server.
There are few ActiveX Objects that come with Excel and you can use them to build up an page an edit data in it and when saving - to post data back to server.
That is the one way is to use standart POST request, the other is to make an client-side ActiveX, (java applet) that will communicate with server.

For example of usage open with Excel an worksheet and save it as html, but check also button "Add Interactivity"

by bojidar alexandrov

How do you want to edit data with Excel??
As you state - if you return an xls file from ASP then Excel on client will open in IE but you can't after that to return it back to server.
There are few ActiveX Objects that come with Excel and you can use them to build up an page an edit data in it and when saving - to post data back to server.
That is the one way is to use standart POST request, the other is to make an client-side ActiveX, (java applet) that will communicate with server.

For example of usage open with Excel an worksheet and save it as html, but check also button "Add Interactivity"

This discussion is closed to new replies.