Spire.XLS for .NET

  • Overview
  • Features
  • Examples
  • Guideline
  • Support
  • What's New
  • Live Demo

Standalone .NET Excel
Development Master

Over 1,000,000 Developers Are Already Using Our Libraries
To Create Their Amazing Applications.

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

  • Export

  • Validate

  • Formula

  • Format

  • Chart

  • Pivot Table

  • Group

  • Merge

  • Highlight

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.

VERSION

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

OPERATION

Powerful Toolset, Multichannel Support

  • Import and Export data

  • Reports

  • Manage Comments

  • Work with Pivot table

  • Work with Excel Charts

  • Images and shapes

  • Find Replace Highlight

  • Manage Hyperlinks

  • Print

  • Header and Footer

  • Text and Image watermark

  • Conditional Formatting

  • Excel Formula

  • Set auto-filters & page breaks

  • Merge Split Cells and files

  • Protect, Encrypt, Decrypt

CONVERSION

Conversion File Documents with High Quality

  • TEXT

  • XPS

  • SVG

  • PDF

  • XML

  • Image

XLsx,XLSM,XLSB,ODS

  • CSV

  • HTML

  • UOS

  • PNG

  • BMP

  • JPEG

  • EMF

  • TIFF

  1. Chart

Excel

MAIN FUNCTION

100% Standalone, NET API - No Microsoft Office Automation

Spire.XLS for .NET is a 100% standalone Excel .NET API 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.

Powerful & High Quality Excel File Conversion

Spire.XLS for .NET supports converting files from Excel to PDF, Excel to HTML, HTML to Excel, Excel to CSV, Excel to Text, Excel to Image, Excel to XML, Excel to SVG, Excel to UOS, Excel to OFD, Excel to PostScript and Excel to XPS. And on the other hand, most of popular files can be transferred to Excel back.

Create Excel Report from Comprehensive Workbook Designer

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, digital signature, tracking changes, cell hide/unhide, worksheet lock/unlock.

Freely Operate worksheet

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.

Easily Manipulate cells & Excel Calculation Engine at run time

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/2013/2016/2019 Excel. Cell Styles are supported by this Excel .NET API, 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.

Chart, Data and other Elements

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

Pro Edition $999

Spire.XLS Pro Edition supports converting files from Excel to PDF, HTML, Excel to CSV, Excel to Text, Excel to Image and Excel to XML(the Excel can be either .XLS or .XLSX) and it is included in Spire.XLS Pack.


Standard Edition $799

Spire.XLS for .NET Standard Edition only can be used for .NET and doesn't support print and conversion function.

Standard Edition doesn't work on .NET Core.

Free Edition $0

Free version is limited to 5 sheets per workbook and 200 rows per sheet. It doesn't support the print function. When converting Excel files to other formats, such as you can only get the first 3 pages of PDF/XPS, and you can only convert first 3 sheets to Images.

GET STARTED

Free Trials for All Progress Solutions

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, .NET 5.0, .NET 6.0, .NET core, .NET Standard, MonoAndroid and Xamarin.iOS. 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, Excel 2016 and Excel 2019 (.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 Excel2016
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 Image CSV Text
Not supported in Standard Edition
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

Beginners Guide is the first step towards learning the basic information of Spire.XLS for .NET

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.

Main Functions contain the main features of our Spire.XLS for .NET and you can have brief information of it.

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 name: iceblue.support

Apply for a Free Trial License File.

To help you get started quickly, 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.

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.

Download Spire.XLS to start a free trial:

Hotfix Version: 14.3.3

Category ID Description
New feature SPIREXLS-765 Supports PivotTable grouping function.
XlsPivotTable pt = worksheet.PivotTables[0] as XlsPivotTable;
IPivotField field = pt.RowFields[0];
DateTime start = new DateTime(2024, 5, 6);
DateTime end = new DateTime(2024, 10, 6);
PivotGroupByTypes[] types = new PivotGroupByTypes[]{ PivotGroupByTypes.Days };
field.CreateGroup(start, end, types, 1);
New feature SPIREXLS-5091 Supports adding FindAll() method to CellRange.
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"test.xlsx");
Worksheet sheet = workbook.Worksheets[0];
sheet.Range["A1"].FindAll()
New feature SPIREXLS-5123 Supports setting "Repeat All Item Labels" for PivotTable.
foreach (XlsPivotTable pt in wb.Worksheets["PivotTable"].PivotTables)
 {
 pt.Options.RepeatAllItemLabels = true; 
 }
Bug SPIREXLS-5097 Fixes the issue that the content was incorrect after saving Excel files.
Bug SPIREXLS-5103 Fixes the issue that the sheet content exported using ExportDataTable was incorrect.
Bug SPIREXLS-5105 Fixes the issue that formula values were incorrect when converting Excel to PDF.
Bug SPIREXLS-5106 Fixes the issue that the program threw "Size of image is too large" exception when converting Excel to images.
Bug SPIREXLS-5110 Fixes the issue that the PivotTable column names were inconsistent when converting Excel to pictures.
Bug SPIREXLS-5122 Fixes the issue that there were some extra blank comments in result files after using CellRange.Comment.Text.
Bug SPIREXLS-5125 Fixes the issue that the styles were incorrect when converting Excel to PDF.
Bug SPIREXLS-5126 Fixes the issue that the program threw "ArgumentNullException" exception when loading files.
Bug SPIREXLS-5148 Fixed the issue that the program threw "NullReferenceException" exception when splitting a document.

Hotfix Version: 14.2.1

Category ID Description
New feature SPIREXLS-5038 Supports setting the clipping position of header and footer images.
sheet.PageSetup.LeftHeaderPictureCropTop=6.15;
sheet.PageSetup.LeftHeaderPictureCropBottom=7.15;
sheet.PageSetup.LeftHeaderPictureCropLeft =7.15;
sheet.PageSetup.LeftHeaderPictureCropRight = 6.15;
sheet.PageSetup.LeftFooterPictureCropTop=0.15;
sheet.PageSetup.LeftFooterPictureCropBottom=0.15;
sheet.PageSetup.LeftFooterPictureCropLeft =0.15;
sheet.PageSetup.LeftFooterPictureCropRight =0.15;

sheet.PageSetup.CenterHeaderPictureCropTop=0.15;
sheet,PageSetup.CenterHeaderPictureCropBottom=0.15;
sheet.PageSetup.CenterHeaderPictureCropLeft=0.15;
sheet.PageSetup.CenterHeaderPictureCropRight =0.15;
sheet.PageSetup.CenterFooterPictureCropTop=0.15;
sheet.PageSetup.CenterFooterPictureCropBottom=0.15;
sheet.PageSetup.CenterFooterPictureCropLeft =0.15;
sheet.PageSetup.CenterFooterPictureCropRight=0.15;

sheet.PageSetup.RightHeaderPictureCropTop=0.15;
sheet.PageSetup.RightHeaderPictureCropBottom=0.15;
sheet.PageSetup.RightHeaderPictureCropLeft=0.15;
sheet.PageSetup.RightHeaderPictureCropRight=0.15;
sheet.PageSetup.RightFooterPictureCropTop=0.15;
sheet.PageSetup.RightFooterPictureCropBottom=0.15;
sheet.PageSetup.RightFooterPictureCropLeft=0.15;
Bug SPIREXLS-5066 Fixes the issue that the comments in the resulting document were not displayed in Office365 after calling the cellRange.ClearContents() method.
Bug SPIREXLS-5073 Fixes the issue that when the sheet name contained the special character \t, the \t was read as x0009.
Bug SPIREXLS-5080 Fixes the issue that the content was incorrect when converting XLSX documents to PDF documents.
Bug SPIREXLS-5083 Fixes the issue that the application threw "System.ArgumentException" when converting XLSX documents to PDF documents
Bug SPIREXLS-5084 Fixes the issue that the text content was overlapped when converting XLSX documents to images.
Bug SPIREXLS-5090 Fixes the issue that the "Operation is not supported on this platform" exception occurred when deploying the .netstand2.0 dlls on the .NET7.0 platform.

Hotfix Version: 14.1

Category ID Description
New feature SPIREXLS-5036 Improves the memory usage of converting worksheets to images.
New feature SPIREXLS-5006 Adds XLT, XLTX, and XLTM formats to the FileFormat enumeration.
Bug SPIREXLS-5016 Fixed the issue that the program threw System.ArgumentOutOfRangeException when executing sheet.AutoFilters.Clear().
Bug SPIREXLS-5018 Fixed the issue that opening the saved XLSX document with MS Excel tool after loading an XLSX document without modifying it and saving it directly to a new XLSX document prompted an error in some of the contents.
Bug SPIREXLS-5022 Fixed the issue that some contents of the saved XLSX document prompted errors after inserting data into the worksheet and opening the saved XLSX document with MS Excel tool.
Bug SPIREXLS-5023 Fixed the issue that retrieving cells failed.
Bug SPIREXLS-5025 Fixed the issue that paging was incorrect after converting Excel to PDF.
Bug SPIREXLS-5028 Fixed the issue that the content was misplaced after converting Excel to CSV.
Bug SPIREXLS-5032 Fixed the issue that the text of legend was messy after converting Excel to HTML with .Net Standard package in Linux system.
Bug SPIREXLS-5034 Fixed the issue that the program threw "No printers are installed" error when loading files under Linux environment.
Bug SPIREXLS-5039 Fixed the issue that the pivot chart data was incorrect after converting worksheets to pictures.
Bug SPIREXLS-5061 Fixed the issue that the program threw "Shape failing to render!" error when converting Excel to PDF.

Hotfix Version: 13.11.4

Category ID Description
Bug SPIREXLS-4966 Fixed the issue that java.lang.NullPointerException exception was thrown when converting worksheets to HTML documents.
Bug SPIREXLS-4967 Fixed the issue that excessive "0" characters appeared in the text content when converting Excel documents to HTML documents.
Bug SPIREXLS-4968 Fixed the issue that cell content got lost when converting to PDF documents after setting adaptive row height for Excel cells.
Bug SPIREXLS-4970 Fixed the problem that content obtained from merged cells was incorrect.
Bug SPIREXLS-4975 Fixed the issue that the results returned by searching strings were incorrect.
Bug SPIREXLS-4977 Fixed the issue that chart reference was not correctly updated after copying worksheets.
Bug SPIREXLS-4990 Fixed the issue that the DisplayedText values obtained were incorrect.

Hotfix Version: 13.10.1

Category ID Description
New feature SPIREXLS-4907 Improves the efficiency of Excel to PDF conversion.
New feature SPIREXLS-4857 Supports customizing the names of pivot table fields.
sheet.PivotTables[0].RowFields[0].CustomName = "rowName";
sheet.PivotTables[0].ColumnFields[0].CustomName = "colName";
sheet.PivotTables[0].PivotFields[0].CustomName = "fieldName1";
sheet.PivotTables[0].DataFields[0].CustomName = "dataName";
Bug SPIREXLS-4883 Fixes the issue that the position of images changed after converting Excel to HTML.
Bug SPIREXLS-4897 Fixes the issue that deleted annotations were not successfully removed from the document.
Bug SPIREXLS-4909 Fixes the issue that the program threw System.OverflowException exception when reading Excel documents.

Hotfix Version: 13.9.1

Category ID Description
New feature SPIREXLS-4866 Supports saving shape to image.
Workbook workbook = new Workbook();
workbook.LoadFromFile(inputFile);
Worksheet sheet = workbook.Worksheets[0];
//convert shapes to images
SaveShapeTypeOption shapelist = new SaveShapeTypeOption();
//save the shapes in worksheet to images.
shapelist.SaveAll = true;
Dictionary images = sheet.SaveAndGetShapesToImage(shapelist);
foreach (KeyValuePair pair in images)
{
    IShape shape = pair.Key;
    Bitmap bitmap = pair.Value;
    bitmap.Save(outputFile+shape.Name + "_" + shape.Height + "_" + shape.Width +"_" + shape.ShapeType + ".png");
}
Bug SPIREXLS-4859 Fixes the issue that the data wrapping was incorrect after converting Excel file to CSV.
Bug SPIREXLS-4861 Fixes the issue that the returned result was incorrect after calling "IsPasswordProtected" method.
Bug SPIREXLS-4863 Fixes the issue that there was extra tables after converting Excel to image.
Bug SPIREXLS-4872 Fixes the issue that the application threw "System.Xml.XmlException" when converting Excel to PDF.
Bug SPIREXLS-4874 Optimizes the performance of creating a large Excel file.

Hotfix Version: 13.8.9

Category ID Description
New feature SPIREXLS-2146 Supports customizing the paper size without scaling the content during printing.
sheet.PageSetup.SetCustomPaperSize(224, (float)25.4);
sheet.PageSetup.Orientation = PageOrientationType.Portrait;
New feature SPIREXLS-4640 Supports adding Signature Line.
sheet.Range["A1"].AddSignatureLine("e-iceblue","E-iceblue","123@123.com", "description" ,false, true);
New feature SPIREXLS-4740 Supports getting shapes in sheets.
Spire.Xls.Core.IShapes shapes = sheet.Shapes;
Bug SPIREXLS-1782 Fixes the issue that the program threw an exception when creating HIPERVINCULO formulas in a Spanish environment.
Bug SPIREXLS-4824
SPIREXLS-4830
Fixes the issue that the program threw a "NullReferenceException" when loading an Excel document created by the new version of WPS.
Bug SPIREXLS-4842 Fixes the issue that the slicer was lost after saving Excel.
Bug SPIREXLS-4850 Fixes the issue that after splitting Excel documents, the generated file prompted the message that the content has error when opening in Microsoft Excel.
Bug SPIREXLS-4851 Fixes the issue that the program threw "NullReferenceException" when merging multiple Excel documents.
Bug SPIREXLS-4853 Fixes the issue that the program threw "NullReferenceException" when loading Excel documents.

Hotfix Version: 13.8.0

Category ID Description
New feature SPIREXLS-288 Supports setting paper size to DIN A0.
sheet.PageSetup.PaperSize = PaperSizeType.PaperA0;
New feature SPIREXLS-4725 Supports grayscale printing.
workbook.ConverterSetting.GrayLevelForPrint = true;
New feature SPIREXLS-4778 Optimized performance for converting xlsx to HTML with long processing time and high memory consumption.
Bug SPIREXLS-722 Fixes the issue that the charts were missing when converting Excel to images.
Bug SPIREXLS-4012 Fixes the issue that the content was incorrect when converting shapes to images.
Bug SPIREXLS-4749 Fixes the issue that the application threw System.Security.Cryptography.CryptographicException: "Invalid algorithm specified" when performing digital signature.
Bug SPIREXLS-4768 Fixes the issue that involved failed font replacement.
Bug SPIREXLS-4772 Fixes the issue that the style changed after modifying text in a shape.
Bug SPIREXLS-4773 Fixes the issue that the borders were changed after setting number formats for multiple cells.
Bug SPIREXLS-4785 Fixes the issue that the week calculation was incorrect when converting Excel to PDF.
Bug SPIREXLS-4787 Fixes the issue that the PrstGeomShapes collection was not updated after removing shapes.
Bug SPIREXLS-4788 Fixes the issue that there was an extra top border in the converted Excel to PDF.
Bug SPIREXLS-4793 Fixes the issue that the conditional formatting for cells failed to retrieve.
Bug SPIREXLS-4795 Fixes the issue that the content was inconsistent when converting Excel to PDF.

Hotfix Version: 13.7.0

Category ID Description
New feature SPIREXLS-4712 Supports NETWORKDAYS.INTL function.
Bug SPIREXLS-411 Fixed the issue that the added numbers were displayed as date format.
Bug SPIREXLS-698 Fixed the issue that the content was incorrect after converting a chart to an image.
Bug SPIREXLS-883 Fixed the issue that the top border of cells at page breaks was not printed.
Bug SPIREXLS-891 Fixed the issue that the program threw "ArgumentOutOfRangeException" exception when deleting shapes.
Bug SPIREXLS-1158 Fixed the issue that it didn't work when changing the font color of a specific row in a pivot table.
Bug SPIREXLS-2286 Fixed the issue that changing the font in a pivot table didn't work.
Bug SPIREXLS-4711 Fixed the issue that dashed lines missed after converting Excel to HTML.
Bug SPIREXLS-4722 Fixed the issue that the program threw "NullReferenceException" when executing the CalculateAllValue() method.
Bug SPIREXLS-4728 Fixed the issue that the filter button didn’t work after adding a filter to the merged cells.
Bug SPIREXLS-4738 Fixed the issue that the number of remaining rows was incorrect after deleting rows.
Bug SPIREXLS-4748 Fixed the issue that the format was incorrect when exporting data using worksheet.ExportDataTable() method.

Hotfix Version: 13.5.6

Category ID Description
New feature SPIREXLS-4560 Adds two methods to realize the movement of chartsheets and worksheets between positions.
workbook.Chartsheets[int index1].MoveSheet(int index2);
workbook.Chartsheets[int index1].MoveChartsheet(int index2)
New feature SPIREXLS-4684 Adds the method to optimize the speed of deleting rows.
Bug SPIREXLS-4587 Fixes the issue that the pivot table fields were displayed as "Column Labels" after converting a sheet to images.
Bug SPIREXLS-4605 Fixes the issue that the chart data was not refreshed when converting an XLSX document to PDF.
Bug SPIREXLS-4614 Fixes the issue that the setting on top function does not take effect when adding a text box.
Bug SPIREXLS-4643 Fixes the issue that the table styles were incorrect when converting an XLSX document to PDF.
Bug SPIREXLS-4644 Fixes the issue that the application threw” Syste.OverflowException” when loading an XLS document.
Bug SPIREXLS-4645 Fixes the issue that the data format of retrieved cells was incorrect.
Bug SPIREXLS-4646 Fixes the issue that the application threw "System.FormatException” when adding HTML content.
Bug SPIREXLS-4665 Fixes the issue that the chartsheets could not be obtained after calling the MoveWorksheet method twice.
Bug SPIREXLS-4666 Fixes the issue that the text exceeds the cell after setting AutoFitColumns when the cell contains Chinese characters.
Bug SPIREXLS-4673 Fixes the issue that the background colors were inconsistent when converting an XLSX document to HTML.
Bug SPIREXLS-4678 Fixes the issue that the program reported an error "This structured storage version is not supported." when loading an XLS document.
Bug SPIREXLS-4681 Fixes the issue that the style of an added HTML strong tag was not recognized.
Request free customized demo just for you.

Tab 1

Upload

Maximum file size: 1 MB. Files accepted: xls, xlsx, xlsb, ods.
Click here to browse files.
fileerrors

Convert to

Source file:
filename
Target file type:

Tab 2

Tab 3

Tab 4

Mathematic Functions:

Calculate symbol : Calculate Data:

Logic Function:

Calculate symbol : Calculate Data:

Simple Expression:

Calculate symbol : Calculate Data:

MID Functions:

Text : Start Number:
Number Charts:

Option:

Excel Version:
downloads

Tab 5

Data

fileerrors

Option

Excel Version:
downloads

If you don't find the function you want, please fill in a form to request a free demo from us. Make sure the demo you want meets the following requirements:

  • It is a small project that implements a particular scenario.
  • It relates to our libraries stored on E-iceblue online store.
  • It costs less than 2 hours for us to complete it.
  • It is not a bug report.
  • It is not a feature request.