Re: Calc C#CLI programming - Get the used range in a sheet - XUsedAreaCursor

Paul Veuve wrote:
> Hello,
>
> This sample work nice in basic but in CLI - C#, I can not pass a cell as
> argument in createCursorByRange() only XSheetCellRange type.
>
> ------------------------------
> Paul Veuve
> vep@xxxxxxxx
>   
Paul,

Could there be an analogy?
Something like this:

xUsedCursor.gotoStartOfUsedArea()
xUsedCursor.gotoEndOfUsedArea(True)
xAddress = xUsedCursor.RangeAddress
lastCol = xAddress.EndColumn           
lastRow = xAddress.EndRow

Sincerely,
Gerrit Jasper