Solved

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

Posted on 2007-11-26
2
221 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 500 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

Raise the IQ of Your IT Alerts

From IT major incidents to manufacturing line slowdowns, every business process generates insights that need to reach the people required to take action. You need a platform that integrates with your business tools to create fully enabled DevOps toolchains.

You need xMatters.

Question has a verified solution.

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

Because your company can’t afford for you to make SEO mistakes, you’ll want to ensure you’re taking the right steps each and every time you post a new piece of content. This list of optimization do’s and don’ts can help you become an SEO wizard.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
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…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

696 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