Essential XlsIO provides you options to set the text font, text color, background color, text alignment, background pattern, and so on for the cells. The different format settings available for a cell are included in the following list.

Alignment

Essential XlsIO supports horizontal and vertical alignment settings within the cells, and even rotated text.

Font

Essential XlsIO has API support for the customization of fonts 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. Essential XlsIO has API for reading and writing number formats 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.

Formatting

Numerous formatting options are available for customizing the look and feel of the cells in the worksheet.

• Cell Copy
• Cell Formats
• Conditional Formatting
• Global Styles
• Hyperlinks
• Rich Text
• Row and Column Styles
• Working With Images
• Working with Comments