|
Aspose.Cells for .NET V4.5.1
A Spreadsheet Control/Component for .Net, ASP.Net
Aspose.Cells is one of the .NET components offered by Aspose for spreadsheet reporting in a desktop or web server environment without using Microsoft Excel. Main features include; Conditional formatting and Pivot table creation by API. Opening Excel files to and from Streams, 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, AutoFit Rows & Columns, Create or Access Named Ranges etc.
For more information about this product please visit the
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
Licensing
http://www.aspose.com/Wiki/default.aspx/Aspose.Corporate/LicensingAndSalesQuestions.html
Technical Information
Component Type - Contains the following types of components...
|
