WebWorksheets Members - Aspose.Grid for .NET

Public Instance Properties

ActiveSheet	Gets the active sheet object.
ActiveSheetIndex	Specifies the index of the active sheet which should be displayed in the GridWeb control.
Count	Gets the sheets count.
DefaultFontName	Gets or sets the websheet's default font name.
DefaultFontSize	Gets or sets the websheet's default font size.
IsFixedSize	Gets a value indicating whether the collection has a fixed size.
IsReadOnly	Gets a value indicating whether the IList is read-only.
IsSynchronized	Gets a value indicating if access to the ICollection is synchronized (thread-safe).
Item	Gets a worksheet object from the collection by a integer index or a sheet name string. The index could be a integer or a string.
PivotCaches	Gets the PivotCache collection object
PivotTables	Gets the pivotTable collection object.
SyncRoot	Gets an object that can be used to synchronize access to the ICollection.

Public Instance Methods

Add	Overloaded. Adds a new WebWorksheet.
AddCopy	Overloaded. Adds a worksheet to the collection and copys data from an existed worksheet.
Clear	Clears all sheets.
ClearCustomFunctionHandlers	Clear all the custom functions.
Contains	Indicates whether the collection contains the sheet.
CopyTo	Copys contents to an array.
Equals (inherited from Object)	Determines whether the specified Object is equal to the current Object.
GetEnumerator	Gets a enumerator.
GetHashCode (inherited from Object)	Serves as a hash function for a particular type. GetHashCode is suitable for use in hashing algorithms and data structures like a hash table.
GetType (inherited from Object)	Gets the Type of the current instance.
ImportDataView	Overloaded. Imports from a DataView. Creates a sheet with the DataView's table name automatically.
ImportExcelFile	Overloaded. Imports from an excel file.
IndexOf	Gets the index of the sheet.
Insert	Inserts a sheet to the index.
LoadCSVFile	Overloaded. Loads data from a CSV file.
LoadSpreadSheetMLFile	Overloaded. Loads data from a SpreadSheetML file.
RegisterCustomFunctionHandler	Register a custom function handler used in the formulas.
Remove	Removes a sheet.
RemoveAt	Overloaded. Removes the element at a specified name.
RunAllFormulas	Runs all the cells's formula.
SaveCSVFile	Overloaded. Saves data to a CSV file.
SaveDataToExcelFile	Saves data only to a excel file with a predefined excel template file, without saving styles.
SaveSpreadSheetMLFile	Overloaded. Saves data to a SpreadSheetML file.
SaveToExcelFile	Overloaded. Saves the worksheets to a excel file.
ToString (inherited from Object)	Returns a String that represents the current Object.
UnregisterCustomFunctionHandler	Unregister a custom function.

Protected Instance Constructors

WebWorksheets Constructor

Internal used only.

Protected Instance Methods

Finalize (inherited from Object)	Allows an Object to attempt to free resources and perform other cleanup operations before the Object is reclaimed by garbage collection.
MemberwiseClone (inherited from Object)	Creates a shallow copy of the current Object.

Public Instance Properties

Public Instance Methods

Protected Instance Constructors

Protected Instance Methods

See Also