• Overview

    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 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

    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

    Effect Screenshots

    • 01.png
    • 02.png
    • 03.png
    • 04.png
    • 05.png
    • 06.png
    • 07.png
    • 08.png