This article should definitely help..

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

If this post helps click Yes
---------------
Jacob Skaria


"Javed" wrote:

Hello Everyone

I want some help and guidance on generating an Excel Programmatically.

Scenario : I have an Excel that contains Input Data. I have to read the
Excel in memory, persist the data , do some manipulation with the given data
and finally store the anlaysis result in a new Excel sheet created at run
time.

Below are some issues listed that I am looking to put importance to.

Issue 1: How to generate Excel programmatically / dynamically at run time.
Issue 2: Best Practise to follow to create and manipulate the Excel in memory.
Issue 3: The approach with which the Memory Loss or Leakage should be
mimimal in doing Excel operations.