Cell Formats

XlsIO provides you options to set the text font, text color, background color, text alignment, back ground pattern, etc. for the cells. The different format settings available for a cell are illustrated below.

Alignment

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

Font

Essential XlsIO has API support for customizing the font that will be used for rendering the text in the cells.

Border

Essential XlsIO has APIs to insert and format Borders.

Number Formatting

MS Excel displays a number in a cell depending 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 has support for adding new colors to Excel's core color palette.

Pattern

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