Concept EasyXLS™ library enables you to format Excel cells, rows, columns and cell ranges. The supported formatted options are:

- Cell text format: number format, currency format, date format, accounting format, percentage format, fraction format, text format and other custom formats

- Cell alignment: horizontal and vertical alignment, text indentation, wrap text and shrink options, merge cells, text rotation and text direction

- Cell font settings: font name, font size, foreground, bold ant italic options, underline style, strikethrough, superscript and subscript effects

- Cell border: border line style and color

- Cell fill settings: background color, pattern style, pattern color, gradient fill

- Cell protection: locked cells and hidden formulas



The Excel file can be formatted inclusive using themes for Office 2007-2013 spreadsheets.



EasyXLS provides a specific class,



Setting the cell format can be accomplished from



Setting the row format can be accomplished from



Setting the column format can be accomplished from



Setting the format for a range of cells can be accomplished from



For better performances, EasyXLS recommends using as less as possible instances of ExcelStyle classes and avoid setting the format attributes for each ExcelCell class. For more details check

The Excel file can be formatted inclusive using themes for Office 2007-2013 spreadsheets.EasyXLS provides a specific class, ExcelStyle , which stores all formatting settings. The ExcelStyle format can be set for a specific cell, for a row, for a column or for a range of cells. Setting a format for a cell overrides the format of a row or a column.Setting the cell format can be accomplished from ExcelCell class using setStyle() method or other specific methods for formatting.Setting the row format can be accomplished from ExcelRow class using setStyle() method or other specific methods for formatting.Setting the column format can be accomplished from ExcelColumn class using setStyle() method or other specific methods for formatting.Setting the format for a range of cells can be accomplished from ExcelTable class using easy_setRangeStyle() method.For better performances, EasyXLS recommends using as less as possible instances of ExcelStyle classes and avoid setting the format attributes for each ExcelCell class. For more details check Export large Excel files chapter. Concept in action If you want to format cells, consider the code sample and the screen shot below:

