How to programming (interact with) Excel using ASP NET 2?

Hi,

I am writing a project that needs to interact with excel sheet which I need:

1. Open a blank excel sheet.
2 .Write data to open excel sheet from datatable.
3. Save back to datatable.

My question is:

1. How could I interact with the excel?
2. How could I know that the user just exit the sheet and then I should save back to datatable again.

Please help.

Thank you.
LVL 1
emi_sastraAsked:
Who is Participating?
 
rajupsConnect With a Mentor Commented:
Hi,
Best way to achieve this is using the OWC [Office Web Component] from microsoft
Using this you can programatically
Format the sheet
Apply any rules/ calculations
Insert charts
Pivot tables and lot more.

You can define the Excel Template / XML Template as a template for your final excel also.

Refer below links for more details
http://support.microsoft.com/kb/555237
http://support.microsoft.com/default.aspx?scid=kb;EN-US;317316
http://support.microsoft.com/kb/319793
http://support.microsoft.com/kb/262827

All the best,
Raju P. S
0
 
emi_sastraAuthor Commented:
Thank very much.

I think it is what I need.

I have to learn it first.


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.