## set tmpRange => from (0, 0) to (5, 40) <= (Col, Row)
tmpRange = oSheet.getCellRangeByPosition(0, 0, 8, 78)
## oSheet1.setPrintAreas( Array() )
oSheet1.setPrintAreas( (tmpRange.RangeAddress, ) )
## set print margin
oFamilies = oDoc.getStyleFamilies()
oPageStyles = oFamilies.getByName("PageStyles")
Style = oPageStyles.getByName(oSheet.PageStyle)
Style.BackColor = &HCCCCFF
Style.BottomMargin = 1000
Style.TopMargin = 1000
Style.LeftMargin = 1000
Style.RightMargin = 500
Style.PageScale = 77
Style.HeaderIsOn = False
Style.FooterIsOn = False
11/03/2011
calc python macro: print cell range
피드 구독하기:
댓글 (Atom)
댓글 없음:
댓글 쓰기