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