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      
 
沒有留言:
張貼留言