igSpreadsheet
Namespace: Wisej.Web.Ext.Ignite
Assembly: Wisej.Web.Ext.Ignite (4.1.0.0)
The igSpreadsheet control allows visualization of spreadsheet data, represented by the data model supported by the Infragistics Javascript Excel Library comprising of Workbooks, Worksheets, Cells, Formulas and more.
- C#
- VB.NET
public class igSpreadsheet : igBase
Public Class igSpreadsheet
Inherits igBase
The client widget defines two functions that can be invoked from the server using Call:
loadWorkbook(url) downloads the Excel file at the specified URL and displays it in the spreadsheet.
exportWorkbook() saves the workbook loaded using loadWorkbook in the browser and fires the WidgetEvent event with the type "export" and the saved content in the event data.
Constructors
igSpreadsheet()
Constructs a new instance of the igSpreadsheet class.
Example:
The following example creates a spreadsheet, configures it through the Options object and loads an Excel file.
var spreadsheet = new igSpreadsheet();
spreadsheet.Options.isFormulaBarVisible = true;
spreadsheet.Options.areGridlinesVisible = false;
spreadsheet.Dock = DockStyle.Fill;
this.Controls.Add(spreadsheet);
spreadsheet.Call("loadWorkbook", "Data/Sales.xlsx");
igSpreadsheet(options)
Constructs a new instance of the igSpreadsheet class using the specified options.
| Name | Type | Description |
|---|---|---|
| options | Object | Initial set of options passed to the igSpreadsheet widget: an anonymous object, a JSON string or a dynamic object. |
Example:
The following example creates a spreadsheet without the formula bar and zoomed at 125%.
var spreadsheet = new igSpreadsheet(new
{
isFormulaBarVisible = false,
zoomLevel = 125
});
spreadsheet.Dock = DockStyle.Fill;
this.Controls.Add(spreadsheet);