Developer's reference PB2XLS for PowerBuilder

Reference > Examples

Examples

Example01How to create workbook, add worksheets, write data into merged cells, apply formatting for cells etc.
Example02How to create multisheets workbook, set active, selected and first sheet, specify selected cells
Example03How to divide a worksheet into horizontal or vertical regions known as panes
Example04How to divide a worksheet into horizontal or vertical regions known as frozen panes
Example05How to specify page properties: size of paper, orientation, margins, header and footer, scale. This example demonstraite also using the custom colors in workbook.
Example06How to specify rows to repeat at the top of each printed page
Example07How to define the numerical format for the cells
Example08How to specify the print area of the worksheet. This example demonstraite also how to add horizontal and vertical page breaks to a worksheet
Example09How to insert bitmap image into a worksheet.