Last post Apr 08, 2008 07:50 AM by jimmy q
Apr 08, 2008 04:56 AM|chandana|LINK
Apr 08, 2008 07:50 AM|jimmy q|LINK
You will need to use the office object model, which is Excel COM using .NET interop.
The following link is an example of how to use excel interop to create worksheets etc
The functions you are after will be exposed through some classes/interfaces from the COM library so it is best to look around MSDN