SpreadsheetGear 2009 by SpreadsheetGear LLC

• Royalty free client and server deployment.
• Create, read, modify, view, edit, format, calculate, print and write Microsoft Excel 97-2003 (xls) and Excel 2007 Open XML (xlsx) workbooks without Excel.
• Scalable and reliable Excel Reporting.
• Powerful Windows Forms spreadsheet controls.
• Easily create images from Excel charts and ranges.
• Comprehensive charting APIs.
• Fastest and most complete Excel compatible calculation engine available (significantly faster than Excel).
• Read and write CSV and tab separated text files.
• Support for cell comments, pictures, text boxes, check boxes, drop-downs, list boxes, spinners, scrollbars, buttons, lines and many autoshapes.
• Drag Fill / Auto Fill including support for numbers, dates, times, month names, day names and certain text patterns.
• Fill Data Series support including automatic, chronological, linear, growth, day, weekday, month, year, start value, step value, stop value and the ability to use regression for linear or exponential trends.
• Fast single variable and single target goal seeking.
• Data validation including operators, alert messages, alert styles, custom formulas and drop-down lists.
• Conditional formats with support for simple comparison operators and custom formulas.
• Copy and insert DataTables into pre-formatted ranges with complete formula, border and format fixups.
• Easily convert entire workbooks or specific ranges to a DataSet or DataTable.
• Copy, transpose and consolidate across cells, worksheets, workbooks and workbook sets.
• Insert, delete and clear rows, columns and cells.
• Stable sort with an unlimited number of keys and the ability to sort text as numbers.
• Grouping and outlining of rows and columns.
• Supports 1,048,576 rows, 16,384 columns, 64K worksheets, unlimited workbooks and unlimited workbook sets.
• Copy, insert and move entire worksheets.
• C# and Visual Basic samples for ASP.NET and Windows Forms.
• Reads and writes VBA Macros.

Sample Solutions

Licensing

System Requirements