Aspose.Cells is a .NET component 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, formulae, conditional formatting & pivot table creation by API.