Aspose.Cells for .Net 4.4.0.0

Aspose.Cells delivers real Excel spreadsheets in a desktop or web server environment Aspose.Cells will deliver Excel spreadsheets in a desktop or web server environment without Microsoft Excel installed on either server or users PC.
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 developers to manipulate contents, format cells and protect files.
Main features:
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 Workbooks 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
System requirements:
- .NET Framework version 1.0 or higher