Class Spreadsheet

Inheritance
System.Object
TagHelper
EJTagHelper
Spreadsheet
Inherited Members
System.Object.ToString()
System.Object.Equals(System.Object)
System.Object.Equals(System.Object, System.Object)
System.Object.ReferenceEquals(System.Object, System.Object)
System.Object.GetHashCode()
System.Object.GetType()
System.Object.MemberwiseClone()
Namespace: Syncfusion.EJ2.Spreadsheet
Assembly: Syncfusion.EJ2.dll
Syntax
public class Spreadsheet : EJTagHelper

Constructors

Spreadsheet()

Declaration
public Spreadsheet()

Properties

ActionBegin

Triggers when the Spreadsheet actions (such as editing, formatting, sorting etc..) are starts.

Declaration
[HtmlAttributeName("actionBegin")]
public string ActionBegin { get; set; }
Property Value
Type Description
System.String

ActionComplete

Triggers when the spreadsheet actions (such as editing, formatting, sorting etc..) gets completed.

Declaration
[HtmlAttributeName("actionComplete")]
public string ActionComplete { get; set; }
Property Value
Type Description
System.String

ActiveSheetIndex

Specifies active sheet index in workbook.

Declaration
[HtmlAttributeName("activeSheetIndex")]
public int ActiveSheetIndex { get; set; }
Property Value
Type Description
System.Int32

AfterHyperlinkClick

Triggers when the Hyperlink function gets completed.

Declaration
[HtmlAttributeName("afterHyperlinkClick")]
public string AfterHyperlinkClick { get; set; }
Property Value
Type Description
System.String

AfterHyperlinkCreate

Triggers after the hyperlink inserted.

Declaration
[HtmlAttributeName("afterHyperlinkCreate")]
public string AfterHyperlinkCreate { get; set; }
Property Value
Type Description
System.String

AllowCellFormatting

It allows you to apply styles (font size, font weight, font family, fill color, and more) to the spreadsheet cells.

Declaration
[HtmlAttributeName("allowCellFormatting")]
public bool AllowCellFormatting { get; set; }
Property Value
Type Description
System.Boolean

AllowChart

It allows you to insert the chart in spreadsheet.

Declaration
[HtmlAttributeName("allowChart")]
public bool AllowChart { get; set; }
Property Value
Type Description
System.Boolean

AllowConditionalFormat

It allows you to apply conditional formatting to the sheet.

Declaration
[HtmlAttributeName("allowConditionalFormat")]
public bool AllowConditionalFormat { get; set; }
Property Value
Type Description
System.Boolean

AllowDataValidation

It allows you to apply validation to the spreadsheet cells.

Declaration
[HtmlAttributeName("allowDataValidation")]
public bool AllowDataValidation { get; set; }
Property Value
Type Description
System.Boolean

AllowDelete

It allows you to delete rows, columns and sheets from spreadsheet.

Declaration
[HtmlAttributeName("allowDelete")]
public bool AllowDelete { get; set; }
Property Value
Type Description
System.Boolean

AllowEditing

It allows you to add new data or update existing cell data. If it is false, it will act as read only mode.

Declaration
[HtmlAttributeName("allowEditing")]
public bool AllowEditing { get; set; }
Property Value
Type Description
System.Boolean

AllowFiltering

It allows to enable/disable filter and its functionalities.

Declaration
[HtmlAttributeName("allowFiltering")]
public bool AllowFiltering { get; set; }
Property Value
Type Description
System.Boolean

AllowFindAndReplace

Declaration
[HtmlAttributeName("allowFindAndReplace")]
public bool AllowFindAndReplace { get; set; }
Property Value
Type Description
System.Boolean

It allows to enable/disable Hyperlink and its functionalities.

Declaration
[HtmlAttributeName("allowHyperlink")]
public bool AllowHyperlink { get; set; }
Property Value
Type Description
System.Boolean

AllowImage

It allows you to insert the image in spreadsheet.

Declaration
[HtmlAttributeName("allowImage")]
public bool AllowImage { get; set; }
Property Value
Type Description
System.Boolean

AllowInsert

It allows you to insert rows, columns and sheets in to the spreadsheet.

Declaration
[HtmlAttributeName("allowInsert")]
public bool AllowInsert { get; set; }
Property Value
Type Description
System.Boolean

AllowMerge

It allows you to merge the range of cells.

Declaration
[HtmlAttributeName("allowMerge")]
public bool AllowMerge { get; set; }
Property Value
Type Description
System.Boolean

AllowNumberFormatting

It allows formatting a raw number into different types of formats (number, currency, accounting, percentage, short date, long date, time, fraction, scientific, and text) with built-in format codes.

Declaration
[HtmlAttributeName("allowNumberFormatting")]
public bool AllowNumberFormatting { get; set; }
Property Value
Type Description
System.Boolean

AllowOpen

It allows you to open an Excel file (.xlsx, .xls, and .csv) in Spreadsheet.

Declaration
[HtmlAttributeName("allowOpen")]
public bool AllowOpen { get; set; }
Property Value
Type Description
System.Boolean

AllowResizing

If allowResizing is set to true, spreadsheet columns and rows can be resized.

Declaration
[HtmlAttributeName("allowResizing")]
public bool AllowResizing { get; set; }
Property Value
Type Description
System.Boolean

AllowSave

It allows you to save Spreadsheet with all data as Excel file (.xlsx, .xls, and .csv).

Declaration
[HtmlAttributeName("allowSave")]
public bool AllowSave { get; set; }
Property Value
Type Description
System.Boolean

AllowScrolling

It specifies whether the Spreadsheet should be rendered with scrolling or not. To customize the Spreadsheet scrolling behavior, use the scrollSettings property.

Declaration
[HtmlAttributeName("allowScrolling")]
public bool AllowScrolling { get; set; }
Property Value
Type Description
System.Boolean

AllowSorting

It allows to enable/disable sort and its functionalities.

Declaration
[HtmlAttributeName("allowSorting")]
public bool AllowSorting { get; set; }
Property Value
Type Description
System.Boolean

AllowUndoRedo

It allows to enable/disable undo and redo functionalities.

Declaration
[HtmlAttributeName("allowUndoRedo")]
public bool AllowUndoRedo { get; set; }
Property Value
Type Description
System.Boolean

AllowWrap

It allows to enable/disable wrap text feature. By using this feature the wrapping applied cell text can wrap to the next line, if the text width exceeds the column width.

Declaration
[HtmlAttributeName("allowWrap")]
public bool AllowWrap { get; set; }
Property Value
Type Description
System.Boolean

BeforeCellFormat

Triggers before the cell format applied to the cell.

Declaration
[HtmlAttributeName("beforeCellFormat")]
public string BeforeCellFormat { get; set; }
Property Value
Type Description
System.String

BeforeCellRender

Triggers before the cell appended to the DOM.

Declaration
[HtmlAttributeName("beforeCellRender")]
public string BeforeCellRender { get; set; }
Property Value
Type Description
System.String

BeforeCellSave

Triggers when before the cell is saved.

Declaration
[HtmlAttributeName("beforeCellSave")]
public string BeforeCellSave { get; set; }
Property Value
Type Description
System.String

BeforeDataBound

Triggers before the data is populated to the worksheet.

Declaration
[HtmlAttributeName("beforeDataBound")]
public string BeforeDataBound { get; set; }
Property Value
Type Description
System.String

BeforeHyperlinkClick

Triggers when the Hyperlink is clicked.

Declaration
[HtmlAttributeName("beforeHyperlinkClick")]
public string BeforeHyperlinkClick { get; set; }
Property Value
Type Description
System.String

BeforeHyperlinkCreate

Triggers before insert a hyperlink.

Declaration
[HtmlAttributeName("beforeHyperlinkCreate")]
public string BeforeHyperlinkCreate { get; set; }
Property Value
Type Description
System.String

BeforeOpen

Triggers before opening an Excel file.

Declaration
[HtmlAttributeName("beforeOpen")]
public string BeforeOpen { get; set; }
Property Value
Type Description
System.String

BeforeSave

Triggers before saving the Spreadsheet as Excel file.

Declaration
[HtmlAttributeName("beforeSave")]
public string BeforeSave { get; set; }
Property Value
Type Description
System.String

BeforeSelect

Triggers before the cell or range of cells being selected.

Declaration
[HtmlAttributeName("beforeSelect")]
public string BeforeSelect { get; set; }
Property Value
Type Description
System.String

BeforeSort

Triggers before sorting the specified range.

Declaration
[HtmlAttributeName("beforeSort")]
public string BeforeSort { get; set; }
Property Value
Type Description
System.String

CellEdit

Triggers when the cell is being edited.

Declaration
[HtmlAttributeName("cellEdit")]
public string CellEdit { get; set; }
Property Value
Type Description
System.String

CellEditing

Triggers every time a request is made to access cell information. This will be triggered when editing a cell.

Declaration
[HtmlAttributeName("cellEditing")]
public string CellEditing { get; set; }
Property Value
Type Description
System.String

CellSave

Triggers when the edited cell is saved.

Declaration
[HtmlAttributeName("cellSave")]
public string CellSave { get; set; }
Property Value
Type Description
System.String

CellStyle

Specifies the cell style options.

Declaration
[HtmlAttributeName("cellStyle")]
public SpreadsheetCommonCellStyle CellStyle { get; set; }
Property Value
Type Description
SpreadsheetCommonCellStyle

ClassName

Declaration
protected override string ClassName { get; }
Property Value
Type Description
System.String
Overrides

ContextMenuBeforeClose

Triggers before closing the context menu.

Declaration
[HtmlAttributeName("contextMenuBeforeClose")]
public string ContextMenuBeforeClose { get; set; }
Property Value
Type Description
System.String

ContextMenuBeforeOpen

Triggers before opening the context menu and it allows customizing the menu items.

Declaration
[HtmlAttributeName("contextMenuBeforeOpen")]
public string ContextMenuBeforeOpen { get; set; }
Property Value
Type Description
System.String

ContextMenuItemSelect

Triggers when the context menu item is selected.

Declaration
[HtmlAttributeName("contextMenuItemSelect")]
public string ContextMenuItemSelect { get; set; }
Property Value
Type Description
System.String

Created

Triggers when the component is created.

Declaration
[HtmlAttributeName("created")]
public string Created { get; set; }
Property Value
Type Description
System.String

CssClass

To specify a CSS class or multiple CSS class separated by a space, add it in the Spreadsheet root element. This allows you to customize the appearance of component.

Declaration
[HtmlAttributeName("cssClass")]
public string CssClass { get; set; }
Property Value
Type Description
System.String

DataBound

Triggers when the data is populated in the worksheet.

Declaration
[HtmlAttributeName("dataBound")]
public string DataBound { get; set; }
Property Value
Type Description
System.String

DataSourceChanged

Triggers during data changes when the data is provided as dataSource in the Spreadsheet.

Declaration
[HtmlAttributeName("dataSourceChanged")]
public string DataSourceChanged { get; set; }
Property Value
Type Description
System.String

DefinedNames

Specifies the name for a range and uses it in formula for calculation.

Declaration
[HtmlAttributeName("definedNames")]
public List<DefinedName> DefinedNames { get; set; }
Property Value
Type Description
System.Collections.Generic.List<DefinedName>

DialogBeforeOpen

Triggers before opening the dialog box.

Declaration
[HtmlAttributeName("dialogBeforeOpen")]
public string DialogBeforeOpen { get; set; }
Property Value
Type Description
System.String

EnableClipboard

It enables or disables the clipboard operations (cut, copy, and paste) of the Spreadsheet.

Declaration
[HtmlAttributeName("enableClipboard")]
public bool EnableClipboard { get; set; }
Property Value
Type Description
System.Boolean

EnableContextMenu

It enables or disables the context menu option of spreadsheet. By default, context menu will opens for row header, column header, sheet tabs, and cell.

Declaration
[HtmlAttributeName("enableContextMenu")]
public bool EnableContextMenu { get; set; }
Property Value
Type Description
System.Boolean

EnableKeyboardNavigation

It allows you to interact with cell, sheet tabs, formula bar, and ribbon through the keyboard device.

Declaration
[HtmlAttributeName("enableKeyboardNavigation")]
public bool EnableKeyboardNavigation { get; set; }
Property Value
Type Description
System.Boolean

EnableKeyboardShortcut

It enables shortcut keys to perform Spreadsheet operations like open, save, copy, paste, and more.

Declaration
[HtmlAttributeName("enableKeyboardShortcut")]
public bool EnableKeyboardShortcut { get; set; }
Property Value
Type Description
System.Boolean

EnablePersistence

Enable or disable persisting component's state between page reloads.

Declaration
[HtmlAttributeName("enablePersistence")]
public bool EnablePersistence { get; set; }
Property Value
Type Description
System.Boolean

EnableRtl

Enable or disable rendering component in right to left direction.

Declaration
[HtmlAttributeName("enableRtl")]
public bool EnableRtl { get; set; }
Property Value
Type Description
System.Boolean

FileMenuBeforeClose

Triggers before closing the file menu.

Declaration
[HtmlAttributeName("fileMenuBeforeClose")]
public string FileMenuBeforeClose { get; set; }
Property Value
Type Description
System.String

FileMenuBeforeOpen

Triggers before opening the file menu.

Declaration
[HtmlAttributeName("fileMenuBeforeOpen")]
public string FileMenuBeforeOpen { get; set; }
Property Value
Type Description
System.String

FileMenuItemSelect

Triggers when the file menu item is selected.

Declaration
[HtmlAttributeName("fileMenuItemSelect")]
public string FileMenuItemSelect { get; set; }
Property Value
Type Description
System.String

filterCollection

Specifies Filter Type.

Declaration
[HtmlAttributeName("filterCollection")]
public List<FilterCollectionModel> filterCollection { get; set; }
Property Value
Type Description
System.Collections.Generic.List<FilterCollectionModel>

Height

Defines the height of the Spreadsheet. It accepts height as pixels, number, and percentage.

Declaration
[HtmlAttributeName("height")]
public string Height { get; set; }
Property Value
Type Description
System.String

HtmlAttributes

Allows additional HTML attributes such as title, name, etc., and accepts n number of attributes in a key-value pair format.

Declaration
[HtmlAttributeName("htmlAttributes")]
public object HtmlAttributes { get; set; }
Property Value
Type Description
System.Object

IsFor

Declaration
protected override bool IsFor { get; }
Property Value
Type Description
System.Boolean
Overrides

IsProtected

Specifies to protect the workbook.

Declaration
[HtmlAttributeName("isProtected")]
public bool IsProtected { get; set; }
Property Value
Type Description
System.Boolean

Locale

Overrides the global culture and localization value for this component. Default global culture is 'en-US'.

Declaration
[HtmlAttributeName("locale")]
public string Locale { get; set; }
Property Value
Type Description
System.String

NameSpace

Declaration
protected override string NameSpace { get; }
Property Value
Type Description
System.String
Overrides

OpenComplete

Triggers when the spreadsheet importing gets completed.

Declaration
[HtmlAttributeName("openComplete")]
public string OpenComplete { get; set; }
Property Value
Type Description
System.String

OpenFailure

Triggers when the opened Excel file fails to load.

Declaration
[HtmlAttributeName("openFailure")]
public string OpenFailure { get; set; }
Property Value
Type Description
System.String

OpenUrl

Specifies the service URL to open excel file in spreadsheet.

Declaration
[HtmlAttributeName("openUrl")]
public string OpenUrl { get; set; }
Property Value
Type Description
System.String

Password

Specifies the password.

Declaration
[HtmlAttributeName("password")]
public string Password { get; set; }
Property Value
Type Description
System.String

QueryCellInfo

Triggered every time a request is made to access cell information.

Declaration
[HtmlAttributeName("queryCellInfo")]
public string QueryCellInfo { get; set; }
Property Value
Type Description
System.String

SaveComplete

Triggers after saving the Spreadsheet as Excel file.

Declaration
[HtmlAttributeName("saveComplete")]
public string SaveComplete { get; set; }
Property Value
Type Description
System.String

SaveUrl

Specifies the service URL to save spreadsheet as Excel file.

Declaration
[HtmlAttributeName("saveUrl")]
public string SaveUrl { get; set; }
Property Value
Type Description
System.String

ScrollSettings

Configures the scroll settings.

Declaration
[HtmlAttributeName("scrollSettings")]
public SpreadsheetScrollSettings ScrollSettings { get; set; }
Property Value
Type Description
SpreadsheetScrollSettings

Select

Triggers after the cell or range of cells is selected.

Declaration
[HtmlAttributeName("select")]
public string Select { get; set; }
Property Value
Type Description
System.String

SelectionSettings

Configures the selection settings. typescript new Spreadsheet({ selectionSettings: { mode: 'None' } ... }, '#Spreadsheet');

Declaration
[HtmlAttributeName("selectionSettings")]
public SpreadsheetSelectionSettings SelectionSettings { get; set; }
Property Value
Type Description
SpreadsheetSelectionSettings

Sheets

Configures sheets and its options.

Declaration
[HtmlAttributeName("sheets")]
public List<Sheet> Sheets { get; set; }
Property Value
Type Description
System.Collections.Generic.List<Sheet>

ShowFormulaBar

It shows or hides the formula bar and its features.

Declaration
[HtmlAttributeName("showFormulaBar")]
public bool ShowFormulaBar { get; set; }
Property Value
Type Description
System.Boolean

ShowRibbon

It shows or hides the ribbon in spreadsheet.

Declaration
[HtmlAttributeName("showRibbon")]
public bool ShowRibbon { get; set; }
Property Value
Type Description
System.Boolean

ShowSheetTabs

It shows or hides the sheets tabs, this is used to navigate among the sheets and create or delete sheets by UI interaction.

Declaration
[HtmlAttributeName("showSheetTabs")]
public bool ShowSheetTabs { get; set; }
Property Value
Type Description
System.Boolean

sortCollection

Specifies sort Type.

Declaration
[HtmlAttributeName("sortCollection")]
public List<SortCollectionModel> sortCollection { get; set; }
Property Value
Type Description
System.Collections.Generic.List<SortCollectionModel>

SortComplete

Triggers after sorting action is completed.

Declaration
[HtmlAttributeName("sortComplete")]
public string SortComplete { get; set; }
Property Value
Type Description
System.String

TagName

Declaration
protected override string TagName { get; }
Property Value
Type Description
System.String
Overrides

Width

Defines the width of the Spreadsheet. It accepts width as pixels, number, and percentage.

Declaration
[HtmlAttributeName("width")]
public string Width { get; set; }
Property Value
Type Description
System.String