Spire.XLS for .NET
- Overview
- Features
- Examples
- Guideline
- Support
- What's New
- Live Demo
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
-
PNG
-
BMP
-
JPEG
-
EMF
-
TIFF
-
Chart
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.- Excel to HTML/XML/CSV
- XML/CSV to Excel
- Excel to Image
- Excel to Text
- Excel to PDF
- Excel to XPS
- Excel to SVG
Contents Features
Spire.XLS for .NET offers a wide range of features and the main features are listed as below:- Create and Edit Excel
- Find and Replace Data
- Print excel files
- Import/Export data from a DataTable, DataView, Array, DataGrid etc.
- Save Excel to file/Stream or as web response
- Create charts
- Read and write hyperlinks
- Create auto filters
- Implement Data Sorting
- Implement Data Validations
- Merge/Unmerge Cells and files
- Group/UnGroup Rows and Columns
- Insert/Delete or Hide Rows, Columns and Sheets
- Calculate Complex Excel Formula
- Freeze/Unfreeze Panes
- Insert Hyperlinks to link data
- Protect/Unprotect Worksheets
- Create Pivot Tables
- Encrypt/Decrypt Files
- Load/Save Excel VBA
- Merge data into Excel with MarkerDesigner
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 HTMLTutorials / Live Demo / Orginial Excel and HTML file Convert Excel to ImageTutorials / Orginial Excel and Image file Convert Excel to XPSTutorials / Orginial Excel and XPS fileExcel Chart
Excel ChartTutorials / Live Demo / C# CodeMarker Designer
Marker DesignerTutorials / Live Demo / C# CodeData Import/Export
Import Excel from DataTableTutorials / Live Demo / C# Code Export Excel to DataTableTutorials / Live Demo / C# CodeRuntime Excel Calculation
Runtime Excel CalculationTutorials / Live Demo / C# CodeCreate Excel Pivot Table
Create Excel Pivot TableTutorials / Live Demo / C# Code
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. |
|||||||||||
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. |
|||||||||||
- 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
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.
Hotfix Version: 14.7.2
Category | ID | Description |
New feature | SPIREXLS-5274 | Supports obtaining custom properties of worksheets.
Workbook workbook = new Workbook (); workbook.LoadFromFile("funds-test.xlsx"); ICustomPropertiesCollection customProperties = workbook.Worksheets[0].CustomProperties; for (int i = 0; i < customProperties.Count; i++) { XlsCustomProperty xcp = customProperties[i]; string name = xcp.Name; string value = xcp.Value; } |
New feature | SPIREXLS-5306 | Supports obtaining the original document name of the embedded OLE object.
ole.OleOriginName |
Bug | SPIREXLS-5271 | Fixes the issue that the cell data was inaccurate when converting Excel to images. |
Bug | SPIREXLS-5298 | Fixes the issue that the cell contents were lost when converting Excel to PDF. |
Bug | SPIREXLS-5304 | Fixes the issue that the row height was incorrect when converting Excel to PDF. |
Bug | SPIREXLS-5309 | Fixes the issue that the pagination was incorrect when converting Excel to PDF. |
Bug | SPIREXLS-5320 | Fixes the issue that the first 10 data entries were incorrect after adding a "FilterTop10" filter in a worksheet. |
Hotfix Version: 14.6.6
Category | ID | Description |
New feature | - | Supports converting Excel to Markdown format.
Workbook workbook = new Workbook(); workbook.LoadFromFile("input.xlsx"); workbook.SaveToFile("output.md",FileFormat.Markdown); |
Bug | SPIREXLS-5191 | Fixes the issue that the application threw "ArgumentOutOfRangeException" when setting "horizontal" and "vertical" type borders. |
Bug | SPIREXLS-5243 | Fixes the issue that the effect was incorrect when calling "Worksheet.Activate()" method. |
Bug | SPIREXLS-5262 | Fixes the issue that the text content layout was incorrect when converting Excel to image. |
Bug | SPIREXLS-5265 | Fixes the issue that the comment order in Excel was incorrect after sorting. |
Bug | SPIREXLS-5269 | Fixes the issue that the font effect was incorrect when converting Excel to Html. |
Bug | SPIREXLS-5272 | Fixes the issue that an error prompt appeared when opening the result document after adding a filter to an Excel PivotTable. |
Bug | SPIREXLS-5273 | Fixes the issue that the cell color was lost when converting Excel to Html. |
Bug | SPIREXLS-5283 | Fixes the issue that the cell icons were lost when converting Excel to Html. |
Bug | SPIREXLS-5217 | Fixed the issue that the "Worksheet.SetLastRow()" method did not take effect. |
Hotfix Version: 14.5.3
Category | ID | Description |
New feature | SPIREXLS-5128 | Supports adding images to the first page header and footer.
//Load image System.Drawing.Image bufferedImage = System.Drawing.Image.FromFile(inputFile_Img); //Set image on first page header and footer wb.Worksheets[0].PageSetup.FirstLeftHeaderImage = bufferedImage; wb.Worksheets[0].PageSetup.FirstLeftFooterImage = bufferedImage; wb.Worksheets[1].PageSetup.FirstCenterHeaderImage = bufferedImage; wb.Worksheets[1].PageSetup.FirstCenterFooterImage = bufferedImage; wb.Worksheets[2].PageSetup.FirstRightHeaderImage = bufferedImage; wb.Worksheets[2].PageSetup.FirstRightFooterImage = bufferedImage; |
New feature | SPIREXLS-5195 | Supports obtaining active selection range.
Worksheet worksheet = workbook.Worksheets[0]; string Information = null; foreach (CellRange range in worksheet.ActiveSelectionRange) { Information += "RangeAddressLocal:"+ range.RangeAddressLocal+"\r "; Information += "ColumnCount:" + range.ColumnCount + "\r "; Information += "ColumnWidth:" + range.ColumnWidth + "\r "; Information += "Column:" + range.Column + "\r "; Information += "RowCount:" + range.RowCount+ "\r "; Information += "RowHeight:" + range.RowHeight + "\r "; Information += "Row:" + range.Row + "\r "; } File.WriteAllText(outputFile_TXT,Information); |
New feature | SPIREXLS-5200 | Supports finding cells based on regular expressions.
CellRange[] ranges = sheet.FindAllString(".*test.", false, false, true); |
Bug | SPIREXLS-5075 | Fixes the issue that the image was lost after converting Excel to image. |
Bug | SPIREXLS-5151 | Fixes the issue that the content in the generated PDF document was lost after converting Excel to PDF on the Kirin system. |
Bug | SPIREXLS-5186 | Fixes the issue that the application threw the "System.NullPointerException" when converting sheet to image. |
Bug | SPIREXLS-5197 | Fixes the issue that the border obtained from merged area was incorrect. |
Bug | SPIREXLS-5198 | Fixes the issue that the text and alternative text obtained from checkboxes were incorrect. |
Bug | SPIREXLS-5214 | Fixes the issue that it failed to set the active cell using the SetActiveCell() method. |
Bug | SPIREXLS-5216 | Fixes the issue that the textboxes added to charts were not displayed. |
Bug | SPIREXLS-5218 | Fixes the issue that the name obtained from checkbox was incorrect. |
Bug | SPIREXLS-5225 | Fixes the issue that the mouse cursor position was incorrect after importing data into Excel using the InsertDataTable() method. |
Bug | SPIREXLS-5228 | Fixes the issue that some graphics and lines were lost after converting Excel document to PDF document. |
Bug | SPIREXLS-5234 | Fixes the issue that it failed to autofit columns using the AutoFitCoumns() method. |
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 |
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. |
Request free customized demo just for you. |
Tab 1
Upload
Convert to
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: |
Tab 5
Data
Option
Excel Version: |
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.