Formatting

Numerous formatting options are available for customizing the style and appearance of the spreadsheet cells.

Essential XlsIO provides options to set the text font and color, background pattern and color,and text alignment. The different format settings available for a cell are illustrated below:

Alignment

Essential XlsIO supports Horizontal and Vertical alignment settings within the cells and also rotated text.

Font

Essential XlsIO has API support for customizing the font used to render text in cells.

Border

Essential XlsIO has APIs to insert and format Borders.

Number Formatting

MS Excel displays a number in a cell based on the Number Format applied to it. The same number can be displayed in different formats based on the number format associated with it. XlsIO has API for reading and writing the number format in a cell.

Color Palette

Essential XlsIO supports addition of new colors to MS Excel's core color palette.

Pattern

Essential XlsIO has APIs to specify the background pattern of a cell.

Essential XlsIO supports addition and modification of global styles which can be applied to more than one cell in a spreadsheet.

Style Customization

Customizing the style settings of your spreadsheet can be done using Essential XLsIO. This feature comes with the added flexibility of allowing users to either include or exclude certain formats in a worksheet just like MS Excel.

Essential XlsIO provides well-defined APIs to apply default styles to rows and columns. Once you have defined a style, you can apply this style to all the cells in a row or a column using a single function call. This optimizes formatting of spreadsheets with large numbers of rows and columns.

Essential XlsIO allows conditional formatting of spreadsheet cells. Conditional formatting is a technique by which the cell contents are dynamically formatted based on user-defined criteria.

Essential XlsIO has well-defined APIs to read and write the conditional format from-or-to a cell in a spreadsheet. Different conditional formats are illustrated beow:

Rich text can be added to cells using Essential XlsIO's APIs. The rich text content in cells on an existing spreadsheet can also be read.

Essential XlsIO supports the insertion of Scalar and Vector images into a spreadsheet. It is also possible to position the image at any desired location.

Essential XlsIO allows addition of hyperlinks to cell content in a spreadsheet. It has APIs to read and write hyperlinks in a spreadsheet.

The format settings are automatically copied from the source cell to the destination cell during a copy operation. Thus, you don’t have to apply formatting to copied cells.