SpreadsheetControl Methods
Emulates the Microsoft® Excel® appearance and allows you to create, load, edit, save and print spreadsheet documents.
Name | Description |
---|---|
About() static | Invokes the About dialog box. |
Accessibility |
Notifies the accessibility client applications of the specified Accessible |
Accessibility |
Notifies the accessibility client applications of the specified Accessible |
Add |
Adds the specified service to the service container. |
Add |
Adds the specified service to the service container. |
Add |
Adds the specified service to the service container. |
Add |
Adds the specified service to the service container. |
Add |
Adds the specified ribbon tabs/bar groups to the existing ribbon or toolbar menu. |
Assign |
Assigns a shortcut key to a command. |
Begin |
Executes the specified delegate asynchronously with the specified arguments, on the thread that the control’s underlying handle was created on. Inherited from Control. |
Begin |
Executes the specified delegate asynchronously on the thread that the control’s underlying handle was created on. Inherited from Control. |
Begin |
Locks the Spreadsheet |
Bring |
Brings the control to the front of the z-order. Inherited from Control. |
Cancel |
This method supports the internal infrastructure and is not intended to be called directly from your code. Use the Spreadsheet |
Circle |
Displays circles around invalid data in a worksheet to which data validation is applied. |
Clear |
Hides circles around invalid data in a worksheet to which data validation is applied. |
Close |
Closes the cell editor. |
Contains |
Retrieves a value indicating whether the specified control is a child of the control. Inherited from Control. |
Create |
Creates a Bar |
Create |
Adds a Bar |
Create |
Creates a command by its identifier. |
Create |
Forces the creation of the visible control, including the creation of the handle and any visible child controls. Inherited from Control. |
Create |
Creates a new instance of the control collection for the control. Inherited from Control. |
Create |
Creates the Graphics for the control. Inherited from Control. |
Create |
Creates a handle for the control. Inherited from Control. |
Create |
Creates and loads a new empty workbook. |
Create |
Creates an object that contains all the relevant information required to generate a proxy used to communicate with a remote object.
Inherited from Marshal |
Create |
Creates a Ribbon |
Create |
Adds a Ribbon |
Create |
Creates a Ribbon |
Create |
Creates a Ribbon |
Create |
Adds a status bar with all Spreadsheet-related items to the Spreadsheet control with a Bar UI. |
Create |
Adds a status bar with the specified items to the Spreadsheet control with a Bar UI. |
Def |
Sends the specified message to the default window procedure. Inherited from Control. |
Destroy |
Destroys the handle associated with the control. Inherited from Control. |
Dispose() | Releases all resources used by the Component. Inherited from Component. |
Do |
Begins a drag-and-drop operation. Inherited from Control. |
Draw |
Supports rendering to the specified bitmap. Inherited from Control. |
End |
Retrieves the return value of the asynchronous operation represented by the IAsync |
End |
Unlocks the Spreadsheet |
Equals |
Determines whether the specified object instances are considered equal. Inherited from Object. |
Equals |
Determines whether the specified object is equal to the current object. Inherited from Object. |
Export |
Exports the specified range to the specified stream in HTML format. |
Export |
Exports the specified worksheet to the specified stream in HTML format. |
Export |
Exports the document’s data to the specified stream in HTML format using the specified options. |
Export |
Exports the specified worksheet to the specified stream in HTML format. |
Export |
Exports the specified range to the specified file in HTML format. |
Export |
Exports the specified worksheet to the specified file in HTML format. |
Export |
Exports the document’s data to the specified file in HTML format using the specified options. |
Export |
Exports the specified worksheet to the specified file in HTML format. |
Export |
Exports the content of the Spreadsheet |
Export |
Exports the content of the Spreadsheet |
Export |
Exports the content of the Spreadsheet |
Export |
Exports the content of the Spreadsheet |
Find |
Retrieves the form that the control is on. Inherited from Control. |
Focus() | Sets input focus to the control. Inherited from Control. |
From |
Retrieves the control that contains the specified handle. Inherited from Control. |
From |
Returns the control that is currently associated with the specified handle. Inherited from Control. |
Get |
Retrieves a value indicating how a control will behave when its Auto |
Get |
Obtains the coordinates and size of a cell specified by the row and column indices. |
Get |
Gets a worksheet cell located at the specified point. |
Get |
Retrieves the child control that is located at the specified coordinates, specifying whether to ignore child controls of a certain type. Inherited from Control. |
Get |
Retrieves the child control that is located at the specified coordinates. Inherited from Control. |
Get |
Returns the next Container |
Get |
Serves as the default hash function. Inherited from Object. |
Get |
Retrieves the current lifetime service object that controls the lifetime policy for this instance.
Inherited from Marshal |
Get |
Retrieves the next control forward or back in the tab order of child controls. Inherited from Control. |
Get |
Retrieves the size of a rectangular area into which a control can be fitted. Inherited from Control. |
Get |
Retrieves the bounds within which the control is scaled. Inherited from Control. |
Get |
Returns cell ranges currently selected in the active worksheet. |
Get |
Returns shapes currently selected in the active worksheet. |
Get |
Gets the service object of the specified type. |
Get |
Gets the specified service. |
Get |
Retrieves the value of the specified control style bit for the control. Inherited from Control. |
Get |
Determines if the control is a top-level control. Inherited from Control. |
Get |
Gets the Type of the current instance. Inherited from Object. |
Hide() | Conceals the control from the user. Inherited from Control. |
Initialize |
Obtains a lifetime service object to control the lifetime policy for this instance.
Inherited from Marshal |
Init |
Called after the control has been added to another container. Inherited from Control. |
Invalidate() | Invalidates the entire surface of the control and causes the control to be redrawn. Inherited from Control. |
Invalidate |
Invalidates a specific region of the control and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. Inherited from Control. |
Invalidate |
Invalidates the specified region of the control (adds it to the control’s update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. Inherited from Control. |
Invalidate |
Invalidates the specified region of the control (adds it to the control’s update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Inherited from Control. |
Invalidate |
Invalidates the specified region of the control (adds it to the control’s update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Optionally, invalidates the child controls assigned to the control. Inherited from Control. |
Invalidate |
Invalidates the specified region of the control (adds it to the control’s update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. Inherited from Control. |
Invoke |
Executes the specified delegate, on the thread that owns the control’s underlying window handle, with the specified list of arguments. Inherited from Control. |
Invoke |
Executes the specified delegate on the thread that owns the control’s underlying window handle. Inherited from Control. |
Invoke |
Raises the Got |
Invoke |
Raises the Lost |
Invoke |
Raises the Click event for the specified control. Inherited from Control. |
Invoke |
Raises the Paint event for the specified control. Inherited from Control. |
Invoke |
Raises the Paint event for the specified control.
Inherited from Control. |
Is |
Determines if a character is an input character that the control recognizes. Inherited from Control. |
Is |
Determines whether the CAPS LOCK, NUM LOCK, or SCROLL LOCK key is in effect. Inherited from Control. |
Is |
Determines if the specified character is the mnemonic character assigned to the control in the specified string. Inherited from Control. |
Load |
Invokes the Open dialog, creates a specific importer and loads the file. |
Load |
Loads a document from a byte array. |
Load |
Load the document from a Byte[] array. |
Load |
Loads a document from a stream, specifying the document format. |
Load |
Loads the document from a stream. |
Load |
Loads a document from a file, specifying the document format. |
Load |
Loads a document from a file. |
Load |
Invokes the Open file dialog as a child of the specified parent window. |
Memberwise |
Creates a shallow copy of the current Object. Inherited from Object. |
Memberwise |
Creates a shallow copy of the current Marshal |
Notify |
Raises the Invalidated event with a specified region of the control to invalidate. Inherited from Control. |
On |
Raises the Auto |
On |
Raises the Back |
On |
Raises the Background |
On |
Raises the Background |
On |
Raises the Binding |
On |
Raises the Causes |
On |
Raises the Change |
On |
Raises the Click event. Inherited from Control. |
On |
Raises the Client |
On |
Raises the Context |
On |
Raises the Context |
On |
Raises the Control |
On |
Raises the Control |
On |
Raises the Create |
On |
Raises the Cursor |
On |
Raises the Dock |
On |
Raises the Double |
On |
Raises the Enter event. Inherited from Control. |
On |
Raises the Font |
On |
Raises the Fore |
On |
Raises the Help |
On |
Raises the Ime |
On |
Raises the Invalidated event. Inherited from Control. |
On |
Raises the Layout event. Inherited from Control. |
On |
Raises the Leave event. Inherited from Control. |
On |
Raises the Location |
On |
Raises the Margin |
On |
Raises the Mouse |
On |
Raises the Mouse |
On |
Raises the Mouse |
On |
Raises the Mouse |
On |
Raises the Mouse |
On |
Raises the Move event. Inherited from Control. |
On |
Notifies the control of Windows messages. Inherited from Control. |
On |
Raises the Padding |
On |
Raises the Back |
On |
Raises the Background |
On |
Raises the Binding |
On |
Raises the Parent |
On |
Raises the Cursor |
On |
Raises the Enabled |
On |
Raises the Font |
On |
Raises the Fore |
On |
Raises the Right |
On |
Raises the Visible |
On |
Raises the Preview |
On |
Raises the Paint event. Inherited from Control. |
On |
Raises the Region |
On |
Raises the Right |
On |
Raises the Style |
On |
Raises the System |
On |
Raises the Tab |
On |
Raises the Tab |
On |
Raises the Text |
On |
Raises the Validated event. Inherited from Control. |
On |
Raises the Validating event. Inherited from Control. |
On |
Raises the Visible |
Open |
Invokes a cell editor and switches to the spreadsheet edit mode, allowing you to edit cell content. |
Perform |
Forces the control to apply layout logic to all its child controls. Inherited from Control. |
Perform |
Forces the control to apply layout logic to all its child controls. Inherited from Control. |
Point |
Computes the location of the specified screen point into client coordinates. Inherited from Control. |
Point |
Computes the location of the specified client point into screen coordinates. Inherited from Control. |
Pre |
Preprocesses keyboard or input messages within the message loop before they are dispatched. Inherited from Control. |
Pre |
Preprocesses keyboard or input messages within the message loop before they are dispatched. Inherited from Control. |
Print() | Prints the document to the default printer. |
Print |
Prints the document using the specified printer settings. |
Process |
Processes a command key. Inherited from Control. |
Process |
Processes a dialog key. Inherited from Control. |
Process |
Processes a key message and generates the appropriate control events. Inherited from Control. |
Process |
Processes a keyboard message. Inherited from Control. |
Process |
Previews a keyboard message. Inherited from Control. |
Process |
Processes a mnemonic character. Inherited from Control. |
Raise |
Raises the appropriate drag event. Inherited from Control. |
Raise |
Raises the appropriate key event. Inherited from Control. |
Raise |
Raises the appropriate mouse event. Inherited from Control. |
Raise |
Raises the appropriate paint event. Inherited from Control. |
Recreate |
Forces the re-creation of the handle for the control. Inherited from Control. |
Rectangle |
Computes the size and location of the specified screen rectangle in client coordinates. Inherited from Control. |
Rectangle |
Computes the size and location of the specified client rectangle in screen coordinates. Inherited from Control. |
Reference |
Determines whether the specified Object instances are the same instance. Inherited from Object. |
Reflect |
Reflects the specified message to the control that is bound to the specified handle. Inherited from Control. |
Refresh() | Forces the control to invalidate its client area and immediately redraw itself and any child controls. Inherited from Control. |
Remove |
Removes the service of the specified type from the service container. |
Remove |
Removes the service of the specified type from the service container. |
Remove |
Removes a command shortcut. |
Replace |
Allows you to replace the specified service. |
Reset |
Resets the Back |
Reset |
Causes a control bound to the Binding |
Reset |
Resets the Cursor property to its default value. Inherited from Control. |
Reset |
Resets the Font property to its default value. Inherited from Control. |
Reset |
Resets the Fore |
Reset |
Resets the Ime |
Reset |
Updates the layout of the document loaded into control and the control itself. |
Reset |
Resets the control to handle the Mouse |
Reset |
Resets the Right |
Reset |
Resets the Text property to its default value (Empty). Inherited from Control. |
Resume |
Resumes usual layout logic. Inherited from Control. |
Resume |
Resumes usual layout logic, optionally forcing an immediate layout of pending layout requests. Inherited from Control. |
Rtl |
Converts the specified Content |
Rtl |
Converts the specified Horizontal |
Rtl |
Converts the specified Left |
Rtl |
Converts the specified Content |
Rtl |
Converts the specified Horizontal |
Rtl |
Converts the specified Left |
Save |
Saves a document in its original format to its original location. |
Save |
Saves a document to an array of bytes in the specified format and with specified encryption settings. |
Save |
Saves a document to an array of bytes in the specified format. |
Save |
Saves the workbook to a stream, specifying the export format and encryption options. |
Save |
Saves the workbook to a stream, specifying the export format. |
Save |
Saves the control’s document to a file, specifying the document format and encryption settings. |
Save |
Saves the control’s document to a file, specifying the document format. |
Save |
Saves the document to a file with the specified encryption settings. |
Save |
Saves the document to the specified file in the Excel or text format. The file format is identified by the file extension. |
Save |
Saves a document in its original format to its original location. If original format and location are not specified, invokes the Save As dialog that is shown modally as a child of the specified parent window. |
Save |
Invokes the Save As dialog and saves a document. |
Save |
Invokes the Save As dialog which is shown modally as a child of the specified parent window. |
Scale |
Scales the control and all child controls by the specified scaling factor. Inherited from Control. |
Scale |
Scales the entire control and any child controls. Inherited from Control. |
Scale |
Scales the control and any child controls. Inherited from Control. |
Scale |
Scales a control’s location, size, padding and margin. Inherited from Control. |
Scale |
This method is not relevant for this class. Inherited from Control. |
Select() | Activates the control. Inherited from Control. |
Select |
Activates a child control. Optionally specifies the direction in the tab order to select the control from. Inherited from Control. |
Select |
Activates the next control. Inherited from Control. |
Send |
Sends the control to the back of the z-order. Inherited from Control. |
Set |
Sets a value indicating how a control will behave when its Auto |
Set |
Sets the specified bounds of the control to the specified location and size. Inherited from Control. |
Set |
Sets the bounds of the control to the specified location and size. Inherited from Control. |
Set |
Performs the work of setting the specified bounds of this control. Inherited from Control. |
Set |
Sets the size of the client area of the control. Inherited from Control. |
Set |
Selects cell ranges in the worksheet and specifies whether the selection expands to fit merged cells. |
Set |
Sets cell ranges selected in the active worksheet. |
Set |
Sets shapes selected in the active worksheet. |
Set |
Sets a specified Controltrue or false .
Inherited from Control. |
Set |
Sets the control as the top-level control. Inherited from Control. |
Set |
Sets the control to the specified visible state. Inherited from Control. |
Show() | Displays the control to the user. Inherited from Control. |
Show |
Invokes the Print dialog to select a printer, specify the print options (number of copies, page range, and paper source) and print the document. |
Show |
Invokes the Print Preview window with a Bar UI. |
Show |
Invokes the Print Preview window with a Ribbon UI. |
Size |
Determines the size of the entire control from the height and width of its client area. Inherited from Control. |
Suspend |
Temporarily suspends the layout logic for the control. Inherited from Control. |
IDrop |
Raises the Drag |
IDrop |
Raises the Drag |
IDrop |
Raises the Drag |
IDrop |
Raises the Drag |
To |
Returns a String containing the name of the Component, if any. This method should not be overridden. Inherited from Component. |
Update() | Causes the control to redraw the invalidated regions within its client area. Inherited from Control. |
Update |
Updates the bounds of the control with the current size and location. Inherited from Control. |
Update |
Updates the bounds of the control with the specified size, location, and client size. Inherited from Control. |
Update |
Updates the bounds of the control with the specified size and location. Inherited from Control. |
Update |
Refreshes the Spreadsheet |
Update |
Forces the assigned styles to be reapplied to the control. Inherited from Control. |
Update |
Updates the control in its parent’s z-order. Inherited from Control. |
See Also