sub usedArea
oDoc = thisComponent
oPlan = oDoc.getSheets().getByIndex(1) '指定是那張 sheet
oCursor = oPlan.createCursor()
oCursor.gotoStartOfUsedArea(False)
oCursor.gotoEndOfUsedArea(True)
aAdd = oCursor.getRangeAddress()
print "StartRow=" & aAdd.StartRow+1; ", StartColumn=" & aAdd.StartColumn+1; ", EndRow=" & aAdd.EndRow+1; ", EndColumn" & aAdd.EndColumn+1
end sub
沒有留言:
張貼留言