Aspose.Cells for .NET 4.6.0.0

Aspose.Cells for .NET 4.6.0.0 is a powerful, useful .NET component . It is for spreadsheet reporting in a desktop or web server environment without using Microsoft Excel. Other useful features include encrypted Excel file creation, Import or export Excel 2007 data & formatting, open an excel file to and from streams, convert a chart into image and you can also convert an excel file to PDF.

It enables import and export of data from DataTable, DataView, DataGrid or an array and further supports CSV format, add-ins, VBA, macros, AutoFit rows & columns, NamedRanges, formula, conditional formatting & pivot table creation by API.

Major Features:

1. No Microsoft Excel Automation: Aspose.Cells is the most flexible component that allows developers to create and manage Excel Spreadsheets without requiring Microsoft Excel or Microsoft Office to be installed on the system. All Aspose components are totally independent and are not affiliated with, nor authorized, sponsored, or otherwise approved by Microsoft Corporation. In short, Aspose.Cells is a better alternative to automation in terms of security, stability, scalibility/speed, price and features.
   
2. Advanced Features: Unlike similar products from other vendors, Aspose.Cells not only supports spreadsheet generation and other basic file formatting features, but also supports a number of advanced features. These advanced features make it much more convenient for the developers to manipulate spreadsheet contents, cells formatting and files protection. Aspose.Cells supports features such as:
   
   • Saving and opening Excel files to and from streams
   • Sending output to a client browser
   • Importing and exporting data from a DataTable, DataView or Array
   • Importing images and charts
   • Creating images and charts through API
   • Importing formulae from a designer spreadsheet
   • Configuring page setup through API
   • The support of CSV format
   • Adding the copy of an existing worksheet (with full contents, images and charts etc.) to a file
   • Setting gradient background for charts through API
   • Creating comments
   • Auto-filters and page breaks through API
   • Setting complex formulae
   • Supporting conditional formatting
   • Supporting protection options introduced in Microsoft Excel XP
   • Manipulating named ranges
   • Locating APIs
   • Supporting custom chart API
   • Formula calculation engine etc.
3. Platform Independence: Aspose.Cells for .NET together with Aspose.Cells for Java cover most of the popular development environments and deployment platforms. You can confidently use Aspose.Cells for .NET to build any type of a 32-bit or 64-bit .NET application including ASP.NET, Web Services and WinForms. Aspose.Cells for .NET is easy to deploy because it is just a class library without any dependencies (except on the .NET Framework itself). It is also possible to use Aspose.Cells for .NET in pre- .NET technologies (like ASP) as a COM Wrapper. Aspose.Cells for Java is available for Java 1.4 or 1.5 and will run in any place where Java is installed. You can also use Aspose.Cells for Java with PHP.
4. Support for many Different File Formats: Using Aspose.Cells, developers can easily open and save a multitude of file formats. These include Excel 97 / 2000 / XP / 2007 (XLSX), SpreadSheetML, Tab Delimited and CSV documents. Using Aspose.Cells you can also open encrypted Excel files. It is even possible to convert Excel documents into PDF format by using another Aspose product (that is Aspose.Pdf) along with Aspose.Cells.