English
Close
 简体中文
 Русский
 عربي
 Français
 Deutsch
 Italiano
 Español
 Svenska
 Türkçe
 日本語
English
简体中文 Русский عربي Français Deutsch Italiano Español Svenska Türkçe 日本語
  • caret-downAspose.Cells for Java
      • What's new in Aspose.Cells for Java
      • caret-closedGetting Started
      • caret-downDeveloper Guide
          • caret-closedIntroduction
          • caret-closedOpen Files
          • caret-closedSave Files
          • caret-closedWorkbook
          • caret-closedWorkbook Conversions
          • caret-closedWorkbook Merger
          • caret-closedEncryption And Protection
          • caret-closedRender, Print and preview
          • caret-closedDocument Properties
          • caret-closedWorksheets
          • caret-closedRows and Columns
          • caret-closedRanges
          • caret-closedCells Data
          • caret-closedFormulas
          • caret-downCells Formats
              • caret-closedNumber Settings
              • caret-closedAlignment Settings
              • caret-closedFont Settings
              • caret-downStyles
                  • Modify an Existing Style
                  • Reusing Style Objects
                  • Remove Unused Styles inside the Workbook
                  • Using Built-in Styles
                  • Create Style object using CellsFactory class
              • Data Formatting
              • caret-closedConditional Formatting
              • caret-closedExcel Themes and Colors
              • Format Worksheet Cells in a Workbook
              • Merging and Unmerging Cells
              • Preserve Single Quote Prefix of Cell Value or Range
              • Implement 1904 Date System
          • caret-closedCalculate Formulas
          • caret-closedComments and Notes
          • caret-closedShapes
          • caret-closedCharts
          • caret-closedSparklines
          • caret-closedTables
          • caret-closedPivot Tables
          • caret-closedTimelines
          • caret-closedSlicers
          • caret-closedQueries And Connections
          • caret-closedSmart Markers
          • caret-closedMacro Project
          • caret-closedWorkbook Settings
          • caret-closedXML Maps
          • Workbook Metadata
          • caret-closedCulture
          • caret-closedTechnical Articles
          • caret-closedMigrating from Earlier Versions of Aspose.Cells
      • API Reference
      • caret-closedUI Components
      • caret-closedPlugins
      • caret-closedShowcases
      • caret-closedRelease Notes
  1. Home
  2. Aspose.Cells Product Family
  3. Aspose.Cells for Java
  4. Developer Guide
  5. Cells Formats
  6. Styles
  7. Using Built-in Styles

Using Built-in Styles

Contents
[ Hide ]
  1. How to use Built-in Styles
Aspose.Cells provides a vast collection of re-usable styles to format a cell in a spreadsheet document. We can use built-in styles in our workbook and also create custom styles.

How to use Built-in Styles

The method Workbook.createBuiltinStyle and class BuiltinStyleType make it convenient to create re-usable styles. Here is a list of all possible built-in styles:

  • TWENTY_PERCENT_ACCENT_1
  • TWENTY_PERCENT_ACCENT_2
  • TWENTY_PERCENT_ACCENT_3
  • TWENTY_PERCENT_ACCENT_4
  • TWENTY_PERCENT_ACCENT_5
  • TWENTY_PERCENT_ACCENT_6
  • FORTY_PERCENT_ACCENT_1
  • FORTY_PERCENT_ACCENT_2
  • FORTY_PERCENT_ACCENT_3
  • FORTY_PERCENT_ACCENT_4
  • FORTY_PERCENT_ACCENT_5
  • FORTY_PERCENT_ACCENT_6
  • SIXTY_PERCENT_ACCENT_1
  • SIXTY_PERCENT_ACCENT_2
  • SIXTY_PERCENT_ACCENT_3
  • SIXTY_PERCENT_ACCENT_4
  • SIXTY_PERCENT_ACCENT_5
  • SIXTY_PERCENT_ACCENT_6
  • ACCENT_1
  • ACCENT_2
  • ACCENT_3
  • ACCENT_4
  • ACCENT_5
  • ACCENT_6
  • BAD
  • CALCULATION
  • CHECK_CELL
  • COMMA
  • COMMA_1
  • CURRENCY
  • CURRENCY_1
  • EXPLANATORY_TEXT
  • GOOD
  • HEADER_1
  • HEADER_2
  • HEADER_3
  • HEADER_4
  • HYPERLINK
  • FOLLOWED_HYPERLINK
  • INPUT
  • LINKED_CELL
  • NEUTRAL
  • NORMAL
  • NOTE
  • OUTPUT
  • PERCENT
  • TITLE
  • TOTAL
  • WARNING_TEXT
  • ROW_LEVEL
  • COLUMN_LEVEL

The following code demonstrates how to use built-in styles.

todo:image_alt_text

Remove Unused Styles inside the Workbook Create Style object using CellsFactory class