IronXL for .NET Excel 库更新日志

发布说明

• Fixed extremely slow style application on large spreadsheets (now 25-393x faster). Operations that previously took minutes on 500K+ cell ranges now complete in milliseconds.

发布说明

• 更新内部依赖项。

发布说明

• 更新内部依赖项。

发布说明

• 更新内部依赖项。

发布说明

• FixedInvalidCastExceptionwhen loading certain.xlsfiles containing Data Validation records.

发布说明

• 更新内部依赖项。

发布说明

• Fixed an issue where numeric cells were incorrectly detected as DateTime.
• 修复了将 XLSX 转换为 XLS 格式时数据类型损坏的问题。
• Fixed an issue where the AutoSizeColumn method overestimated the column width.

发布说明

• Updates IronSoftware.System.Drawing to 2025.9.3.

发布说明

• Updates IronSoftware.System.Drawing to 2025.8.1.

发布说明

• Updates IronSoftware.System.Drawing to 2025.7.12.

发布说明

更新：

• Updates IronSoftware.System.Drawing to 2025.6.2.

错误修复：

• Fixes an issue where the LastFilledCell property incorrectly returned null for worksheets with sparse data.
• Fixes an issue where CreateNamedTable corrupts Excel file when adding tables to different sheets.

发布说明

• Updates IronSoftware.System.Drawing to 2025.5.3.

• Updates IronSoftware.Common to 2025.3.1.

• Fixes an issue where Rows.Length returns an incorrect value when used with Excel files containing more than 500 rows.

发布说明

• Updates IronSoftware.System.Drawing to version 2025.3.6.
• Updates IronSoftware.Common to version 2025.3.1.

发布说明

• Updates IronSoftware.System.Drawing to version 2025.3.5.
• Updates IronSoftware.Common to version 2025.2.3.

发布说明

• Updated IronSoftware.System.Drawing to 2025.1.6.

发布说明

• Updated IronSoftware.Common to 2024.11.4.
• 更新依赖包以解决已知的安全漏洞。
• 修复了加载和保存 .xlsm 文件时引发异常的问题。
• 修复了加载 Excel 文件时出现"等效部件名称"异常的问题。
• 修复了添加行时公式出错的问题。
• 修复了加载数据验证无效的 Excel 文件时抛出异常的问题。
• 修复了设置数字格式时生成的 HTML 字体颜色为白色的问题。

发布说明

• Updated IronSoftware.System.Drawing to 2024.12.3.
• Updated IronSoftware.Common to 2024.11.2.
• 提高了获取单元格范围的性能（对中型和大型文件提高 5-10 倍速度）。
• 通过缓存评估结果提高了公式计算。
• 修复了在加载某些文件时发生的空引用异常。
• 修复了从公式中获取日期值的问题。
• Added functionality for converting Workbook and Worksheet in different formats as streams.

发布说明

• Updated IronSoftware.System.Drawing to 2024.9.15
• Updated IronSoftware.Common to 2024.9.38
• 添加了将列方向切换为从右到左的支持，这对阿拉伯语、中文和希伯来语等语言非常有用。
• Added methods for setting tab colors with SetWorksheetTabColor and SetWorksheetTabColorIndex.
• Added the RemoveHyperlink method to remove hyperlinks from cells.
• 修复了当单元格没有超链接时，访问单元格的超链接会引发空引用异常的问题。
• 修复了在 XLS 文件中访问文件类型超链接时返回空字符串的问题。
• Fixed an issue where the ToDataTable method did not accurately compute all data types.

发布说明

• Updates IronSoftware.System.Drawing to version 2024.9.11

发布说明

• 小错误修复

发布说明

• 小错误修复

发布说明

• 小错误修复

发布说明

• 小错误修复

发布说明

• 小错误修复
• Updates IronSoftware.System.Drawing to version 2024.5.1

发布说明

• 修复了一个 Bug，该 Bug 在保存文件时会丢失 "共享 "公式（在多个单元格中复制的那种）。
• Updates IronSoftware.System.Drawing to version 2024.4.1

发布说明

• Updates IronSoftware.Common to version 2024.1.7
• Updates IronSoftware.System.Drawing to version 2024.3.4
• 修复了在 .NET Framework 中无法从 web.config 文件中获取许可证密钥的错误

发布说明

• Updates IronSoftware.Common to version 2024.1.2
• Fixes a bug with a very slow execution of methods loading data from DataSets (namely LoadWorkSheetsFromDataSet methods)
• 由于上述修正，许多其他创建大量单元格的方法的性能都得到了提高
• 修复了一个错误，即对单元格进行任何样式更改都会导致单元格前景色设置为黑色
• IronXL.Cell.Int64Value and IronXL.Cell.Int32Value methods are obsolete and will be removed in the future. Use IronXL.Cell.IntValue and IronXL.Cell.LongValue instead
• Adds IronXL.Cells.Comment class to represent cell comments with setters and getters for all comment properties
• Adds Comment property to IronXL.Cell class with methods to add and remove comments. The Comment property is null if cell has no comment. 注释默认添加为不可见

发布说明

• 小的改进和错误修复

发布说明

• 修复了创建定义名称时会抛出异常的错误。
• 修复了加载包含图表表的电子表格时出错的问题。 请注意，仍无法加载图表表。 支持图表表仍是一项功能要求。
• Adds a feature to convert named tables to DataTables.
• 添加对数据验证的支持：
  • DataValidations property added to WorkSheet. 它包含工作表中的所有数据验证，并包含添加和删除数据验证的方法。
  • 所有数据验证类型均可从电子表格中读取。
  • WholeNumber, Decimal, TextLength, Date, List, and FormulaList data validations can be added to WorkSheet.

发布说明

• IronDrawing 已更新至 2023.11.1 版
• 小修复和改进
• IronXL.Logger class is deprecated. Use IronSoftware.Logger instead

发布说明

• IronDrawing 已更新至 2023.10.2 版
• Added dependency on IronSoftware.Common 2023.10.2
• 小修复和改进

发布说明

• IronDrawing 已更新至 2023.9.2 版
• 稳定性改进
• 性能改进，某些情况下执行时间可提高 25

发布说明

• 小的改进和修正。
• 更新依赖项。

发布说明

• Adds the GetMergedRegions method, which is used to retrieve a list of merged regions.
• Fixes a bug where the Clear method did not delete all worksheets in the collection.
• Fixes a bug where the InsertColumn method skipped the last row.
• Fixes a bug where the Range.ToDataTable method would stop converting when it encountered an empty row.
• Adds RemoveColumn method group to Range, RangeRow, RangeColumn, Worksheet.
• InsertColumn method group will now correctly shift the columns out of the way, updating the formulas and moving styles with the cells.
• 在某些情况下，批量数据处理的时间性能可提高 20-25%。
• Deprecates the Range.AllRowsInRange and Range.AllColumnsInRange properties, use Range.Rows and Range.Columns instead. This is also true for the WorkSheet, RangeRow, and RangeColumn classes.
• WorkSheet's internal working range will now correctly update with all changes made to the worksheet.
• WorkSheet's internal working range will now include the empty columns at the end of the range which hold any styling information.
• Fixed numerous bugs in Range.Trim method, including a bug where Trim would not trim empty columns.
• Range.RemoveColumn and Range.RemoveRow methods will now ALWAYS remove the column/row entirely from the sheet, shifting up/to the left the rows/columns located below/to the right of the removed ones, if after the removal the column/row is empty.
• Adds Range.Count property, which returns the number of cells in the range without iterating over all cells.
• Changes the Range.ColumnCount and Range.RowCount properties to return the number of columns/rows in the range without iterating over all cells.
• 改进 Range 类及其继承者的文档。
• InsertRow and InsertColumn methods will now return the inserted row/column. Same for InsertRows and InsertColumns methods but these will return lists of inserted columns/rows.
• Range's address will now be correctly updated when the range is changed (with Trim/Insert/Remove/Subtract methods).
• Adds WorkSheet.RangeAddress property with the address of the area in use on the sheet.
• Updates IronSoftware.System.Drawing to version 2023.7.1

发布说明

• Adds SetBorderStyle method, used to set border type and color.
• 修复了一个错误，即图表系列中的"&"在保存后会破坏生成的文件。
• Fixes a bug where if an .xlsx (.xlsm, .xltx, etc.) file had an opening and closing br tag in its internal XML structure - WorkBook.Load method would throw an exception.
• 将 IronDrawing 依赖关系更新至 2023.6.1 版。

发布说明

• Fixes an issue where license keys would not be retrieved from web.config in some .NET Framework ASP.NET projects
• Fixes possible warnings about System.Memory version conflicts

发布说明

• 添加对 Iron Suite 许可证密钥的支持
• 修复了 IronXL 无法获取 .config 和 .json 文件中存储的许可证密钥的问题
• 增加了对存储在应用程序子文件夹中 .config 和 .json 文件中的许可证密钥的支持

发布说明

• 现在安装 NuGet 软件包前必须同意 EULA 条款
• Improves IntelliSense descriptions for Range class
• Fixes a bug where WorkSheet.PhysicalColumnCount property would throw an exception when accessed while no columns exist on the worksheet
• Improves IntelliSense descriptions for Cell.Hyperlink property
• Fixes a bug when setting Cell.Hyperlink property would in some cases detect the wrong hyperlink type
• Improves the description of an exception that occurs when AutoSizeRow/AutoSizeColumn methods are used while no fonts are found in the system
• 更新依赖项

发布说明

• Enum used for WorkSheet.InsertImage method is changed to IronXL.Drawing.Images.ImageFormat
• 修复了一个错误，即在不同的地方，图表可能会因为小数分隔符而损坏
• 性能改进

发布说明

• Fixes a bug wherein a Licensing exception is thrown when an application using IronXL is executed with a Visual Studio debugger hooked.
• 修复了删除多个图表中的一个，然后再添加另一个图表时会出现异常的错误。
• 图表标题将不再覆盖图表区域。

发布说明

• Fixes a bug, where WorkBook.ExportToHtml was throwing an exception due to un-indexed colors in the document.
• Fixes a bug, where getter calls for properties of Range, WorkSheet, RangeRow, RangeColumn, RangeStyle, RangeFont, and RangeBorder would unnecessarily create all cells in the range.
• Fixes a bug, where exception was thrown upon loading .XLSX files with specific WebPublishing settings.
• Adds WorkSheet.PhysicalColumnCount and WorkSheet.PhysicalRowCount properties, which return the number of rows and columns that are physically present in this worksheet at the moment.
• Improves and updates IntelliSense documentation to clarify some of the WorkSheet's and Range's properties and methods.
• Improves performance when reading any of the Range object's properties, especially in case of large Ranges. This applies to all objects that are inherited from Range (WorkSheet, RangeRow, etc.).

发布说明

• Adds overloads for WorkBook loading methods to accept a password for encrypted XLSX, XLSM, and XLTX workbooks. 新增重载函数的完整列表：
  • TryLoad(string filename, string password, out WorkBook workBook)
  • 加载（字节 [] 数据，字符串密码）
  • 加载（流媒体流、字符串密码）
  • LoadExcel(byte [] data, string password)
  • 加载 Excel（流文件，字符串密码）
  • 加载 Excel（字符串文件名，字符串密码）
  • FromByteArray(byte [] data, string password)
  • FromStream(Stream stream, string password)
• Adds a method WorkBook.Encrypt(string password) which will write a workbook into a MemoryStream, encrypt it using a password provided as an argument or the one stored in WorkBook.Password property, and return resulting encrypted MemoryStream. 仅支持 XLSX、XLSM 和 XLTX 类型的工作簿。
• Adds a method WorkBook.Decrypt(Stream stream, string password) which will decrypt a Stream with a password provided as an argument and return the resulting decrypted MemoryStream. 仅支持 XLSX、XLSM 和 XLTX 类型的工作簿。
• 修复了一个错误，即在将工作簿导出为 HTML 时，某些边框样式会导致异常。
• Fixes a bug where InsertRow method would throw an exception if the row was inserted in the place of the last existing row.
• Improves precision of AutoSizeRow and AutoSizeColumn methods.
• Improves performance of InsertRow method by 25%.

发布说明

• Fixes a bug where first created ConditionalFormattingRule wasn't working properly.
• 修正了一个错误，即字体颜色没有被条件格式化规则应用。
• Fixes a bug where duplicate style was created when Cell.FormatString property was changed in .xlsx.
• Fixes a bug where Range.Row(int) and Range.Column(int) methods could take minutes of time to execute for large ranges.
• Adds an enumeration IronXL.SortOrder to indicate a direction for sorting where applicable.
• Adds Range.SortByColumn(string, SortOrder) and Range.SortByColumn(int, SortOrder) methods that allow sorting a range by a specified column, re-arranging rows of a range being sorted according to specified column's new order.
• Removes dependency to IronDrawing nuget package and replaces it with IronSoftware.System.Drawing.

发布说明

• 修复了上一版本中一些方法被错误混淆的问题。 List of the methods affected: IronXL.Cells.CellFont.SetColor(Color), IronXL.Cells.CellStyle.SetBackgroundColor(Color), IronXL.Cells.XlsCellBorder.SetColor(Color), IronXL.Cells.XlsCellFont.SetColor(Color), IronXL.Cells.XlsCellStyle.SetBackgroundColor(Color), IronXL.Cells.XlsxCellBorder.SetColor(Color), IronXL.Cells.XlsxCellFont.SetColor(Color), IronXL.Cells.XlsxCellStyle.SetBackgroundColor(Color), IronXL.Ranges.RangeBorder.SetColor(Color), IronXL.Ranges.RangeFont.SetColor(Color), IronXL.Ranges.RangeStyle.SetBackgroundColor(Color), IronXL.Styles.IBorder.SetColor(Color), IronXL.Styles.IFont.SetColor(Color), IronXL.Styles.IStyle.SetBackgroundColor(Color).
• Adds a dependency to an IronDrawing nuget package to enable implicit casting from System.Drawing.Color when using methods listed above.
• Adds a method IronXL.Drawing.Images.Image.ToAnyBitmap() which creates an IronSoftware.Drawing.AnyBitmap object from byte data of The Image object.
• 更新最终用户许可协议条款和条件。
• IronXL.dll 已签名。

发布说明

• 增加了使用密码加密和解密".xlsx"、".xlsm "和".xltx "文件的功能。 Use WorkBook.SaveAs(string fileName, string password) method to encrypt the WorkBook with provided password when saving it. Use WorkBook.Load(string filename, string password) method to decrypt file with provided password when loading the workbook. 也可指定密码如下：
  • Using WorkBook.Password property (workbook will be encrypted on save if this property is not null, and will not be encrypted if it is null)
  • Using SavingOptions object with SavingOptions.Password property, when calling WorkBook.SaveAs(string fileName, SavingOptions options) method
  • Using LoadingOptions object with LoadingOptions.Password property, when calling WorkBook.Load(string filename, LoadingOptions options) method
• To check if the WorkBook object will be encrypted on save use WorkBook.IsEncrypted boolean property. Encryption can also be turned off by assigning WorkBook.IsEncrypted = false (Note: workbook cannot be encrypted by assigning WorkBook.IsEncrypted = true, this will throw an exception at runtime, asking to instead specify a password).
• 为非".xlsx"、".xlsm "和".xltx "类型的工作簿设置密码也会在运行时产生异常，提醒用户工作簿无法加密。
• 增加了对 .NET 6.0 的支持
• Removes dependency on System.Common.Drawing
• 移除对 .NET Framework 4.5 的支持。现在支持的最低 .NET Framework 版本为 4.6.2。
• Breaking change: WorkBook.SaveAs(string filename, string listDelimiter) method was renamed to WorkBook.SaveAsWithCustomDelimiter(string filename, string listDelimiter) to remove ambiguity between SaveAs(string filename, string listDelimiter) and SaveAs(string fileName, string password) methods.
• Breaking change: IronXL.Drawing.Images.IImage.ToBitmap() method is removed, as System.Common.Drawing is no longer supported.
• Breaking change: IronXL.Drawing.Images.IImage.ToImage() method now returns a SixLabors.ImageSharp.Image object used as a replacement for removed System.Common.Drawing objects.
• 修正了一个 Bug，在该 Bug 中，为 XLSX 工作簿中的单元格或区域设置的背景颜色无法在 Excel 中呈现。
• 修复了泰语语言区会导致许可证异常的错误
• Fixes a bug where each time a new cell was assigned a DateTime value in XLSX workbook a new cell style was created for each cell, overflowing the style table and breaking the resulting file if the number of cells was > 64000.
• Improves speed of creating large amounts of cells with a DateTime value and format. For example, creating a workbook with 80K DateTime value and format cells on a single worksheet used to take 25 seconds, and now takes less than 0.8 seconds (actual performance will depend on the environment the code is executed in).

发布说明

• Adds a way to change the string value of a cell without automatically formatting the cell: this is achieved through StringValue property of a Cell.
• Adds AutoSizeRow method to Row and WorkSheet, which changes the height of a row to fit the contents.
• Adds AutoSizeColumn method to Column and WorkSheet, which changes the width of a row to fit the contents.
• 修复了一个错误，即在添加或更改边框时会出现异常。
• 修正了一个错误，即当单元格值被更改为依赖于单个单元格的公式（例如"=A1"）时会出现异常。
• 修复了一个错误，即类似于 "12-720 "的字符串添加到单元格时会被解析为 720 年的日期。 Excel 不支持 1900 年以前的日期。类似这样的字符串不再被解析为日期。 但是，1900 年后可被解析为有效日期的字符串仍将被解析为日期。 例如 "12-1956"。 Use StringValue property to bypass this parse.
• 修复了一个错误，即在加载、更改和保存现有工作簿时，单元格的内容发生变化时可能会丢失原有格式。 情况已不再如此。

发布说明

• Adds a new IronXL.Formatting.ConditionType.
• Old IronXL.Formatting.Enums.ConditionType is obsolete.
• 添加了对 "格式为表 "样式的支持。
• 修复了一个错误，即通过 IronXL 加载包含数据透视表的文件，然后保存，结果文件会损坏。
• 修复了一个错误，即复制并粘贴范围后，保存工作簿，结果文件会损坏。
• 修复了一个错误，即加载包含特定图表类型的文件后保存，结果文件会损坏。
• 修正了一个错误，即加载了包含 .bmp 图像的文件，但无法通过代码访问 .bmp 图像。
• 修复了一个错误，即创建的工作簿包含任意数量的已用单元格，保存后文件会损坏。
• 修复了其他一些偶尔可能导致文件损坏的罕见错误。
• 修复应用于单元格范围的任何样式更改都需要花费大量时间。样式更改包括字体（高度、粗细等）、垂直对齐方式、水平对齐方式等的更改。
• 提高生成文件的整体稳定性，无论是使用 IronXL 创建的文件，还是由 IronXL 文件导入和编辑的文件。
• 极大地提高了性能，生成一个包含 10000 个已用单元格的文件过去需要 1.5 分钟，现在只需 20 秒（根据您的代码对单元格执行的操作会有所不同）。

发布说明

• 改进：支持 .NET 6
• 提升：速度和稳定性

发布说明

• 改进：支持 .NET 5 和 .NET 6 测试版
• 提升：速度和稳定性
• 改进：日志记录

发布说明

• 改进：支持 .NET 5 和 .NET 6 测试版
• 修正了错误：许可证密钥验证现在可以安全地使用空格
• 提升：速度和稳定性

发布说明

• 问题已修复：现在可与 .NET 5.07 兼容
• 已修复错误：从项目配置文件中读取许可证密钥（特殊情况）
• 提升：速度和稳定性