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

發行說明

• 修正了儲存檔案時"共用"公式（在多個儲存格中複製的公式）會遺失的錯誤。
• 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)
  • 載入(byte[] data, string password)
  • 載入(Stream stream, string password)
  • LoadExcel(byte[] data, string password)
  • LoadExcel(Stream file, string password)
  • LoadExcel(字串檔名，字串密碼)
  • 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.
• 修正了 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 相容
• 已修正錯誤：從專案設定檔讀取許可證金鑰（特殊情況）
• 提升：速度和穩定性