Microsoft Excel API in VB.net

[deepanbecse]

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

[samson_zed]

Hi Deepan

http://msdn.microsoft.com/en-us/library/aa168292%28v=office.11%29.aspx

Very useful tutorial for understanding excel from .net perspective

Rgrds

Sam

[deepanbecse]

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.

[Reverend Jim]

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