Description

Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, spreadsheet formatting, drawing objects like images, OLE objects and importing or creating charts. You can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, SpreadsheetML, PDF and all file formats from Excel 97 to Excel 2007.

Advanced Features

Unlike similar products from other vendors, Aspose.Cells for .NET 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 for .NET 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 formulae from a designer spreadsheet
- Configuring page setup through API
- Apply data validation and data sorting
- Freezing / unfreezing panes
- Importing images and charts
- Creating images and charts through API

Aspose.Cells for .NET also supports Addins, VBA and macros. Moreover, there are also a number of unique features that C#, VB.NET & ASP.NET Excel developers can only find in Aspose.Cells for .NET such as:

- The support of CSV, XLS, XLSX, PDF 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
- Creating List and Subtotals

Syntax Example

How to Create a PivotTable? Developers can add PivotTables to their spreadsheets using Aspose.Cells. [C#] //Instantiating a Workbook object Workbook workbook = new Workbook(); //Obtaining the reference of the newly added worksheet Worksheet sheet = workbook.Worksheets[0]; Cells cells = sheet.Cells; //Setting the value to the cells Cell cell = cells["A1"]; cell.PutValue("Sport"); cell = cells["B1"]; cell.PutValue("Quarter"); cell = cells["C1"]; cell.PutValue("Sales"); cell = cells["A2"]; cell.PutValue("Golf"); cell = cells["A3"]; cell.PutValue("Golf"); cell = cells["A4"]; cell.PutValue("Tennis"); cell = cells["A5"]; cell.PutValue("Tennis"); cell = cells["A6"]; cell.PutValue("Tennis"); cell = cells["A7"]; cell.PutValue("Tennis"); cell = cells["A8"]; cell.PutValue("Golf"); cell = cells["B2"]; cell.PutValue("Qtr3"); cell = cells["B3"]; cell.PutValue("Qtr4"); cell = cells["B4"]; cell.PutValue("Qtr3"); cell = cells["B5"]; cell.PutValue("Qtr4"); cell = cells["B6"]; cell.PutValue("Qtr3"); cell = cells["B7"]; cell.PutValue("Qtr4"); cell = cells["B8"]; cell.PutValue("Qtr3"); cell = cells["C2"]; cell.PutValue(1500); cell = cells["C3"]; cell.PutValue(2000); cell = cells["C4"]; cell.PutValue(600); cell = cells["C5"]; cell.PutValue(1500); cell = cells["C6"]; cell.PutValue(4070); cell = cells["C7"]; cell.PutValue(5000); cell = cells["C8"]; cell.PutValue(6430); Aspose.Cells.Pivot.PivotTableCollection pivotTables = sheet.PivotTables; //Adding a PivotTable to the worksheet int index = pivotTables.Add("=A1:C8", "E3", "PivotTable2"); //Accessing the instance of the newly added PivotTable Aspose.Cells.Pivot.PivotTable pivotTable = pivotTables[index]; //Unshowing grand totals for rows. pivotTable.RowGrand = false; //Draging the first field to the row area. pivotTable.AddFieldToArea(Aspose.Cells.Pivot.PivotFieldType.Row, 0); //Draging the second field to the column area. pivotTable.AddFieldToArea(Aspose.Cells.Pivot.PivotFieldType.Column, 1);

Screenshots

Reviews

Submit a review