|
|
|
|
|
Worksheet Manipulation
Essential XlsIO has advanced support for manipulating the worksheet.
|
|
|
|
Essential XlsIO has support for auto-fitting the contents in a worksheet.
Code to enable auto-fit option
Output spreadsheet with auto-fit contents
|
|
|
|
Essential XlsIO has support for copying a worksheet from one workbook to another. This feature can be used to merge several workbooks together.
|
|
|
|
Essential XlsIO has support for freezing columns to the left and rows on top.
Frozen 1st row and 1st column
|
|
|
|
Essential XlsIO has support for grouping and ungrouping rows and columns.
|
|
|
|
Essential XlsIO has support for hiding and unhiding rows and columns in a worksheet.
Sample Source Code
Equivalent Functionality in Excel
|
|
|
|
Essential XlsIO has support for dynamically inserting rows and columns in a new / existing worksheet.
Sample Source Code
Equivalent Functionality in Excel
|
|
|
|
Essential XlsIO has support for inserting Page breaks in a worksheet.
Sample Source Code
|
|
|
|
Essential XlsIO has support for setting row height and column width in a worksheet.
|
|
|
|
While XlsIO can read and let you manipulate several sections of an Excel workbook, there are some elements that XlsIO still doesn't support creating anew or editing existing entries. This includes VBA Scripts and Diagrams.
Such elements are however preserved while resaving an opened workbook, so you can still use and work with such elements, outside XlsIO, in your workbooks.
|
|
|
|
|
|
|
|
