- GcExcel .NET Overview
- Key Features
- Getting Started
-
Features
- Worksheet
- Workbook
- Comments
- Hyperlinks
- Sort
- Filter
- Group
- Conditional Formatting
- Data Validations
- Data Binding
- Digital Signatures
- Formulas
- Custom Functions
- Shapes and Pictures
- Document Properties
- Styles
- Form Controls
- Barcodes
- Theme
- Chart
- Table
- Pivot Table
- Pivot Chart
- Sparkline
- Slicer
- Logging
- Defined Names
- Templates
- File Operations
- Release Notes
Styles
GcExcel .NET allows you to format the cells in a spreadsheet with a set of styles that can be utilized to format cell appearance in individual worksheets for enhanced clarity and increased readability. A cell style includes characteristics such as fill (solid fill, gradient fill, pattern fill), fonts, borders, name style, and display format.
Applying style in a worksheet involves following tasks.
Some of the built-in styles in GcExcel .NET are listed below:
Category | Description | Properties |
|---|---|---|
Number Format | Cell number format. | |
Alignment | Horizontal and vertical alignment of cell content, indentation,text wrap, text rotation and text shrinking. | |
Font | IRange.Font(IFont) | IRange.Font(IFont) |
Borders | Cell border line styles and colors. | IRange.Borders(IBorders) |
Fill | Cell pattern fill or gradient fill. | IRange.Interior(IInterior) |
Protection | Cell protection options (Locked and Hidden) |
Apart from the built-in styles, you can also create custom styles with description for individual cells or a range of cells in a worksheet where you can define all the style attributes and properties including font, font size, number format, alignment etc.