?
Solved

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

Posted on 2007-11-26
2
Medium Priority
?
226 Views
Last Modified: 2010-04-30
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
Comment
Question by:emi_sastra
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 5

Accepted Solution

by:
rajups earned 2000 total points
ID: 20349438
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
 
LVL 1

Author Comment

by:emi_sastra
ID: 20349648
Thank very much.

I think it is what I need.

I have to learn it first.


0

Featured Post

Understanding Web Applications

Without even knowing it, most of us are using web applications on a daily basis. Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We often confuse these web applications tools for websites.  So, what is the difference?

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This tutorial walks through the best practices in adding a local business to Google Maps including how to properly search for duplicates, marker placement, and inputing business details. Login to your Google Account, then search for "Google Mapmaker…
Suggested Courses

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question