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 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
Hi, as I was told that my code doesn’t scale well at all, I thought perhaps I’d try to get a better understanding of interfaces/abstract classes and classes and the relationship between them.
I don’t want at this stage work on a big separate project as I've already got plenty ...
OK, so HostGator for some reason no longer allows gcc/g++ access unless you have a Designated Server account, which is a lot of money to spend just to compile my "Hello World" program. Thus I figured I'd compile at home, then upload. Program is your regular old bare-bones Hello World ...
Hi. I have a form with list box : lst_product, datagridview : grd_order and button: btn_addline. lst_product has a list of product ids selected from database (MS Acess 2013) , grd_order is by default empty except for 2 headers and btn_addline adds rows to grd_order.
Private Sub btn_addline_Click(ByVal ...