Spire.Spreadsheet is a powerful component to view spreadsheet. As a standalone spreadsheet class library, Spire.Spreadsheet is a companion component to Spire.XLS, which mainly focus on how to display spreadsheet. It enables developers/programmers to directly read, write, edit and customize spreadsheet for their .NET applications.

Spire.Spreadsheet for .NET expresses scalability, time-saving and cost-effective to view and print excel spreadsheets. The main functions to operate the excel files, such as add filter, comments, naming ranges, group, formula and search features are all supported by Spire.Spreadsheet.
　

Main Functions

View and Print Excel document

Spire.Spreadsheet for .NET can help developers quickly open Excel 97-2003, Excel 2007, Excel 2010 and Excel 2013. By using Spire.Spreadsheet for .NET, developers can load Excel files from file, stream, and byte array, even it is encrypted excel files. Developers with Spire.Spreadsheet for .NET can view documents in reading or printing mode and display documents zoom in/out with 100%, 200%, and 400%.

Elements

Styles & Formats
Merge & Unmerge
Hyperlinks
Resize
Image
Freeze Panes

　

Features details

Search Text
Auto fit, auto size column and row
Grouping, sorting and filtering
Formula support, define new formula, calculate the value, save them in the excel file
Data Validation, Runtime validation
Comment, edit and show in smart tags identical to those found in Excel
Name range
Clipboard, cut, copy and paste, copy/paste with formular
Redo, undo,
Import Datatable