Assembly Overview

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.

NOTE: SpreadsheetGear for .NET 1.x does not include the SpreadsheetGear.Windows.Forms namespace.

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.

Remarks

See the Introduction for a brief overview of SpreadsheetGear for .NET.

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.

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.