• Overview

    Spire.XLS for .NET is a professional Excel .NET component that can be used to any type of .NET 2.0, 3.5, 4.0 or 4.5 framework application, both ASP.NET web sites and Windows Forms 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 component 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 and Excel 2016 (.xlsx, .xlsb, .xlsm), along with Open Office(.ods) format. It features fast and reliably compared to 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.

    The Differences between Standard and Pro Edition lie in the feature of Excel Formula, Print function and File Conversion: Pro Edition supports converting files from Excel to PDF, Excel to HTML, Excel to CSV, Excel to Text, Excel to Image, Excel to XML(the Excel can be .xls, .xlsx and .xlsb), Excel to SVG and Excel to XPS;

    Unlike Pro Edition, the Standard Edition doesn't support print or conversion of any kind mentioned above.

    Spire.XLS Overview
    MainFunctions

    Main Functions

    100% Standalone .NET Component - No Microsoft Office Automation
    Spire.XLS for .NET is a 100% standalone Excel .NET component that allows developers to create, manage and manipulate Excel spreadsheets without requiring Microsoft Excel or Microsoft Office to be installed on the system. In addition, Spire.XLS for .NET is a better alternative to Office Automation in terms of security, stability, scalability, speed, price and features.
    Spire.XLS for .NET supports converting files from Excel to PDF, Excel to HTML, Excel to CSV, Excel to Text, Excel to Image, Excel to XML, Excel to SVG and Excel to XPS. And on the other hand, most of popular files can be transferred to Excel back.
    Spire.XLS for .NET enables developers to generate Excel workbook from scratch, or load a workbook from either folder or file stream. Developers can also save it to file, file stream or web response. Spire.XLS for .NET offers a wide range of security features including Excel encryption/decryption, cell hide/unhide, worksheet lock/unlock.
    Spire.XLS for .NET enables developers to create, add, delete, rename, edit and move worksheet in either C#, VB.NET or ASP.NET. Developers can also copy, transpose, and consolidate across worksheets with full contents. This professional Excel .NET class library also embeds many flexible options for displaying worksheets, such as page breaks, zoom-setting, freeze panes, headers/footers, Print excel files, print paper size and print area etc.
    Developers can easily manipulate Excel cells and Evaluate formula value in C#, VB.NET or ASP.NET at runtime. Super-fast, scalable excel calculation engine is compatible with the 97-2003/2007/2010 Excel. Cell Styles are supported by this Excel .NET component, such as cell merging/unmerging, text wrapping/unwrapping, text alignment, rotation, interior, borders, lock/unlock and etc. Font formats, like setting font type, size, color, bold, italic, strikeout and underlining etc. is also fully supported. Conditional formatting, text search and replace, filter and data validation can be applied to cells as easily as you expect.
    Spire.XLS for .NET provides a wide range of Chart: Pie Chart, Bar Chart, Column Chart, Line Chart, Radar Chart and etc. This Excel .NET component also supports data transportation between database and Excel in C# VB.NET or ASP.NET. Hyperlinks and templates are also supported by Spire.XLS for .NET.

    High Performance

    High performance for generating Excel documents with huge number columns and rows. Superior performance for reading and writing spreadsheet.

    Effect Screenshots

    • 01.png
    • 02.png
    • 03.png
    • 04.png
    • 05.png
    • 06.png
    • 07.png
    • 08.png
    • 09.png
    • 10.png
  • Features
    FeatureDetails

    Platforms

    Spire.XLS for .NET enables developers/programmers to build ASP.NET, Web Services, WinForms or any other type of application for any .NET Framework version from 2.0 to 4.5. Full support for 32-bit and 64-bit system.

    File Format Supports

    Spire.XLS for .NET supports lots of file formats.
    • 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 and Excel 2016 (.xlsx, .xlsb, .xlsm), along with Open Office(.ods) format.
    • Save as HTML is available.
    • Load and save documents in the tab delimited file format.
    • Comprehensive support of the CSV format to interact with a variety of applications.
    • Easily extract text by saving in plain text format.

    Conversion

    Spire.XLS for .NET has powerful conversion ability and it enables converting Excel files to most common and popular formats.

    Contents Features

    Spire.XLS for .NET offers a wide range of features and the main features are listed as below:

    Formatting Features

    Spire.XLS for .NET provides detailed programmatic access to formatting properties of all spreadsheet elements.
    • Apply all characters formatting in the cells including fonts, colors, effects, fill and shading.
    • Apply all the Number Format Settings (supported in MS Excel) for the cells.
    • Set all types of Text Alignment settings.
    • Apply different kinds of Font Settings for the cells.
    • Apply different Colors to Cells, Fonts, Gridlines, Graphic objects etc.
    • Apply different Rich Text formatting in a single cell.
    • Apply different Border Settings on cells.
    • Apply different Background Patterns on cells.
    • Apply gradient Background Patterns on cells.
    • Apply Format Settings on a Worksheet, Row, Column or a range of cells etc.

    Page Setup Features

    Spire.XLS for .NET enables developers/programmers to set PageSetup options.
    • Adjust your page orientation, scaling, paper size.
    • Specify your margins and page centering.
    • Create or edit your header and/or footer with image.
    • Set print area, print titles, or turn on gridlines etc
    • Managing Page Breaks

    Feature Details

    Support Excel97~2003 Excel2007 Excel2010 Excel2013
    Operation Create New Workbook Edit Existing Workbook
    Save to file Save to stream Save as web response
    Workbook Properties Setup Worksheet Print Setup
    Worksheet Copy Cells Data Copy Cells Styles Copy Cells Merge
    Lock Worksheet Unlock Worksheet
    Data Table Import Data Table Export
    Freezepane Group
    Filter Data Validation
    Marker Designer Template Auto Populate Style Copy Variables
    Format Cells Number Format Text Alignment Font
    Cell Border Cell Fill Cell Protection Interior
    Content Formula (all 531 entries supported) Chart (all 74 types supported)
    Image Pivot Table RichText
    Hyperlink Comments VBA
    Convert XML HTML Image CSV Text
    Not supported in Standard Edition
  • Demo
    Excel to PDF Excel to HTML Excel to Image Excel to XPS Excel Chart
    Marker Designer Data Import/Export Runtime Excel Calculation Excel Pivot Table
    Request free customized demo just for you.

    High Quality Conversion

    Convert Excel to PDFTutorials / Live Demo / Orginial Excel and PDF file

    Convert Excel to PDF

    Convert Excel to HTMLTutorials / Live Demo / Orginial Excel and HTML file

    Convert Excel to HTML

    Convert Excel to ImageTutorials / Orginial Excel and Image file

    Convert Excel to Image

    Convert Excel to XPSTutorials / Orginial Excel and XPS file

    Convert Excel to Image

    Excel Chart

    Excel ChartTutorials / Live Demo / C# Code

    Excel Chart

    Marker Designer

    Marker DesignerTutorials / Live Demo / C# Code

    Marker Designer

    Data Import/Export

    Import Excel from DataTableTutorials / Live Demo / C# Code

    Import Excel from DataTable

    Export Excel to DataTableTutorials / Live Demo / C# Code

    Export Excel to DataTable

    Runtime Excel Calculation

    Runtime Excel CalculationTutorials / Live Demo / C# Code

    Runtime Excel Calculation

    Create Excel Pivot Table

    Create Excel Pivot TableTutorials / Live Demo / C# Code

    Runtime Excel Calculation

  • Guideline
    Beginners Guide is the first step towards learning the basic information of Spire.XLS for .NET
    Main Functions contain the main features of our Spire.XLS for .NET and you can have brief information of it.
    Program Guide lists the detailed features of our Spire.XLS for .NET and you can search for the information you want.
    The Videos give an operation guide by video. You can check the produce step by step.
  • Support
    Frequently asked question for Spire.XLS of technical and function issues.
    We guarantee one business day Forum questions Reply.
    We guarantee one business day E-mail response.
    Free Customized service for OEM Users.
    Skype account: iceblue-support
    To ensure our products to be easier to use, we offer free customized demos to our customers. Please contact support@e-iceblue.com for the free demo. Make sure the demo you want meets the below requirements.
    • It relates to our components stored on E-iceblue online store.
    • It costs less than 2 hours for us to complete it. If it costs more than 2 hours, please contact our sales@e-iceblue.com
    If you have tried out Spire.XLS and found it useful, please consider sharing your experience with others. By sharing your testimonial with us, you will not only help others to make the right decision but will also to earn rewards from us. Please send your testimonials to sales@e-iceblue.com.
  • What's New

    This is the list of changelogs of Spire.XLS New release and hotfix. You can get the detail information of each version's new features and bug solutions.

    Welcome to experience Spire.XLS with downloading here:

    Hotfix Version:7.12.109

    New features:

    • Supports to manipulate more conditional formatting in XlsConditionalFormat and ConditionalFormatWrapper.
    • Adds ConditionalFormatWrapper.StopIfTrue property to stop processing the current rule when the condition meets.

    Bug Fixes:

    • Fixes the issue that caused the "object reference not set to an instance of an object" error when saving the Excel using custom OTF font to pdf.
    • Fixes the issue that caused incorrect number format when the thread culture is not invariant culture.
    • Fixes the issue that caused the Accounting number format pushed the $ symbol outside the cell border when converting to PDF.
    • Fixes the issue that change the PrimaryCategoryAxis.CategoryType property didn't work when loading an existing chart.
    • Fixes the issue that caused the ConditionalFormatWrapper.Priority property didn't work.
    • Fixes the issue that caused the AutoFitColumn method didn't work when the cell contains date time.

    Hotfix Version:7.12.100

    New Feature:

    • Adds TimePeriodType enum to specify the time period
    • Adds ConditionalFormatWrapper/XlsConditionalFormat.SetTimePeriod(TimePeriodType timePeriod) to format only cells with dates occurring in a specific time period.

    Bug solutions:

    • Fixes the issue where accounting Number Format didn't work correctly while saving Excel to PDF.
    • Fixes the issue that caused the invalid column index exception while saving Excel to PDF.
    • Resolves the issue where the comma that is not an actual field separator was considered as delimiter while saving Excel to CSV.
    • Fixes the issue that caused the back color of ConditionalsFormat incorrect.
    • Fixes the issue that caused the OverFlowException while loading an Excel file.

    Hotfix Version:7.12.90

    New Features:

    • Supports to add shapes to worksheet.
    • Supports to select the cell range to be visible when displayed as an OLE object.

    Bug Fixes:

    • Fixes the issue that the result document changed to Protected View after saving .xlsx to .xls.
    • Fixes the issue that caused ArgumentOutOfRangeException when converting Excel to HTML.
    • Fixes the issue that caused the style of the chart missing when using SaveChartAsImage method.
    • Fixes the issue that caused the font changed when converting Excel to PDF.
    • Fixes the issue that caused the data format incorrect when converting Excel to pdf.
    • Fixes the issue that caused the formula result wrong in French environment.
    • Fixes the issue that caused result incorrect when getting the validation formula value.
    • Resolves the issue that caused Euro (€) sign lost when using DisplayedText property.
    • Fixes the issue that the value in the original cell range changed along with value which was set by range.Text property in the copied range.
    • Fixes the issue that caused IndexOutOfRangeException when loading file.
    • Fixes the issue that caused the process hanging when converting Excel to PDF.
    • Fixes the issue that caused the value type changed from text to number when importing data from datatable to Excel.
    • Fixes the issue that the method AutoFitColumns didn't work.

    Hotfix Version:7.12.76

    New feature:

    • Spire.XLS supports to save file to Excel2016 format.

    Bug fixes:

    • Fixes the issue that caused XmlException when using CalculateAllValue() method.
    • Fixes the issue that caused wrong result of formulas while the computer sets the region as France and language as French.
    • Fixes the issue that caused warning message "We found a problem with some content in ... Do you want us to try recover as much as we can?" when opening the saved file.
    • Fixes the issue that caused wrong size of the image when scaling the inserted image.
    • Fixes the issue that caused FormatException when loading an .xlsm file.

    Hot Fix Version:7.12.69

    Bug fixes:

    • Fixes the issue that caused stretched image when converting Excel to PDF while the computer sets the region as Spain and language as Chile.
    • Fixes the issue that caused chart missing when converting Excel to PDF.
    • Fixes the issue that caused black background when saving Excel worksheet to pdf.
    • Fixes the issue that the setting "comment.AutoSize = true" doesn't work.
    • Fixes the issue that caused ArgumentException when loading .xlsm file.
    • Fixes the issue that caused slicer missing when saving .xlsm file.

    Hot Fix Version:7.12.55

    Bug fixes:

    • Fixes the issue that caused wrong pagination when converting Excel to PDF.
    • Fixes the issue that caused graph missing when converting Excel to PDF.
    • Fixes the issue that the images are rotated when converting Excel to PDF.
    • Fixes the issue where the position of the shapes are wrong when converting Excel to PDF.
    • Fixes the issue that caused XmlException when loading Excel file.

    Hot Fix Version:7.12.27

    New feature:

    • Add custom properties to Excel documents.

    Bug fixes:

    • Fixes the issue that caused XmlException when SaveAsImage method was invoked.
    • Fixes the issue that the data in the shape isn't updated after editing.
    • Fixes the issue that the result PDF converted from Excel prompts message "Cannot extract the embedded font 'FAACFG+ArialMT'. Some characters may not display or print correctly.".
    • Fixes the issue that caused ArgumentOutOfRangeException when loading files.

    Hot Fix Version:7.12.19

    Bug fixes:

    • Fixes the issue that caused NullReferenceException when using InsertRow method.
    • Fixes the issue that caused incorrect result when getting validation formula.
    • Fixes the issue that caused ArgumentOutOfRangeException when using CalculateAllValue mehtod.
    • Fixes the issue that caused wrong date format when getting the data.
    • Fixes the issue that caused icon missing when converting Excel to image.
    • Improves the conversion from Excel to PDF.

    Hot Fix Version:7.12.7

    Bug fixes:

    • Fixes the issue that the position of the datalabel cannot be changed.
    • Fixes the issue that caused the process hanging when using the GetSplitPageInfo method.
    • Fixes the issue that caused wrong value when copying range.
    • Fixes the issue that caused "spr2380 was unhandled" exception when using CalculateAllValue.
    • Improves the function of converting Excel to PDF.
    • Fixes the issue that caused exception when using multi-thread to load document.

    Version:7.12

    Bug fixes:

    • Reduce the PDF file size when converting Excel to PDF.
    • Fixes the issue where the cell with the formula did not autofit although wrap text is enabled when converting Excel to PDF.
    • Fixes the issue that caused the "Align with page margins" property in page setup unchecked when saving Excel file.
    • Fixes the issue that caused the unexpected spaces exception when loading Excel file.
    • Fixes the issue where the first inner group was not collapsed when setting "sheet.PageSetup.IsSummaryRowBelow" property as false.
    • Fixes the issue where the value of INameRange was get incorrectly.
    • Fixes the issue that caused the data lost when set ignoreSize argument exists in the sheet.Copy method as true.
    • Resolves the issue where the width of columns was changed when make an AutoFitColumn on columns with merge values.