Xceed Workbooks for .NET V3.0 (Build 5.2.25608.6677)2025年12月8日
機能
Version sync with other libraries.
Xceed Workbooks for .NET V3.0 (Build 5.0.25228)メジャーバージョン2025年4月29日
機能
Now optimized to support millions of cells in a Workbook.
Now supports almost every type of 2D and 3D charts offered by Microsoft.
Now possible to use Conditional Formatting in a Worksheet to format Cells based on specific conditions.
The DataValidation class has been changed and now works with two new companion classes, called DataValidationSingleCondition & DataValidationRangeCondition, which determine the type of condition that will be used for the validation process.
In DataValidationCollection, new methods were introduced to make it easier to retrieve DataValidations within a specific range of the Worksheet.
In PictureCollection, a new method, called Clear, can now be used to remove all the Pictures in a Worksheet.
Now possible to get the value of the CellRange class’ DataValidation property.
The picture part associated with a Picture is now correctly removed from a .xlsx document when said Picture is removed.
When a new style is set on a CellRange intersecting with an already styled Column, the resulting style will now be in sync with the range’s or Column’s original styles.
Xceed Workbooks for .NET V2.0 (Build: 4.0.250103.5744)メジャーバージョン2025年2月3日
機能
Xceed Workbooks for .NET now supports .NET 9.
Xceed Workbooks for .NET now supports non-Windows environments in a .NET 5+ context. Note that a new dll, named Xceed.DrawingUtils.NET.dll, is required to make this work and should replace System.Drawing or System.Drawing.Common when using Color, Point, RectangleF, Font & similar types.
A new class, called DataValidation, can now be used to integrate Excel’s validation feature into Xceed Workbooks for .NET.
A new class, called PageLayout, now allows to define the options related to the Worksheet’s page & printing layouts.
PageLayout
A new property, called Margins, now allows to add margins to a Worksheet.
Multiple methods have been added to allow the insertion & removal of page breaks in the Worksheet.
Two new properties, respectively called RowBreaks & ColumnBreaks, can now be used to keep track of where page breaks are inserted in the Worksheet.
Worksheet
A new property, called PageLayout, now allows to get how the Worksheet is laid out.
Alignment
A new property, called IndentLevel, now allows to define the indentation for the content of a Cell.
A new property, called IsShrinkToFit, now allows to shrink a text so that it fits within a Cell.
Cell
A new method, called CalculateFormula, now allows to calculate the Cell’s formula & then update the Cell’s Value property with the results of the calculation.
A new method, called CopyAndPasteTo, now allows to either copy or cut data & then paste it elsewhere in the Workbook.
Formulas read from a loaded workbook now include the “=” sign so that said formulas can be calculated.
The maximum number of shared strings allowed is no longer 65536, but 4,294,967,295, which means that shared strings will no longer be repeated in Cells.
CellRange
Two new methods, called CopyAndPasteTo and CutAndPasteTo, now allow to respectively copy or cut data from a CellRange and paste it elsewhere in the Workbook.
A new enumeration, called CopyOptions, allows to determine if the data found in a specific Cell or CellRange will be copied or cut before being pasted into a new location.
A new enumeration, called PasteOptions, allows to determine what kind of data is pasted into a new location.
Workbook, Column, Row, Worksheet and Ranges
A new method, called ReplaceContents, can now be used to replace multiple search values with new values, without the need to repeat the process for every value that needs to be replaced.
修正
Column
The Column’s Width property will now be set automatically to 255 instead of throwing an exception when a Document containing a Column larger than 255 is loaded.
Workbooks
Using multi-threading to set multiple Cells’ properties no longer throws exceptions.