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?
lenerd3000
Member
72 Points
151 Posts
Tutorials on how to manipulate excel programmatically
Mar 18, 2011 01:20 AM|LINK
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
qwe123kids
All-Star
48619 Points
7957 Posts
MVP
Re: Tutorials on how to manipulate excel programmatically
Mar 18, 2011 04:25 PM|LINK
Hi,
Better Use OpenXml
http://msdn.microsoft.com/en-us/office/ee358824
video tutotial in above link
Avinash Tiwari
Remember to click “Mark as Answer” on the post, if it helps you.