09-22-2024
09:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
09-22-2024
09:40 AM
This makes sense! however how do i implement this so that it counts the rows in an excel sheet from inventor?
from my understanding if i want something done within excel from inventor i have to use the GoExcel function. do you know if there is a way to return the row count using this? instead of using the string variable you showed i want this to be column A and count the rows until it hits an empty cell.
i tried implementing your method with below snippet, which resulted in the messagebox returning the current cell value letter by letter, instead of going to the next row to check if its empty.
Dim iRow As Integer = 1 Dim XlVal = GoExcel.CellValue(oExcelList, xlTab, "A" & iRow) Do While Not String.IsNullOrEmpty(XlVal(iRow)) MessageBox.Show(XlVal(iRow)) iRow += 1 Loop
once its finished spelling out the letters in the current row it returns an array range error