Hi friends...can any one suggest me a solution for accessing the Excel work books using the Microsoft Excel API in VB.net?I have to parse through the excel work sheets and find the position of a particular column in the sheet...
Jump to Post
The following code scans the first 500 rows and 20 columns of all worksheets and writes the values of all cells that start with the letter "c".
Imports Excel = Microsoft.Office.Interop.Excel Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim …
All 3 Replies
Be a part of the DaniWeb community
We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.