Spire.Spreadsheet for .NET：Powerful .NET Library to View and Edit Spreadsheet from Code

Spire.Spreadsheet for .NET

 

Powerful .NET Library to View and Edit Spreadsheet from Code

 

Spire.Spreadsheet is a powerful library to view spreadsheet. As a standalone spreadsheet class library, Spire.Spreadsheet is a companion library 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 though 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

 

Create Excel Report from Comprehensive Workbook Designer

• 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