Aspose.Cells 7.4.3

Aspose.Cells for .NET is a spreadsheet programming component that allows software developers to manipulate and convert spreadsheet files from within their own applications. A combination of APIs and GUI controls, Aspose.Cells for .NET speeds up Microsoft Excel programming and conversion.

There is a newer version of this package available.
See the version list below for details.
Install-Package Aspose.Cells -Version 7.4.3
dotnet add package Aspose.Cells --version 7.4.3
<PackageReference Include="Aspose.Cells" Version="7.4.3" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Aspose.Cells --version 7.4.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Release Notes

New Features
41589 - Add new overload: AutoFitColumns(int firstRow, int firstColumn, int lastRow, int lastColumn, AutoFitterOptions options)
41553 - Copy a cell over a range of cells

Enhancements
41520 - Smart Marker Grouping
41514 - Copy ListObjects/Tables in copying range.
41506 – Saving Workbook to CSV is not keeping columns for each row

Performance
41527 - System.OutOfMemoryException on loading the workbook

Exceptions
41477 - Mono problem – Unknown Heap Type: SmartAssembly
41554 - NullReferenceException calling DeleteRow (external data connections)
41552 - Worksheets.GetNamedRanges causes NullReferenceException
41534 - Exception: “Object reference not set to an instance of an object” - while saving the Excel file
41538 - "Invalid chart MarkerStyle string val" while opening a template file
41606 - "Invalid FontUnderlineType value" while saving an Excel file

Bugs
41566 - Rendering PDF from Excel ignores Alpha
41511 - Print area header and footer does not appear when converting Excel to PDF
41498 - Graphic not exported properly
41582 - Excel Sparklines don't get saved in the rendered image
41576 - Image Contrast not preserved when rendering image from Excel
41541 - Some text/data is wrongly shared at the top
41560 - Incorrect calculation of GETPIVOTDATA in Aspose.Cells 7.4.2.x
41551 - Problem with XLSX to HTML conversion
41515 - Problem with XLSX to HTML conversion II
41496 - Problem with truncated cell text in the XLSX to HTML conversion
41578 - Cells next to Pivot table are populated with Pivot table’s values
41569 - Changing Pivot table’s data source will cause problems
41561 - Set Table as Pivot Table's data source problem
41556 - Issue with Pivot ranges
41509 - Pivot table’s formatting problem
41581 - Calculated values are not accepted by Pivot table's RefreshData() method
41580 - Error found when saving an Excel file
41563 - Excel to Html problem - the cell's characters are over wrapped
41540 - Pivot table borders are wrongly visible in the PDF
41453 - Pivot chart in the generated PDF is not the same as Pivot chart in the generated XLSX file
41489 - Data series Line styles’ cap Type property is reset to default
41530 - Data labels appear outside of the chart area
41478 - Changing the position of data labels is not working
41548 - Issue with a custom font color of the legend entry for a particular series
41597 - Hidden columns extracted as string data table have incorrect and empty values
41590 - Conditional formatting issue
41575 - After saving the file with Aspose.Cells, the last two columns move to the next page break
41562 - CalculateFormula is not working right
41550 - Copying a range of columns that are grouped, the grouping options/attributes are not copied
41547 - Values are hidden after saving an XLS file
41523 - Background of Ole Objects is changed to blue after double-conversion (XLS->XLSM->XLS)
41516 - Aspose.Cells does not update formulas properly when deleting rows
41513 - Excel formula optimizations in XLSX and XLS break formula calculations
41529 - Incorrect formula after deleting row when referencing a ListObject Header
41521 - ActiveX controls do not get copied when using Workbook.Copy(source)
41517 - Cell.HtmlString - Font size in the Cell is not correct
41594 - The generated XLSX's sorting does not work the same way as per MS Excel
41588 - RAND() and RANDBETWEEN() are not working

Dependencies

This package has no dependencies.

NuGet packages (21)

Showing the top 5 NuGet packages that depend on Aspose.Cells:

Package Downloads
Zny.Common.Document
文档操作库
OBeautifulCode.Excel.AsposeCells
Enables Excel automation using the Aspose.Cells library.
Aspose.Total
Aspose.Total for .NET is the most complete package of all .NET file format APIs offered by Aspose. It empowers developers to create, edit, render, print and convert between a wide range of popular document formats within any .NET, C#, ASP.NET and VB.NET applications.
ExcelEngine
Excel导入类库
Ser.Engine
Package Description

GitHub repositories (3)

Showing the top 3 popular GitHub repositories that depend on Aspose.Cells:

Repository Stars
aspose-words/Aspose.Words-for-.NET
Aspose.Words for .NET examples, plugins and showcases
loamen/Kalman.Studio
Kalman.Studio代码生成器是一款基于T4模板引擎的代码生成器和开发辅助工具。可以根据数据库元数据架构信息来生成代码,还可以解析PowerDesigner物理模型文件,根据PDM模型对象来生成代码等。
aspose-cells/Aspose.Cells-for-.NET
Aspose.Cells for .NET examples, plugins and showcases

Version History

Version Downloads Last updated
20.10.0 2,199 10/16/2020
20.9.0 13,089 9/10/2020
20.8.0 15,564 8/13/2020
20.7.0 28,674 7/15/2020
20.6.0 76,107 6/12/2020
20.5.0 9,774 5/21/2020
20.4.0 52,268 4/16/2020
20.3.0 40,702 3/19/2020
20.2.0 34,112 2/20/2020
20.1.0 58,077 1/16/2020
19.12.0 47,333 12/17/2019
19.11.0 64,098 11/15/2019
19.10.0 63,989 10/18/2019
19.9.0 72,025 9/18/2019
19.8.0 56,940 8/20/2019
19.7.0 97,196 7/18/2019
19.6.0 40,746 6/20/2019
19.5.0 36,016 5/16/2019
19.4.0 81,225 4/17/2019
19.3.0 40,275 3/15/2019
19.2.0 75,604 2/18/2019
19.1.0 66,416 1/17/2019
18.12.0 57,891 12/19/2018
18.11.0 52,809 11/19/2018
18.10.0 69,360 10/18/2018
18.9.0 24,174 9/17/2018
18.8.0 53,877 8/15/2018
18.7.0 41,201 7/12/2018
18.6.0 90,903 6/19/2018
18.5.1 26,294 5/23/2018
18.5.0 6,018 5/17/2018
18.4.0 45,133 4/19/2018
18.3.0 31,009 3/16/2018
18.2.0 14,976 2/7/2018
18.1.0 36,869 1/18/2018
17.12.0 28,357 12/15/2017
17.11.1 11,050 11/20/2017
17.10.0 34,563 10/18/2017
17.9.0 23,686 9/19/2017
17.8.0 35,389 8/15/2017
17.7.0 29,937 7/18/2017
17.6.0 16,468 6/15/2017
17.5.0 14,193 5/16/2017
17.4.0 25,494 4/20/2017
17.3.0 20,541 3/16/2017
17.2.0 13,368 2/16/2017
17.1.0 28,618 1/12/2017
16.12.0 32,886 12/13/2016
16.11.0 31,281 11/11/2016
16.10.0 32,683 10/12/2016
9.0.0 18,025 9/13/2016
8.9.2 47,521 8/19/2016
8.9.1 1,624 8/12/2016
8.9.0 38,190 7/18/2016
8.8.3 8,808 6/28/2016
8.8.2 16,796 6/3/2016
8.8.1 3,563 5/23/2016
8.8.0 55,777 4/21/2016
8.7.2 31,562 3/25/2016
8.7.1 42,814 2/24/2016
8.7.0 13,130 1/26/2016
8.6.3 17,956 12/23/2015
8.6.2 26,204 11/20/2015
8.6.1 18,639 10/23/2015
8.6.0 26,753 9/21/2015
8.5.2 7,509 8/17/2015
8.5.1 22,416 7/16/2015
8.5.0 6,976 6/19/2015
8.4.2 14,558 5/19/2015
8.4.1 8,158 4/15/2015
8.4.0 21,411 3/12/2015
8.3.2.1 21,126 2/4/2015
8.3.2 6,168 1/23/2015
8.3.1 10,854 12/10/2014
8.3.0 3,811 11/14/2014
8.2.2 23,436 10/16/2014
8.2.1 32,819 9/17/2014
8.2.0 9,672 8/15/2014
8.1.2 4,971 7/23/2014
8.1.1 13,033 6/27/2014
8.1.0 6,524 6/6/2014
8.0.2 7,860 5/14/2014
8.0.1 5,619 4/21/2014
8.0.0 5,130 3/26/2014
7.7.2 37,301 2/17/2014
7.7.1 17,896 1/15/2014
7.7.0 7,393 12/16/2013
7.6.1 44,444 11/18/2013
7.6.0 10,969 10/17/2013
7.5.3 5,931 9/10/2013
7.5.2 3,465 8/14/2013
7.5.1 4,076 7/18/2013
7.5.0 7,575 6/10/2013
7.4.3 16,200 4/29/2013
7.4.2 4,642 4/1/2013
7.4.1 4,302 3/4/2013
7.4.0 5,116 1/28/2013
7.3.5 3,076 12/31/2012
7.3.4 5,808 11/30/2012
7.3.3 3,423 10/30/2012
7.3.2 19,868 9/28/2012
7.3.1 4,172 8/27/2012
7.3.0 3,984 7/17/2012
7.2.2 2,251 6/18/2012
7.2.1 1,879 5/21/2012
7.2.0 9,200 4/16/2012
7.1.2 2,411 3/19/2012
7.1.1.1 3,318 2/16/2012
7.1.1 1,761 2/14/2012
7.1.0 3,957 1/24/2012
Show less