to apply an accounting underline in excel

Setting SuperscriptĪpply superscript to text with the Font object’s setSuperscript property. In addition to changing the font type, you can amplify your project using other features in the Font group such as Bold, Italic, or Underline. Make text superscript by using the Font object’s setSubscript property. Strikeout text with the Font object’s setStrikeout property. Select any color from the Color enumeration and assign the selected color to the Font object’s setColor. Set the font color with the Font object’s setColor property. Aspose.Cells offers various pre-defined font underline types in the FontUnderlineType enumeration. Underline text with the Font object’s setUnderline property. Set the font size using the Font object’s setSize property. Set text to bold by setting the Font object’s setBold property to true. Also, the object of the Style class provides properties for configuring font settings.Īpply a specific font to text in cells using the Font object’s setName property. For example, if a cell is formatted for Accounting, clicking on the Underline button produces the single accounting underlinestretching from the dollar sign to the number, as shown below. Each item in the Cells collection represents an object of the Cell class.Īspose.Cells provides the Cell class' setStyle method, used to set a cell’s formatting. Excel treats a number in a cell differently depending on its underlying formatting, and you’re probably not aware the cell is formatted. The Worksheet class provides a Cells collection. A worksheet is represented by the Worksheet class. The Workbook class contains a WorksheetCollection that allows access to each worksheet in an Excel file. Configuring Font SettingsĪspose.Cells provides a class, Workbook that represents a Microsoft Excel file. Therefore, if you decide that creating a bookkeeping system in Excel is not the right path for you, or if you outgrow your system. Top Alternatives to an Excel Bookkeeping System. Just like Microsoft Excel, Aspose.Cells also supports configuring the font settings of the cells. Once again, although it is possible to create a double-entry accounting system in Excel, it would be extremely troublesome and time-consuming to manage and maintain. These font settings may include the name, style, size, color and other effects of the fonts as shown below in the figure: The look and feel of the text can be controlled by changing its font settings.

To apply an accounting underline in excel