Aspose.Cells for .NET
Aspose.Cells is of the .NET components offered by Aspose for spreadsheet reporting in a desktop or web server environment without using Microsoft Excel. Main features include; Opening Excel files to and from Streams, Sending output to a client browser, Importing Images, Formulae and Charts, Import and Export of data from DataTable, DataView, DataGrid or an Array. Also supports Add-ins, VBA, Macros, CSV format, Conditional Formatting, AutoFit Rows & Columns, Create or Access Named Ranges etc. Document Features
- Open Plain or Encrypted Excel files of different format types (Excel97~Excel2003) from different sources
- Save Excel files in different formats types (Excel97~Excel2003)
- Open Excel files to Streams
- Sending output to the Client Browser
- Save Excel files from Streams
- Load and Save SpreadsheetML files
- Load and Save CSV files
- Load and Save Tab Delimited files
- Combine data of the two Workbooks
- Copy a whole Workbook's data
- Protect a whole Workbook
- Find and Replace data in a Workbook
- Set a default style to the whole Workbook
- Convert Excel file to PDF document
- Access and Modify the Document Properties of Excel files
- Preserve Pictures, Charts, Macros and PivotTables in a Template file
Worksheet Features – Management
- Add and Remove Worksheet
- Copy a Worksheet’s data
- Move a Worksheet to a specific location in the Workbook
- Set a specific Worksheet as an active sheet
- Clear or Remove all the Worksheets in a Workbook
Worksheet Features - Display Options
- Hide or Unhide a Worksheet
- Display or Hide Tabs, Scroll Bars, Gridlines & Row/Column Headers
- Preview Page Breaks
- Set Zoom Level for the Worksheet
- Make selected data remain visible while scrolling using Freeze Panes
- Unfreeze panes in the Worksheet
Worksheet Features - Protection Options
- Protect Contents, Objects and Scenarios of a Worksheet
- Unprotect a Worksheet
Worksheet - Page Setup Options
- Set Page Orientation, Scaling, Paper Size, Print Quality etc.
- Set Page Margins like Top, Left, Right, Bottom, etc.
- Set Headers and Footers
- Insert Graphics in Header and Footer
- Set Header and Footer Margins
- Set Print Area, Print Title etc.
- Page Breaks and Setting
- Insert Horizontal and Vertical Page Breaks at a specified cell
- Auto-Fit Pages Horizontally and Vertically
- Repeat Printing Title rows and columns on every page
Rows & Columns Features
- Adjust Row Height according to your desire
- Adjust Column Width as required
- Apply formatting to a whole row or column
- Auto-Fit Rows and Columns
- Insert or Delete Rows and Columns
- Hide or Unhide Rows and Columns
- Group or Ungroup Rows and Columns
- Copy Rows and Columns
Data Management Features
- Access any Cell in the worksheet
- Add data to desired Cells at runtime
- Import data into Worksheets from different data sources (DataView, DataTable, DataRow, DataReader, Array etc.)
- Retrieve data from cells according to their data types
- Export cells data to DataTable and Array
- Create and Insert Range of Cells
- Deleting Range of Cells
- Clearing Contents in the Range
- Find or Search specific data in Cells
- Set Formulae with Built-in or Add-in Functions
- Search Formula in the Cells
- Set Array and R1C1 reference style Formula
- Add different kinds of Hyperlinks to link data
- Create or Access Named Ranges
- Lock the Cells
- Apply Data Validation and Auto-Filtering
Formatting Features
- Apply different Styles on the Cells
- Copy Styles
- Apply Number Format Settings for the Cells
- Format Cell as a Date
- Custom Formatting of the Cells
- Custom Formatting of the Cells
- Set Text Alignment
- Set Text Rapped, Rotation and Direction in the Cells
- Shrink Text to fit in the Column
- Merge multiple Cells into single one
- Unmerge the Cells
- Apply different kinds of Font Settings for the Cells
- Apply different Colors to Cells, Fonts, Gridlines, Graphical Objects, etc.
- Set Rich Text in a Single Cell
- Apply different Border Settings on Cells
- Apply different Background Patterns on Cells
- Apply Format Settings on a Worksheet, Row or Column etc.
- Apply Conditional Formatting on Cells
Charting & Graphics Features
- Supports all Chart Types like Column, Bar, Line, Pie, Scatter, Area, Doughnut, Radar, Surface, Stock, Cylinder, Cone, Pyramid, etc.
- Create Different kinds of Charts easily
- Customize Charts by setting their different properties
- Set Data for the Charts dynamically
- Add Custom Charts to Worksheets using API
- Add Pictures to Worksheets at runtime
- Create Comments to cells
- Create CheckBoxes and TextBoxes
Advance Features
- Supports Designer Spreadsheets and Smart Markers
- Supports Formula Calculations using robust Formula Calculation Engine
- Supports accessing Aspose.Cells from COM Clients
- Create and Format Pivot Table
- Change Source Data of a Pivot Table at runtime
- Supports Add-Ins
- Supports VBA
- Supports Macros
Platforms Supported
- Windows Forms Support
- Web Forms Support
Click Here For More Information