• Fluent
  • Fluent Dark
  • Bootstrap v5
  • Bootstrap v5 Dark
  • Tailwind CSS
  • Tailwind CSS Dark
  • Material
  • Bootstrap v4
  • High Contrast
Preferences
Mode Selection
Touch
Mouse
Theme Selection
Localization
*Translated by Google Translator.
Currency
Essential Studio
HOME
All Controls

Example of Format Cells in ASP.NET Core Excel (XlsIO) Library

This sample demonstrates how to apply formatting to the cells using XlsIO.
DEMO
SOURCE

Click the "Create Document" button to view the created Excel document. Please note that the Microsoft Excel viewer or Microsoft Excel is required to view the Excel document.


Save As :  

Formatting worksheets makes them more attractive and easier to use. Excel provides various options for setting font, font size, color, and background. The "Format Cells" dialog in Excel has six tabs, each with several characteristics that allow you to set various formats for a cell. You can set number formats, horizontal and vertical alignment, text control operations, font and font styles, and borders for the cells.


Features:

  • Various styles such as colors, font settings, borders, and alignments
  • Number formats
  • Patterns
  • Conditional formatting
  • RTF
  • Image insertion