Emulates the Microsoft® Excel® look and feel and allows you to create, load, edit, save and print spreadsheet documents.
[ComVisible(false)] [ToolboxBitmap(typeof(SpreadsheetControl), "Bitmaps256.SpreadsheetControl.bmp")] [Docking(DockingBehavior.Ask)] public class SpreadsheetControl : Control, IEFDataSourceGlobalEventSubscriber, IGestureClient, ISupportLookAndFeel, IMouseWheelSupport, IMouseWheelScrollClient, IPrintable, IBasePrintable, IToolTipControlClient, ISpreadsheetDocumentServer, IBatchUpdateable, IServiceContainer, IServiceProvider, IDisposable, ISpreadsheetControl, ISpreadsheetComponent, ISupportsContentChanged, IWin32Window, ICommandAwareControl<SpreadsheetCommandId>, IInnerSpreadsheetControlOwner, IInnerSpreadsheetDocumentServerOwner, INotifyPropertyChanged
<ComVisible(False)> <ToolboxBitmap(GetType(SpreadsheetControl), "Bitmaps256.SpreadsheetControl.bmp")> <Docking(DockingBehavior.Ask)> Public Class SpreadsheetControl Inherits Control Implements IEFDataSourceGlobalEventSubscriber, IGestureClient, ISupportLookAndFeel, IMouseWheelSupport, IMouseWheelScrollClient, IPrintable, IBasePrintable, IToolTipControlClient, ISpreadsheetDocumentServer, IBatchUpdateable, IServiceContainer, IServiceProvider, IDisposable, ISpreadsheetControl, ISpreadsheetComponent, ISupportsContentChanged, IWin32Window, ICommandAwareControl(Of SpreadsheetCommandId), IInnerSpreadsheetControlOwner, IInnerSpreadsheetDocumentServerOwner, INotifyPropertyChanged
Related API Members
The following members accept/return SpreadsheetControl objects:
The SpreadsheetControl class specifies a visual control to create, load, modify, print, save and convert spreadsheet documents in different formats.
A document loaded into the SpreadsheetControl is a workbook that is specified by the IWorkbook interface and is accessible via the SpreadsheetControl.Document property. The IWorkbook interface provides a comprehensive set of properties and methods to manipulate worksheets, rows, columns and cells of the corresponding workbook. See the Examples section for details.
The SpreadsheetControl's automated formula calculation engine allows you to perform complex calculations using various functions and cell references and create shared and array formulas. You can also create your own custom functions to add to the built-in functions for use in formulas.
The SpreadsheetControl.Options property provides access to the SpreadsheetControlOptions object that stores settings specific to the SpreadsheetControl. Use the SpreadsheetControlOptions.Behavior property to access an object that enables you to apply restrictions to different spreadsheet operations (such as creating, loading, modifying and printing workbooks). The SpreadsheetControlOptions.Print options allow you to control how a printed document is generated and previewed. The SpreadsheetControlOptions.View options specify the display settings for the SpreadsheetControl.
The SpreadsheetControl implements a wide range of events that are raised when an end-user performs different operations in the control, custom draw events that allow you to customize document appearance, events to handle exceptions, etc. The Events document lists all available events.
For detailed information on the SpreadsheetControl user interface and built-in dialogs, refer to the Visual Elements section.