0

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

3
Contributors
3
Replies
5
Views
5 Years
Discussion Span
Last Post by Reverend Jim
0

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.

0

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.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.