Link Search Menu Expand Document

SpreadsheetWebControl Methods

The SpreadsheetWebControl type exposes the following members.

Methods
NameDescription
Protected methodAddAttributesToRender
Adds HTML attributes and styles that need to be rendered to the specified HtmlTextWriterTag. This method is used primarily by control developers.
(Inherited from WebControl.)
Protected methodAddedControl
Called after a child control is added to the Controls collection of the Control object.
(Inherited from Control.)
Protected methodAddParsedSubObject
Notifies the server control that an element, either XML or HTML, was parsed, and adds the element to the server control's ControlCollection object.
(Inherited from Control.)
Public methodApplyStyle
Copies any nonblank elements of the specified style to the Web control, overwriting any existing style elements of the control. This method is primarily used by control developers.
(Inherited from WebControl.)
Public methodApplyStyleSheetSkin
Applies the style properties defined in the page style sheet to the control.
(Inherited from Control.)
Protected methodBeginRenderTracing (Inherited from Control.)
Protected methodBuildProfileTree
Gathers information about the server control and delivers it to the Trace property to be displayed when tracing is enabled for the page.
(Inherited from Control.)
Protected methodClearCachedClientID (Inherited from Control.)
Protected methodClearChildControlState
Deletes the control-state information for the server control's child controls.
(Inherited from Control.)
Protected methodClearChildState
Deletes the view-state and control-state information for all the server control's child controls.
(Inherited from Control.)
Protected methodClearChildViewState
Deletes the view-state information for all the server control's child controls.
(Inherited from Control.)
Protected methodClearEffectiveClientIDMode (Inherited from Control.)
Public methodClose
Closes this instance.
Public methodCopyBaseAttributes
Copies the properties not encapsulated by the Style object from the specified Web server control to the Web server control that this method is called from. This method is used primarily by control developers.
(Inherited from WebControl.)
Protected methodCreateChildControls
Called by the ASP.NET page framework to notify server controls that use composition-based implementation to create any child controls they contain in preparation for posting back or rendering.
(Inherited from Control.)
Protected methodCreateControlCollection
Creates a new ControlCollection object to hold the child controls (both literal and server) of the server control.
(Inherited from Control.)
Protected methodCreateControlStyle
Creates the style object that is used internally by the WebControl class to implement all style related properties. This method is used primarily by control developers.
(Inherited from WebControl.)
Public methodDataBind
Binds a data source to the invoked server control and all its child controls.
(Inherited from Control.)
Protected methodDataBind(Boolean)
Binds a data source to the invoked server control and all its child controls with an option to raise the DataBinding event.
(Inherited from Control.)
Protected methodDataBindChildren
Binds a data source to the server control's child controls.
(Inherited from Control.)
Public methodDispose
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
Protected methodEndRenderTracing (Inherited from Control.)
Protected methodEnsureChildControls
Determines whether the server control contains child controls. If it does not, it creates child controls.
(Inherited from Control.)
Protected methodEnsureID
Creates an identifier for controls that do not have an identifier assigned.
(Inherited from Control.)
Public methodEquals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
Protected methodFinalize
Releases unmanaged resources and performs other cleanup operations before theSpreadsheet is reclaimed by garbage collection.
(Overrides ObjectFinalize.)
Public methodFindControl(String)
Searches the current naming container for a server control with the specified id parameter.
(Inherited from Control.)
Protected methodFindControl(String, Int32)
Searches the current naming container for a server control with the specified id and an integer, specified in the pathOffset parameter, which aids in the search. You should not override this version of the FindControl method.
(Inherited from Control.)
Public methodFocus
Sets input focus to a control.
(Inherited from Control.)
Public methodGetAsBytesArray
Gets the bytes of spreadsheet saved as document with specified type.
Public methodGetAsBytesArrayCSV
Gets the bytes of spreadsheet saved as CSV document.
Public methodGetAsBytesArrayHTML
Gets the bytes of spreadsheet saved as HTML document.
Public methodGetAsBytesArrayHTML(Int32)
Gets the bytes of specified worksheet page saved as HTML document.
Public methodGetAsBytesArrayTXT
Gets the bytes of spreadsheet saved as text document.
Public methodGetAsBytesArrayXLS
Gets the bytes of spreadsheet saved as XLS document.
Public methodGetAsBytesArrayXLSX
Gets the bytes of spreadsheet saved as XLSX document.
Public methodGetAsBytesArrayXML
Gets the bytes of spreadsheet saved as XML document.
Protected methodGetDesignModeState
Gets design-time data for a control.
(Inherited from Control.)
Public methodGetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
Public methodGetRouteUrl(Object) (Inherited from Control.)
Public methodGetRouteUrl(RouteValueDictionary) (Inherited from Control.)
Public methodGetRouteUrl(String, Object) (Inherited from Control.)
Public methodGetRouteUrl(String, RouteValueDictionary) (Inherited from Control.)
Public methodGetType
Gets the type of the current instance.
(Inherited from Object.)
Public methodGetUniqueIDRelativeTo (Inherited from Control.)
Public methodHasControls
Determines if the server control contains any child controls.
(Inherited from Control.)
Protected methodHasEvents
Returns a value indicating whether events are registered for the control or any child controls.
(Inherited from Control.)
Protected methodIsLiteralContent
Determines if the server control holds only literal content.
(Inherited from Control.)
Protected methodLoadControlState
Restores control-state information from a previous page request that was saved by the SaveControlState method.
(Inherited from Control.)
Public methodLoadFromFile(String)
Load data from file.
Public methodLoadFromFile(String, CacheType)
Load data from file.
Public methodLoadFromFile(String, String)
Load data from file.
Public methodLoadFromFile(String, CacheType, String)
Load data from file.
Public methodLoadFromFile(String, String, Encoding)
Load data from file.
Public methodLoadFromFile(String, CacheType, String, Encoding)
Load data from file.
Public methodLoadFromFile(String, CacheType, String, Encoding, String)
Load data from file.
Public methodLoadFromStream(Stream)
Load data from stream.
Public methodLoadFromStream(Stream, CacheType)
Load data from stream.
Public methodLoadFromStream(Stream, SpreadsheetFormatType)
Load data from stream.
Public methodLoadFromStream(Stream, SpreadsheetFormatType, CacheType)
Load data from stream.
Public methodLoadFromStream(Stream, SpreadsheetFormatType, String, Encoding)
Load data from stream.
Public methodLoadFromStream(Stream, SpreadsheetFormatType, CacheType, String, Encoding)
Load data from stream.
Protected methodLoadViewState
Restores view-state information from a previous request that was saved with the SaveViewState method.
(Inherited from WebControl.)
Protected methodMapPathSecure
Retrieves the physical path that a virtual path, either absolute or relative, maps to.
(Inherited from Control.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Public methodMergeStyle
Copies any nonblank elements of the specified style to the Web control, but will not overwrite any existing style elements of the control. This method is used primarily by control developers.
(Inherited from WebControl.)
Protected methodOnBubbleEvent
Determines whether the event for the server control is passed up the page's UI server control hierarchy.
(Inherited from Control.)
Protected methodOnDataBinding
Raises the DataBinding event.
(Inherited from Control.)
Protected methodOnInit
Raises the Init event.
(Inherited from Control.)
Protected methodOnLoad
Raises the Load event.
(Inherited from Control.)
Protected methodOnPreRender
Raises the PreRender event.
(Inherited from Control.)
Protected methodOnUnload
Raises the Unload event.
(Inherited from Control.)
Protected methodOpenFile
Gets a Stream used to read a file.
(Inherited from Control.)
Protected methodRaiseBubbleEvent
Assigns any sources of the event and its information to the control's parent.
(Inherited from Control.)
Protected methodRemovedControl
Called after a child control is removed from the Controls collection of the Control object.
(Inherited from Control.)
Protected methodRender
Renders the control to the specified HTML writer.
(Inherited from WebControl.)
Public methodRenderBeginTag
Renders the HTML opening tag of the control to the specified writer. This method is used primarily by control developers.
(Overrides WebControlRenderBeginTag(HtmlTextWriter).)
Protected methodRenderChildren
Outputs the content of a server control's children to a provided HtmlTextWriter object, which writes the content to be rendered on the client.
(Inherited from Control.)
Protected methodRenderContents
Renders the contents.
(Overrides WebControlRenderContents(HtmlTextWriter).)
Public methodRenderControl(HtmlTextWriter)
Outputs server control content to a provided HtmlTextWriter object and stores tracing information about the control if tracing is enabled.
(Inherited from Control.)
Protected methodRenderControl(HtmlTextWriter, ControlAdapter)
Outputs server control content to a provided HtmlTextWriter object using a provided ControlAdapter object.
(Inherited from Control.)
Public methodRenderEndTag
Renders the HTML closing tag of the control into the specified writer. This method is used primarily by control developers.
(Overrides WebControlRenderEndTag(HtmlTextWriter).)
Protected methodResolveAdapter
Gets the control adapter responsible for rendering the specified control.
(Inherited from Control.)
Public methodResolveClientUrl
Gets a URL that can be used by the browser.
(Inherited from Control.)
Public methodResolveUrl
Converts a URL into one that is usable on the requesting client.
(Inherited from Control.)
Public methodSaveAs(String)
Saves data in XLS or XLSX file FileName
Public methodSaveAs(String, SpreadsheetFormatType)
Saves data in XLS or XLSX file FileName
Public methodSaveAsCSV
Saves data in CSV file with specified name
Public methodSaveAsHTML(String)
Saves spreadsheet in a HTML format file. The second and subsequent worksheets of the spreadsheet will be saved in separate files with auto-generated names.
Public methodSaveAsHTML(String, Boolean)
Saves spreadsheet in a HTML format file. The second and subsequent worksheets of the spreadsheet will be saved in separate files with auto-generated names.
Public methodSaveAsTXT
Saves data in TXT file with specified name
Public methodSaveAsXLS
Saves data in XLS file with specified name
Public methodSaveAsXLSX
Saves data in XLSX format to a file with specified name
Public methodSaveAsXML
Saves data in XML file with specified name
Protected methodSaveControlState
Saves any server control state changes that have occurred since the time the page was posted back to the server.
(Inherited from Control.)
Public methodSaveToStream(Stream)
Saves data in XLS format to a given stream
Public methodSaveToStream(Stream, SpreadsheetFormatType)
Saves data in XLS or XLSX format to a given stream
Public methodSaveToStreamCSV
Saves data in CSV format to a given stream
Public methodSaveToStreamHTML(Stream)
Saves first worksheet of spreadsheet as HTML document to a given stream.
Public methodSaveToStreamHTML(Stream, Int32)
Saves a worksheet of spreadsheet as HTML document to a given stream.
Public methodSaveToStreamTXT
Saves data in TXT format to a given stream
Public methodSaveToStreamXLS
Saves data in XLS format to a given stream
Public methodSaveToStreamXLSX
Saves data in XLSX format to a given stream
Public methodSaveToStreamXML
Saves data in XML format to a given stream
Protected methodSaveViewState
Saves any state that was modified after the TrackViewState method was invoked.
(Inherited from WebControl.)
Protected methodSetDesignModeState
Sets design-time data for a control.
(Inherited from Control.)
Public methodSetRenderMethodDelegate
Assigns an event handler delegate to render the server control and its content into its parent control.
(Inherited from Control.)
Public methodSetTraceData(Object, Object) (Inherited from Control.)
Public methodSetTraceData(Object, Object, Object) (Inherited from Control.)
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Protected methodTrackViewState
Causes the control to track changes to its view state so they can be stored in the object's ViewState property.
(Inherited from WebControl.)
Public methodWorksheet
Return Worksheet the specified index.
Top
See Also

Reference