• Getting Started
  • Components
    • Barcodes
    • Buttons
    • Chartsupdated
    • Conversational UIupdated
    • Data Query
    • Date Inputsupdated
    • Date Math
    • Dialogs
    • Drawing
    • Dropdownsupdated
    • Editor
    • Excel Export
    • File Saver
    • Filter
    • Gantt
    • Gauges
    • Gridupdated
    • Icons
    • Indicators
    • Inputsupdated
    • Labels
    • Layout
    • ListBox
    • ListView
    • Map
    • Menus
    • Navigation
    • Notification
    • Pager
    • PDF Export
    • PDFViewer
    • PivotGridupdated
    • Popup
    • ProgressBars
    • Ripple
    • Schedulerupdated
    • ScrollView
    • Sortable
    • Spreadsheetupdated
    • ToolBar
    • Tooltips
    • TreeList
    • TreeView
    • Typography
    • Uploads
    • Utilities
  • Styling & Themes
  • Common Features
  • Project Setup
  • Knowledge Base
  • Sample Applications
  • FAQ
  • Troubleshooting
  • Updates
  • Changelogs
New to Kendo UI for Angular? Start a free 30-day trial

WorkbookSheetRowCell

The sheets cell configuration.

NameTypeDefaultDescription

background?

string

Sets the background color of the cell. Supports hex CSS-like values that start with "#" e.g. "#ff00ff".

bold?

boolean

Setting it to true makes the cell value bold.

borderBottom?

WorkbookSheetRowCellBorderBottom

The style information for the bottom border of the cell.

borderLeft?

WorkbookSheetRowCellBorderLeft

The style information for the left border of the cell.

borderRight?

WorkbookSheetRowCellBorderRight

The style information for the right border of the cell.

borderTop?

WorkbookSheetRowCellBorderTop

The style information for the top border of the cell.

color?

string

The text color of the cell. Supports hex CSS-like values that start with "#" e.g. "#ff00ff".

colSpan?

number

Sets the number of columns that a cell occupies.

disabled?

boolean

Specifies if the cell is disabled.

fontFamily?

string

Sets the font used to display the cell value.

fontSize?

number

Sets the font size in pixels.

format?

string

Sets the format that Excel uses to display the cell value.

formula?

string

Sets the formula that Excel uses to compute and display the cell value

index?

any

The zero-based index of the cell in the row. Records missing an index will be placed in the first available cell on the row.

Mixing indexed with non-indexed cells might yield invalid results. If you want to use both, place the indexed cells at the end of the array.

italic?

boolean

Setting it to true italicizes the cell value.

rowSpan?

number

Sets the number of rows that a cell occupies.

textAlign?

"left" | "center" | "right"

Sets the horizontal alignment of the cell value. Supported values are "left", "center" and "right".

underline?

boolean

Setting it to true underlines the cell value.

value?

string | number | boolean | Date

The value of the cell. Numbers and dates will be formatted as strings. String values are HTML encoded.

verticalAlign?

"center" | "top" | "bottom"

Sets the vertical alignment of the cell value. Supported values are "top", "center" and "bottom".

wrap?

boolean

Setting it to true wraps the cell value.