SpreadsheetGear.dll contains the SpreadsheetGear namespace which provides a high performance spreadsheet class library, as well as the SpreadsheetGear.Windows.Forms namespace which includes a Windows Forms Spreadsheet Control, Formula Bar Control, Workbook Designer, Workbook Explorer and Range Explorer.
Namespaces
| Namespace | Description |
|---|---|
| SpreadsheetGear | The SpreadsheetGear namespace consists primarily of interfaces and enumerations which provide access to the SpreadsheetGear for .NET spreadsheet model. |
| SpreadsheetGear.Advanced.Cells | The SpreadsheetGear.Advanced.Cells namespace provides a high performance API for getting and setting the values and formulas of cells. |
| SpreadsheetGear.CustomFunctions | The SpreadsheetGear.CustomFunctions namespace provides an API for defining custom functions which may be added to a workbook set. |
| SpreadsheetGear.Data | The SpreadsheetGear.Data namespace consists of SpreadsheetGear for .NET items which pertain to the System.Data namespace. |
| SpreadsheetGear.Shapes | The SpreadsheetGear.Shapes namespace provides an API for manipulating shapes which are owned by a sheet. |
| SpreadsheetGear.Windows.Forms | The SpreadsheetGear.Windows.Forms namespace includes the WorkbookView Windows Forms Control as well as the Workbook Designer, Workbook Explorer and Range Explorer. |
Remarks
See the Introduction for a brief overview of SpreadsheetGear for .NET 2007.
For the latest FAQ's, how-to's, documentation, samples, support options and new versions please visit www.spreadsheetgear.com.
The SpreadsheetGear for .NET API is familiar to developers with experience using Microsoft Excel(TM) VBA or COM. In many cases, the SpreadsheetGear for .NET API is close enough to the Excel API that you can record a macro in Excel to learn which properties or methods to use in SpreadsheetGear for .NET.
Major differences between SpreadsheetGear for .NET and Excel include:
- In most cases, SpreadsheetGear for .NET uses interfaces rather than classes. Use SpreadsheetGear.IWorkbook instead of Microsoft.Office.Interop.Excel.Workbook.
-
SpreadsheetGear for .NET integer indexes for workbooks, worksheets, rows, columns, etc... are zero based while Excel indexes are generally one based.
-
Many formatting properties (such as IRange.Font.Color) in Excel return System.Object. This is done so that null may be returned if all of the represented cells and objects do not have the same value for the particular property. Unfortunately, this bypasses type safety at compile time and causes unnecessary complexity for the vast majority of use cases. SpreadsheetGear for .NET improves on this by returning the appropriate type (such as System.Drawing.Color), and providing a separate boolean property (such as IRange.Font.ColorDefined) which specifies whether all represented cells/objects have the same value for the property in question.
-
Enumerations leave out XL on enumeration type names and the leading xl on enumeration identifiers. Use SpreadsheetGear.SheetType.Worksheet instead of Microsoft.Office.Interop.Excel.XLSheetType.xlWorksheet.
-
Use SpreadsheetGear.IWorkbookSet in the place of Microsoft.Office.Interop.Excel.Application.
-
Since the SpreadsheetGear namespace does not have any notion of a window, properties which are set via Excel's Window object must be handled differently than they are in Excel. The SpreadsheetGear.IWorkbookWindowInfo and SpreadsheetGear.IWorksheetWindowInfo interfaces provide access to these properties.
-
When using the SpreadsheetGear for .NET Windows Forms Controls with interruptible background calculation enabled, GetLock and ReleaseLock must be used. See the Introduction for more information.
- When the SpreadsheetGear for .NET Help is installed, Visual Studio's IntelliSense and Dynamic Help provide context sensitive help which simplifies development.