[SOLVED] - Get Rows # by horizontal page breaks!?

[DCCD]

[solved]

; Return the last row # of each page
.ActiveSheet.HPageBreaks(1).location.rowoÝ÷ Ù«­¢+ØìIÑÕɸѡ!A  ɭ̽±±Ñ¥½¸(¹Ñ¥ÙM¡Ð¹!A  ɭ̹
½Õ¹

I want to know the number of the last row of each page, I know its possible but how?

One more question?, Somehow can't find the ExcelUDF where to find it? i try to search for it, it doesn't appear

Any Help will be highly appreciated,

Thanks in advance

Edited June 15, 2009 by DCCD

[BugFix]

Hi,

try this:

Local $sFilePath = 'your.xls'
Local $oExcel = ObjCreate("Excel.Application")
$oExcel.Visible = 1    ; 1=visible / 0=unvisible
Local $oBook = $oExcel.WorkBooks.Open($sFilePath, Default, False)
Local $oSheet = $oBook.Worksheets.Item(1)  ;  <=== number/name of sheet you wish
Local $maxRows = $oSheet.UsedRange.Rows.Count
ConsoleWrite('maxRows: ' & $maxRows & @CRLF)

Edited June 14, 2009 by BugFix

[Zedna]

One more question?, Somehow can't find the ExcelUDF where to find it? i try to search for it, it doesn't appear

From Autoit version 3.3 it's standard include:

"C:\Program Files\AutoIt3\Include\Excel.au3" 

Edited June 14, 2009 by Zedna

[DCCD]

Hi,

try this:

Local $sFilePath = 'your.xls'
Local $oExcel = ObjCreate("Excel.Application")
$oExcel.Visible = 1    ; 1=visible / 0=unvisible
Local $oBook = $oExcel.WorkBooks.Open($sFilePath, Default, False)
Local $oSheet = $oBook.Worksheets.Item(1)  ;  <=== number/name of sheet you wish
Local $maxRows = $oSheet.UsedRange.Rows.Count
ConsoleWrite('maxRows: ' & $maxRows & @CRLF)

thanks BugFix, but "UsedRange" it just appears my LastCell number!

I want to know the number of the last row of each page?

Ex:

Page1 :pagebreak1 = row number?

Page2 :pagebreak2 = row number? etc..

From Autoit version 3.3 it's standard include:

"C:\Program Files\AutoIt3\Include\Excel.au3" 

Thank you, I upgrade to last version