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...

Hi Sam
The link is not available.My problem is to open a work book,parse through all the worksheets and search for a particular column and store the values in that column in a dictionary.Can you just help me to find a specific column in all worksheets?
Thanks in advance
Regards,
Deepan.

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 xls As New Excel.Application
        Dim cell As String

        xls.Workbooks.Open("d:\my documents\points-jim.xls")

        For Each sheet As Excel.Worksheet In xls.ActiveWorkbook.Worksheets

            Debug.WriteLine(sheet.Name)

            For row As Integer = 1 To 500
                For col As Integer = 1 To 20
                    cell = sheet.Cells(row, col).value
                    If (Not cell Is Nothing) AndAlso cell.StartsWith("c") Then
                        Debug.WriteLine(cell)
                    End If
                Next
            Next

        Next

    End Sub

End Class
This article has been dead for over six months. Start a new discussion instead.