## 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)
댓글 없음:
댓글 쓰기