Excel Automation Samples

Automate Excel Report generation, populate DataGrids and perform high performance Excel

compatible calculations without Excel.


Excel Reporting
Easily create richly formatted Excel reports without Excel
Excel Reporting

With the wide adoption of Microsoft Excel in so many business settings, there is no

substitute for taking advantage of what spreadsheets have to offer.

With SpreadsheetGear for .NET, your Windows and ASP.NET applications instantly

 gain the ability to create, read, modify, calculate and write Excel workbooks.

With our extensive API, you can quickly deliver richly formatted interactive Excel reports

 which your users already know how to use.


Excel to DataGrid
Quickly populate DataGrids from Excel workbooks without Excel
Excel to DataGrid

Excel is an excellent source of data for the Windows Forms DataGrid

 and ASP.NET DataGrid controls included in Microsoft .NET, as well as the

many third party controls which accept data from DataSets and DataTables.

With our spreadsheet component and one line of Microsoft Visual C# or

Microsoft Visual Basic .NET code, you can quickly read an Excel workbook

and return any range or set of ranges as a DataTable or DataSet.


Excel Calculations
Fastest and most complete Excel compatible calculations without Excel
Excel Calculation

The true power of SpreadsheetGear for .NET is realized when using its superior

calculation engine. Unmatched performance and accuracy deliver a compelling

advantage to data critical client and web applications. There is no need to

rely on Excel to calculate spreadsheet data. Simply load or create a workbook, change

 and add values and formulas, and calculate results with the fastest and most

complete calculation engine available in a spreadsheet component.


Excel Charting
Enable users to visualize data by adding Excel charts to reports
Excel Charting

Richly formatted workbooks with fast and complete calculations are the heart and soul

 of a spreadsheet, but the ability to make good decisions is greatly enhanced by

the ability to visualize data. Enhance your users understanding of their data by

taking advantage of SpreadsheetGear for .NET's ability to read and write Excel charts

and modify the data which these charts refer to.

Comments

No comments posted yet.

Leave Your Comment

Title*
Name*
Email (never displayed)
 (will show your gravatar)
Url
Comment*

Please add 6 and 4 and type the answer here:

Preview Your Comment.