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...
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
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
For Each sheet As Excel.Worksheet In xls.ActiveWorkbook.Worksheets
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