Excel in .NET with SpreadsheetGear 2017 for .NET 8.2.5.101: A Comprehensive Guide
SpreadsheetGear 2017 for .NET 8.2.5.101: A Powerful and Flexible Excel Solution for .NET Developers
Introduction
If you are a .NET developer who needs to work with Excel files, you might have encountered some challenges and limitations with the built-in or third-party libraries available. For example, you might have experienced performance issues, compatibility problems, memory leaks, or lack of features and functionality. You might have also wished for a more user-friendly and customizable way to display and interact with Excel data in your applications.
SpreadsheetGear 2017 for .NET 8.2.5.101
Fortunately, there is a solution that can address all these issues and more: SpreadsheetGear 2017 for .NET. This is a powerful and flexible Excel solution that enables you to easily take advantage of scalable Excel features and functionality in your ASP.NET, Windows Forms, WPF, or Silverlight applications.
What is SpreadsheetGear 2017 for .NET?
SpreadsheetGear 2017 for .NET is a family of products that consists of two main components: SpreadsheetGear Engine for .NET and Spreadsheet Controls.
SpreadsheetGear Engine for .NET is a high-performance spreadsheet component that provides a comprehensive API for working with Excel files programmatically. It supports reading, writing, modifying, calculating, formatting, printing, and exporting Excel files in various formats, such as XLSX, XLS, CSV, TXT, XML, HTML, PDF, and image formats. It also supports creating, editing, and manipulating charts, graphics, pivot tables, slicers, sparklines, tables, conditional formatting, data validation, comments, hyperlinks, outlines, protection, names, custom functions, and more.
Spreadsheet Controls are user interface components that allow you to display and interact with Excel data in your applications. They include Windows Forms Spreadsheet Control, WPF Spreadsheet Control, and Silverlight Spreadsheet Control. These controls provide rich functionality such as zooming, scrolling, selection, editing, copying, pasting, undoing, redoing, finding, replacing, filtering, sorting, grouping, freezing panes, splitting windows, customizing toolbars and menus, adding custom buttons and commands, handling events, validating input, displaying tooltips and status messages, printing and previewing worksheets and charts.
What are the benefits of using SpreadsheetGear 2017 for .NET?
By using SpreadsheetGear 2017 for .NET in your applications, you can enjoy the following benefits:
Performance: SpreadsheetGear 2017 for .NET is designed to handle large and complex Excel files with speed and efficiency. It uses optimized algorithms and data structures to minimize memory usage and CPU time. It also supports multithreaded recalculation to leverage the power of multicore processors.
Compatibility: SpreadsheetGear 2017 for .NET is compatible with various versions of Microsoft Excel (from Excel 97 to Excel 2019) and various platforms of .NET Framework (from .NET Framework 2.0 to .NET Framework 4.8). It also supports .NET Core 2.0 and higher, .NET Standard 2.0 and higher, and Xamarin.iOS and Xamarin.Android. It preserves the fidelity and functionality of Excel files across different formats and environments.
Flexibility: SpreadsheetGear 2017 for .NET gives you full control and customization over how you work with Excel data in your applications. You can use the SpreadsheetGear Engine for .NET API to manipulate Excel files programmatically, or use the Spreadsheet Controls to provide a rich and interactive user interface. You can also mix and match the two components to suit your needs. You can also extend the functionality of SpreadsheetGear 2017 for .NET by creating your own custom functions, commands, buttons, menus, toolbars, and event handlers.
Reliability: SpreadsheetGear 2017 for .NET is a mature and stable product that has been tested and proven in thousands of applications worldwide. It is backed by a team of experts who provide timely and professional support and maintenance. It also comes with a comprehensive documentation and a large collection of samples and demos to help you get started quickly and easily.
How to download and install SpreadsheetGear 2017 for .NET?
To download and install SpreadsheetGear 2017 for .NET, you need to follow these steps:
Visit the official website of SpreadsheetGear LLC and click on the Download button.
Fill out the registration form with your name, email address, company name, and country. You will receive an email with a link to download the installer.
Download the installer (SpreadsheetGear2017.msi) and run it on your computer. Follow the instructions on the screen to complete the installation process.
After the installation is finished, you can find the SpreadsheetGear 2017 for .NET components in your Visual Studio toolbox, as well as in the Start menu under SpreadsheetGear 2017.
You can also download the evaluation version of SpreadsheetGear 2017 for .NET, which is fully functional for 30 days. You can use it to test the features and capabilities of SpreadsheetGear 2017 for .NET before purchasing a license.
Features and Capabilities
In this section, we will explore some of the main features and capabilities of SpreadsheetGear 2017 for .NET in more detail.
Spreadsheet Engine
The Spreadsheet Engine is the core component of SpreadsheetGear 2017 for .NET that provides a comprehensive API for working with Excel files programmatically. It supports various operations such as workbook and worksheet operations, cell and range operations, formula calculation and evaluation, data import and export, and more.
Workbook and Worksheet Operations
The Spreadsheet Engine allows you to create, open, save, close, copy, move, rename, delete, protect, unprotect, encrypt, decrypt, and modify workbooks and worksheets programmatically. You can also access and manipulate various workbook and worksheet properties such as name, title, author, subject, keywords, comments, theme, color scheme, font scheme, style gallery, default styles, custom styles, page setup options, print options, view options, zoom level, gridlines, headers, footers, margins, orientation, paper size, scaling, and more.
You can also work with multiple workbooks and worksheets at the same time, and switch between them using the WorkbookSet and WorkbookView classes. You can also create and manage workbook and worksheet events using the IWorkbookSet and IWorksheetWindowInfo interfaces.
Cell and Range Operations
The Spreadsheet Engine allows you to access, modify, format, and manipulate cells and ranges programmatically. You can use the IWorkbook, IWorksheet, IRange, and ICell interfaces to perform various operations such as getting and setting cell values, formulas, formats, styles, borders, alignment, indentation, orientation, wrap text, merge cells, shrink to fit, number formats, font formats, fill formats, protection formats, conditional formats, data validation rules, comments, hyperlinks, pictures, sparklines, and more.
You can also use the IRange.Copy, IRange.Paste, IRange.Cut, IRange.Insert, IRange.Delete, IRange.Clear, IRange.Sort, IRange.Filter, IRange.Group, IRange.Ungroup, IRange.Subtotal, and IRange.RemoveSubtotal methods to perform various operations on ranges of cells. You can also use the IWorksheet.Cells, IWorksheet.Rows, IWorksheet.Columns, IWorksheet.UsedRange, and IWorksheet.CurrentRegion properties to access different parts of a worksheet.
Formula Calculation and Evaluation
The Spreadsheet Engine allows you to calculate and evaluate formulas programmatically. You can use the IWorkbook.CalculateFull(), IWorkbook.CalculateFullRebuild(), IWorkbook.Calculate(), and IWorkbook.CalculateFormula() methods to perform different types of calculations on workbooks. You can also use the IWorksheet.Calculate(), IWorksheet.CalculateRowMajorOrder(), and IWorksheet.CalculateFormula() methods to perform different types of calculations on worksheets. You can also use the IRange.Calculate() and IRange.CalculateFormula() methods to perform different types of calculations on ranges of cells.
The Spreadsheet Engine supports over 400 Excel-compatible functions, including financial, date and time, math and trigonometry, statistical, logical, text, lookup and reference, database, engineering, information, and user-defined functions. You can also create your own custom functions using the IWorkbook.AddCustomFunction() method and the ICustomFunction interface.
The Spreadsheet Engine also supports formula evaluation, which allows you to get the intermediate results of a formula calculation. You can use the IWorkbook.EvaluateFormula(), IWorksheet.EvaluateFormula(), and IRange.EvaluateFormula() methods to evaluate formulas at different levels. You can also use the IFormulaError interface to handle formula errors.
Data Import and Export
The Spreadsheet Engine allows you to import and export data from and to various sources and formats programmatically. You can use the IWorkbook.Open(), IWorkbook.Save(), IWorkbook.SaveAs(), and IWorkbook.SaveCopyAs() methods to read and write Excel files in various formats, such as XLSX, XLS, CSV, TXT, XML, HTML, PDF, and image formats. You can also use the IWorkbook.GetSaveAsImageOptions() method to customize the image options when saving Excel files as images.
You can also use the IRange.CopyFromDataTable(), IRange.CopyFromRecordset(), IRange.CopyToDataTable(), and IRange.CopyToRecordset() methods to import and export data from and to ADO.NET data tables and recordsets. You can also use the IRange.CopyFromArray() and IRange.CopyToArray() methods to import and export data from and to arrays of objects.
Spreadsheet Controls
The Spreadsheet Controls are user interface components that allow you to display and interact with Excel data in your applications. They include Windows Forms Spreadsheet Control, WPF Spreadsheet Control, and Silverlight Spreadsheet Control. These controls provide rich functionality such as zooming, scrolling, selection, editing, copying, pasting, undoing, redoing, finding, replacing, filtering, sorting, grouping, WorkbookView property that returns an instance of the SpreadsheetGear.Windows.Controls.WorkbookView class, which represents the user interface of the control. You can use the WorkbookView class to access and manipulate various aspects of the control, such as the workbook, worksheet, range, cell, formula bar, status bar, scroll bars, selection, zoom level, view mode, edit mode, copy mode, cut mode, paste options, undo manager, find options, replace options, print options, print preview options, and more.
You can also use the WorkbookView class to customize the appearance and behavior of the control, such as the colors, fonts, borders, cursors, tooltips, menus, toolbars, buttons, commands, events, and more. You can also use the SpreadsheetGear.Windows.Controls.CustomUI namespace to create your own custom user interface elements for the control.
Silverlight Spreadsheet Control
The Silverlight Spreadsheet Control is a control that allows you to embed Excel-like functionality in your Silverlight applications. It inherits from the System.Windows.Controls.Control class and implements the ISpreadsheetGearSilverlightControl interface. It provides a WorkbookView property that returns an instance of the SpreadsheetGear.Silverlight.WorkbookView class, which represents the user interface of the control. You can use the WorkbookView class to access and manipulate various aspects of the control, such as the workbook, worksheet, range, cell, formula bar, status bar, scroll bars, selection, zoom level, view mode, edit mode, copy mode, cut mode, paste options, undo manager, find options, replace options, print options, print preview options, and more.
You can also use the WorkbookView class to customize the appearance and behavior of the control, such as the colors, fonts, borders, cursors, tooltips, menus, toolbars, buttons, commands, events, and more. You can also use the SpreadsheetGear.Silverlight.CustomUI namespace to create your own custom user interface elements for the control.
Charting and Graphics
The Spreadsheet Engine and the Spreadsheet Controls also support creating, editing, and manipulating charts and graphics programmatically and interactively. You can use the IChart, IChartShape, IChartTitle, IChartLegend, IChartArea, IPlotArea, IAxis, IAxisTitle, IDataLabel, IDataLabels, IDataTable, ISeries, ISeriesCollection, IErrorBars, ITrendline, ITrendlines, IPoints, IPoint, and IChartFormat interfaces to access and manipulate various aspects of charts, such as the type, style, layout, data source, data range, data labels, data table, legend, title, axes, gridlines, tick marks, labels, scale, format, fill, line, marker, shadow, glow, and more. You can also use the IChartWindowInfo, IChartView, and IChartViewWindowInfo interfaces to access and manipulate various aspects of the chart user interface, such as the size, position, zoom level, scroll position, selection, copy mode, cut mode, paste options, undo manager, find options, replace options, print options, print preview options, and more. You can also use the IDrawingObject, IDrawingObjects, IDrawingObjectShape, IDrawingObjectPicture, IDrawingObjectGroup, and IDrawingObjectConnector interfaces to access and manipulate various types of drawing objects and shapes, such as rectangles, ovals, lines, arrows, stars, banners, callouts, text boxes, pictures, groups, and connectors. You can also use the IDrawingObjectFormat interface to access and manipulate various aspects of the drawing object and shape format, such as the type, style, layout, data source, data range, data labels, data table, legend, title, axes, gridlines, tick marks, labels, scale, format, fill, line, marker, shadow, glow, and more.
You can also use the IDrawingObjectWindowInfo, IDrawingObjectView, and IDrawingObjectViewWindowInfo interfaces to access and manipulate various aspects of the drawing object and shape user interface, such as the size, position, zoom level, scroll position, selection, copy mode, cut mode, paste options, undo manager, find options, replace options, print options, print preview options, and more.
Printing and Exporting Charts and Graphics
The Spreadsheet Engine and the Spreadsheet Controls also support printing and exporting charts and graphics programmatically and interactively. You can use the IWorkbook.Print(), IWorksheet.Print(), IRange.Print(), IChart.Print(), and IDrawingObject.Print() methods to print workbooks, worksheets, ranges, charts, and drawing objects respectively. You can also use the IWorkbook.GetPrintOptions(), IWorksheet.GetPrintOptions(), IRange.GetPrintOptions(), IChart.GetPrintOptions(), and IDrawingObject.GetPrintOptions() methods to customize the print options for each object.
You can also use the IWorkbook.SaveAsImage(), IWorksheet.SaveAsImage(), IRange.SaveAsImage(), IChart.SaveAsImage(), and IDrawingObject.SaveAsImage() methods to export workbooks, worksheets, ranges, charts, and drawing objects as images respectively. You can also use the IWorkbook.GetSaveAsImageOptions(), IWorksheet.GetSaveAsImageOptions(), IRange.GetSaveAsImageOptions(), IChart.GetSaveAsImageOptions(), and IDrawingObject.GetSaveAsImageOptions() methods to customize the image options for each object.
Licensing and Pricing
SpreadsheetGear 2017 for .NET is a commercial product that requires a license to use. In this section, we will discuss the licensing options and requirements, pricing plans and discounts, and support and maintenance for SpreadsheetGear 2017 for .NET.
Licensing Options and Requirements
SpreadsheetGear 2017 for .NET offers two types of licenses: Developer License and Server License.
A Developer License is required for each developer who uses SpreadsheetGear 2017 for .NET in their development environment. A Developer License allows the developer to use SpreadsheetGear 2017 for .NET on any number of computers, as long as they are the only user of those computers. A Developer License also allows the developer to distribute SpreadsheetGear 2017 for .NET with their applications, as long as they comply with the redistribution requirements.
A Server License is required for each server where SpreadsheetGear 2017 for .NET is deployed. A Server License allows SpreadsheetGear 2017 for .NET to be used on a single physical or virtual server, by any number of users or applications. A Server License also includes a Developer License, which means that the developer who installs SpreadsheetGear 2017 for .NET on the server can also use it in their development environment.
To use SpreadsheetGear 2017 for .NET, you need to activate your license using the License Manager. You can activate your license online or offline, depending on your preference and network availability. You can also deactivate your license and transfer it to another computer or server, as long as you comply with the license agreement.
Pricing Plans and Discounts
The pricing of SpreadsheetGear 2017 for .NET depends on the number and type of licenses you need. You can purchase licenses individually or in bundles, depending on your needs and budget. You can also take advantage