Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 229
  • Last Modified:

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.
0
emi_sastra
Asked:
emi_sastra
1 Solution
 
rajupsCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now