SpreadsheetGear - performance spreadsheet components
| | | |
Products
Samples
Downloads
Support
Company
Excel to DataGrid Samples
Quickly move data from DataGrids to Excel and back without Excel
DataGrid Samples DataGrids, DataSets and DataTables are a staple of many Microsoft .NET Framework applications. SpreadsheetGear 2009 makes it easy to copy data from workbooks and ranges of cells to DataGrids, DataSets and DataTables. Copying the DataGrids, DataSets and DataTables back to a workbook or range of cells is just as easy.
  
Excel to DataGrid
This sample shows how to retrieve data from a Microsoft Excel workbook and display it in an ASP.NET DataGrid control.
[Run Sample] | [C# Source] | [VB.NET Source] | [XLS]
  
Excel to Multiple DataGrids
This sample shows how to retrieve data from multiple worksheets in a Microsoft Excel workbook and display it in multiple ASP.NET DataGrid controls.
[Run Sample] | [C# Source] | [VB.NET Source] | [XLS]
  
DataTable to Excel Workbook with Formats and Formulas
This sample shows how to insert data from a DataTable into an Excel workbook, merging the data with formatting and formulas. The results are displayed in an ASP.NET DataGrid control.
[Run Sample] | [C# Source] | [VB.NET Source] | [Template] | [XML]
  
Excel Workbook Consolidation
This sample shows how to utilize the IRange.Copy method to dynamically copy and consolidate data from multiple workbooks.
[Run Sample] | [C# Source] | [VB.NET Source]
  
Excel to Custom DataTable
This sample shows how to utilize advanced APIs to dynamically build a custom DataTable from a worksheet range while ignoring hidden rows.
[Run Sample] | [C# Source] | [VB.NET Source] | [XLS]
SpreadsheetGear 2009
Now Available
NEW!  93 Analysis Toolpak functions, enhanced printing support, CSV and text files, auto fill, goal seeking, data series, bubble charts, chart axis titles, gradients, rotated text and more.  Download the Licensed version or the FREE Evaluation Now.
Microsoft Chooses
SpreadsheetGear for .NET
"After carefully evaluating SpreadsheetGear, Excel Services, and other 3rd party options, we ultimately chose SpreadsheetGear for .NET because it is the best fit for MSN Money."

Chris Donohue
Program Manager
MSN Money
Spreadsheet Component
Industry Veterans
"Our key developers have over fifty years of combined experience developing high performance commercially available spreadsheet technology which is used by most of the Fortune 500."

Joe Erickson
Founder and CEO
SpreadsheetGear LLC
I'm Impressed With the
Ease of Use and Speed
"I'm impressed with the ease of use and speed of SpreadsheetGear for .NET in rendering large workbooks from a web page. Congrats for your work!"

José M. Marcenaro
Tercer Planeta
Buenos Aires, Argentina
SpreadsheetGear Joins
Microsoft VSIP Program
August 23, 2005 - "We welcome SpreadsheetGear to the Microsoft Visual Studio Industry Partner Program. The improved ability to create, modify, calculate, read and write Microsoft Excel (versions 97 and higher) workbooks will allow our mutual customers to create a broad range of solutions in a rich and familiar form."

Nick Abbott
Group Manager
.NET Developer Product Marketing Group
Microsoft Corp.

Microsoft VSIP Program
ASP.NET and
SpreadsheetGear
A Match Made in Heaven
"ASP.NET and Microsoft Excel is a dangerous combination. ASP.NET and SpreadsheetGear is a match made in heaven. When you need your web or Windows app to interact with Excel files with lightening speed and no COM crashes, SpreadsheetGear for .NET is what you use. This product truly separates the men from the boys in the spreadsheet control marketplace."

Robbe Morris
Microsoft MVP - C#
Co-founder of EggHeadCafe.com and former Gartner Sr. Software Engineer
Brilliant Product
Fanatical Support
“Thank you again for your brilliant product and fanatical support. We have never looked back since we discarded FarPoint’s Spread in favour of SpreadsheetGear."

Earl J. Steyn
Data Prime Solutions
Johannesburg, South Africa
SpreadsheetGear Kills
The Competition
"I must say that in terms of structure and completeness, SpreadsheetGear kills the competition."

Mark Keogh, Technical Lead
BCC AdSystems
Sydney, Australia
Vision and Ability for Advanced Spreadsheets
September 20, 2005 - "With SpreadsheetGear, we finally have a company that understands our requirements in regards to supporting the Microsoft Excel file format in the Microsoft .NET Framework. SpreadsheetGear has the vision and the ability to provide the advanced spreadsheet functionality our customers expect in our products."

Tim Tow
President
Applied OLAP, Inc.
Former Microsoft Excel MVP
The Daily Grind Reviews SpreadsheetGear for .NET
September 22, 2005 - "The license allows royalty free deployment, making this a cost effective alternative to Excel as well as a technically superior one for generating worksheets and performing heavy-duty calculations from your .NET applications."

Mike Gunderloy
Lead developer for Larkware
Author of numerous books and articles on programming.
Great Piece of Software
Solves Real Problems
"SpreadsheetGear for .NET is a great piece of software that has given me faith that there are still developers who write great code to solve real problems and are serious about supporting it."

Deane Barker
Blend Interactive
Sioux Falls, South Dakota
Copyright © 2003-2009 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear® is a registered trademark and Spreadsheet Gear is a trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel, Visual Studio and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.