Features List

Benefits

• Accelerate application development
• Reduce project costs
• Shorten testing/retesting cycles
• Improve accuracy of business logic and calculations

General Features

• Read, write, and execute Excel 97+ spreadsheets without Microsoft Excel
• Supports Windows, Linux, and Sun Solaris platforms
• Provides small and easily understandable interfaces for COM, .NET and Java applications
• .NET edition is based on .NET Framework 2.0
• Integrates into Visual Studio .NET 2003 and Visual Studio 2005
• Provides XML access to Excel worksheets
• Supports Unicode
• Supports MTA (COM interface) and multithreaded applications (.NET and Java interface).¹⁾

Calculation Features:

• High performance spreadsheet calculation engine
• Supports 325 Excel formulas
• Supports all types, operators, arrays, defined names
• Edit formulas programmatically
• Automatically readjust formula references when insert/delete of cells/columns/rows/worksheets
• Goal seek

Reporting Features:

• Save Excel compatible files
• Insert/Delete Worksheets
• Insert/Delete Rows and Columns
• Insert/Delete Cells
• Apply styles on a range
• Apply number formats on a range
• Apply font on a range
• Apply borders on a range
• Apply patterns on a range
• Apply alignment on a range
• Text property

Pivot Table Features

• High performance Pivot Table (OLAP) engine
• Supports pivot filters
• Supports moving Data Pivot Field across Row and Column Fields
• Supports pivot formulas Average, Count, CountNums, Max, Min, Product, StDev, StDevp, Sum, Var, Varp

Charting Features

• High performance chart engine
• Supports most chart types in Excel
• Supports most chart properties in Excel

Other Features:

• XML input/output
• Database connectivity
  
• Easy configuration and use
  
• No conversion. Files remain in .XLS
  
• Scalable for server applications
  
• Visual Studio 2005 support

If you have any questions or are looking for featues not listed here, please contact us. You can email us at support@spreadsheetcomponent.com or call us +1 (860) 674-9100.

1) Only enterprise edition.