Spire.Spreadsheet for is a standalone software library that allows .NET developers to integrate Excel spreadsheet viewing, editing, and printing capabilities directly into their applications. It supports a wide range of Excel file formats (Excel 97-2003, 2007, 2010, 2013), including encrypted files, and provides comprehensive functions such as formatting, filtering, commenting, grouping, formulas, and data validation. The library is designed to be scalable, cost-effective, and easy to use, making it suitable for a variety of business and development needs.

Key Features

View and Print Excel Documents Provides robust support for displaying and printing Excel files.

• Open Excel files from disk, stream, or byte array, including encrypted files
• Reading and printing modes with zoom options (100%, 200%, 400%)

Spreadsheet Editing and Customization Enables direct manipulation of spreadsheet content and structure.

• Format cells and content, add filters, group/ungroup, merge/unmerge cells
• Insert and edit formulas, define new formulas, and calculate values
• Add comments, hyperlinks, images, and resize elements

Advanced Data Operations Facilitates data management and reporting.

• Grouping, sorting, and filtering data
• Data validation and runtime validation
• Name ranges, clipboard operations (cut, copy, paste, including formulas)

Comprehensive Workbook Designer Supports report creation and workbook design tasks.

• Auto-fit and auto-size columns and rows
• Import data from DataTable
• Redo and undo actions

Additional Elements Enhances user experience and control.

• Freeze panes, search text, runtime validation, and smart tag comments

Benefits

Developer Productivity Accelerates integration of Excel functionality into .NET applications.

• Reduces development time with ready-to-use components
• Eliminates the need for Microsoft Office automation

Cost-Effectiveness Lowers total cost of ownership for spreadsheet features.

• No dependency on third-party office suites
• Standalone deployment and licensing

Scalability and Flexibility Adapts to diverse project requirements and file formats.

• Handles a wide range of Excel versions and file types
• Supports encrypted and large files efficiently