Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
litXLS - Page Breaks (HPageBreaks - VPageBreaks) (Read 4362 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
litXLS - Page Breaks (HPageBreaks - VPageBreaks)
30.01.06 at 09:59:25
 
Support for Horizontal and Vertical Page breaks was added to the litXLS software component. XLS files created with the litXLS can now include these page breaks. Note that the syntax is different from the Excel syntax.
 
To add a horizontal page break at row 10, 20 and 30 and to add a vertical page break at column 8 you can use the following syntax:
Code:
Workbook.Worksheets(1).HPageBreaks.Add 10
Workbook.Worksheets(1).HPageBreaks.Add 20
Workbook.Worksheets(1).HPageBreaks.Add 30
Workbook.Worksheets(1).VPageBreaks.Add 8
 

Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1