Features

Aspose.Cells for .NET: Powering Your Spreadsheet Solutions

Aspose.Cells for .NET is a powerful spreadsheet processing API designed to help developers create, manipulate, and save spreadsheets from scratch or from existing files. This comprehensive library provides a set of features that enable you to work with Excel files (.xls, .xlsx, .xlsm) in your .NET applications.

Key Features

Spreadsheet Operations

  • Create and Manipulate Spreadsheets: Aspose.Cells for .NET allows you to create new spreadsheets, open existing ones, or modify existing files with ease.
  • Add, Modify, and Remove Worksheets: You can add, remove, or reorder worksheets within a spreadsheet as per your requirements.

Excel File Support

  • xlsx, xls, xlsm, csv, xml, HTML, PDF, and More: This API supports various file formats, including xlsx (Excel 2007-2019), xls (Excel 97-2003), xlsm (Excel Macro-enabled), CSV, XML, HTML, PDF, and others.

Spreadsheet Design

  • Add and Manage Workbook Structure: Aspose.Cells for .NET enables you to work with worksheets, rows, cells, data validation rules, formulas, macros, conditional formatting, charts, diagrams, pivot tables, and much more.
  • Format Pages, Rows, Columns, Cells, Fonts & Colors: You can customize the spreadsheet layout by modifying page setup, sheet columns, rows, borders, headers & footers, cell formats, fonts, colors, and more.

Charting, Drawing & Reporting

  • Manipulate Charts, Diagrams, Picturize-Elements: Aspose.Cells for .NET allows you to work with charts, diagrams, shapes, pictures, barcodes, buttons, forms, tables, pivot report filter page sets, conditional formatting rules, etc.
  • Generate Reports & Export Data in Various Formats: You can export data from Excel files or manipulate it directly within your reports in various formats such as HTML, XML, CSV, and PDF.

Conditional Formatting and Validation

  • Conditional Formatting Rules: Aspose.Cells for .NET offers an extensive feature set for conditionally formatting cells based on various criteria.
  • Add Data Validation Rules & AutoFormat Excel Range: This API enables you to add validation rules with options such as allowing input ranges, data types (number, text, etc.), and auto-formatting of excel ranges.

Reporting Engine

  • Supports Various Reporting Engines: Aspose.Cells for .NET supports several reporting engines, providing extensive support through its report writer functionality.

PDF Conversion & Protection

  • Export Workbook(s) to PDF: This API allows you to export Excel workbooks in PDF format with advanced formatting and protection features.
  • Protect Workbooks & Worksheets from Changes or Unauthorized Access: Aspose.Cells for .NET provides options for password-setting, encryption, permission controls, and sheet protection.

Security & Data Handling

  • Protection & Permissions Control: This API protects your files from unauthorized access and modifications using security protocols like AES Encryption.
  • Handling of Date, Number and text data: Aspose.Cells for .NET safely handles dates, numbers and text-based data throughout the file handling process.

By harnessing these features, you can simplify complex spreadsheet logic and provide rich Excel-like functionality inside your .NET applications.

 English