Spire.XLS for .NET is a professional Excel .NET API that can be used to create, read, write, convert and print Excel files in any type of .NET ( C#, VB.NET, ASP.NET, .NET Core, .NET 5.0, .NET 6.0, MonoAndroid and Xamarin.iOS) application. Spire.XLS for .NET offers object model Excel API for speeding up Excel programming in .NET platform - create new Excel documents from template, edit existing Excel documents and convert Excel files.

This Professional .NET Excel API is a standalone Excel .NET managed assembly and does not depend on Microsoft Office Excel. Spire.XLS for .NET offers support both for the old Excel 97-2003 format (.xls) and for the new Excel 2007, Excel 2010, Excel 2013, Excel 2016 and Excel 2019 (.xlsx, .xlsb, .xlsm), along with Open Office(.ods) format. It features fast and reliably compared with developing your own spreadsheet manipulation solution or using Microsoft Automation.

Spire.XLS for .NET enjoys good reputation in both enterprise and individual customers. These customer types include Banks, Data processing houses, Educational institutions, Government organizations, Insurance firms, Legal institutions, Postal/cargo services and etc.

• Convert Excel to PDF
  Whenever you need to share an important Excel report with a partner, it's best to convert the file to PDF to ensure it looks the same as it does on your device.
  
  
• Export Data from Database to Excel
  When data is exported from a database to Excel, it can be analyzed and visualized, as well as viewed and processed by users who are not database users.
  
  
• Apply Data Validation
  Data validation in Excel controls what kind of data can be entered into a certain cell, which ensures that all data entries are accurate and consistent.
  
  
• Insert Formulas and Functions
  Formula is an expression that calculates values in a cell or in a range of cells, while function is a predefined formula already available in Excel. Both formulas and functions are very useful when you need to calculate numbers or solve math problems in Excel.
  
  
• Apply Conditional Formatting
  Conditional formatting is a helpful feature that allows applying special formats to cells meeting specific criteria. It is often used to emphasize or differentiate data stored in worksheets.
  
  
• Create a Chart
  Chart is a fantastic tool to visually group and analyze data. It provides the reader with the structure of the data set and displays the data in a graphical representation, making it easier for most users to see the data.
  
  
• Create a Pivot Table
  Pivot table is a kind of interactive table that allow users to quickly categorize, calculate, summarize and analyze large amounts of data in a concise tabular format.
  
  
• Group Rows or Columns
  For worksheets with large amounts of data, grouping rows or columns that contain similar information can make the worksheet more compact and understandable.
  
  
• Merge Excel Files
  Merging Excel files with associated content can help us work with worksheet data more easily and also make it easier to share and read the contents of our workbooks.
  
  
• Find and Highlight
• You can find all cells containing a specific value and highlight them with the same background color to make the value outstanding and more easily to be found out.

.NET

Standalone .NET API

100% independent .NET Excel class library

which doesn't require Microsoft Office to be installed on system.

.NET Framework   |   .NET CORE   |   Microsoft Azure   |   Xamarin

VERSION

• Excel 97-2003
• Excel 2007
• Excel 2010
• Excel 2013
• Excel 2016
• Excel 2019
• OpenOffice