Tutorials on how to manipulate excel programmatically

Hi everyone,

I have done several projects using excel files but i think my approach is not a good way to do it. I use excel using interop and import the name space like this:

Imports Excel = Microsoft.Office.Interop.Excel

I have done this in my last project where they give me an excel template. What i did is to supply that excel with the corresponding data.

Although i can read/write in the excel file programmatically by manipulating each every cells, i think this approach is not a good one. We use this for our reporting by the way.

Do you have any idea on how to do this much better?

Imports System.Runtime.InteropServices.Marshal

Re: Tutorials on how to manipulate excel programmatically

Hi,

Better Use OpenXml

http://msdn.microsoft.com/en-us/office/ee358824

video tutotial in above link