Excel count rows

[kawumm3000]

Hi,
how can I find out what is the highest row number that is filled in a specific column?

 

[Subz]

Basic example:

#include <Excel.au3>
Global Const $xlUp = -4162

Global $oExcel = _Excel_Open()
Global $oWorkbook = _Excel_BookOpen($oExcel, @ScriptDir & "\Expertise.csv")
Global $iUsedRangeCount = $oWorkbook.ActiveSheet.UsedRange.Rows.Count
Global $sColumn = "A"
Global $iColumnRowCount = $oWorkbook.ActiveSheet.Range($sColumn & $oWorkbook.ActiveSheet.Rows.Count).End($xlUp).Row
MsgBox(4096, "", "UsedRange Count : " & $iUsedRangeCount & @CRLF & "Used Column Row Count : " & $iColumnRowCount)

 

[kawumm3000]

2 minutes ago, Subz said:

Basic example:

#include <Excel.au3>
Global Const $xlUp = -4162

Global $oExcel = _Excel_Open()
Global $oWorkbook = _Excel_BookOpen($oExcel, @ScriptDir & "\Expertise.csv")
Global $iUsedRangeCount = $oWorkbook.ActiveSheet.UsedRange.Rows.Count
Global $sColumn = "A"
Global $iColumnRowCount = $oWorkbook.ActiveSheet.Range($sColumn & $oWorkbook.ActiveSheet.Rows.Count).End($xlUp).Row
MsgBox(4096, "", "UsedRange Count : " & $iUsedRangeCount & @CRLF & "Used Column Row Count : " & $iColumnRowCount)

 

Thx. That is what I need.

[water]

Please have a look at the Wiki. You will find a section about ranges.