Example01 | How to create workbook, add worksheets, write data into merged cells, apply formatting for cells etc. |
Example02 | How to create multisheets workbook, set active, selected and first sheet, specify selected cells |
Example03 | How to divide a worksheet into horizontal or vertical regions known as panes |
Example04 | How to divide a worksheet into horizontal or vertical regions known as frozen panes |
Example05 | How to specify page properties: size of paper, orientation, margins, header and footer, scale. This example demonstraite also using the custom colors in workbook. |
Example06 | How to specify rows to repeat at the top of each printed page |
Example07 | How to define the numerical format for the cells |
Example08 | How to specify the print area of the worksheet. This example demonstraite also how to add horizontal and vertical page breaks to a worksheet |
Example09 | How to insert bitmap image into a worksheet. |