Xceed Workbooks for .NET V1.2

La nouvelle classe "MergedCellCollection" peut désormais être utilisée pour fusionner et centrer les cellules dans une feuille de calcul.
Mai 19, 2022
Nouvelle Version

Fonctionnalités

  • The Microsoft .NET 5/6/Standard version no longer depends on the System.Drawing.Common package because, starting with .NET 6, this package only support the Microsoft Windows operating system.
  • Text direction can now be set from right-to-left for languages that require it.
  • Border, Fill, Font and Worksheet can now use either 'ThemeColor' or the more standard 'Color' to customize the colors of different objects.
  • A new ColorHelper class is now available to convert a color between 'ThemeColor', 'Color' or an HTML string.
  • New MergedCellCollection class can be used to merge and center the cells in a Worksheet.
  • Styles have been refactored in order to use less memory.
  • Style, Cells, Columns, Rows, ColumnRanges, RowRanges or CellRanges can now have Borders, which have a line style and a color and can be outside, inside, in diagonal or on the four sides of an element.
  • CellRange, ColumnRange and RowRange:
    • The Style property can now be used to modify a style on a group of Cells, Columns or Rows.
    • The new Elements property now returns all the Cells, Columns or Rows from a range.
  • Column:
    • Improved speed when inserting or deleting columns.
  • ColumnRange:
    • Setting new Width property will modify the width of all columns in a range. Getting new Width property will retrieve common width of columns in the range.
  • Row and RowRange:
    • The AutoFit() method can now be called to adjust the height of the row (or rows) automatically.
  • RowRange:
    • Setting new Height property will modify the height of all rows in the range. Getting new Height property will retrieve common height of rows in the range.
    • It is now possible to retrieve RowRanges using the new indexer in RowCollection, which accepts a startRowId and a EndRowId.
  • HyperlinkCollection:
    • Optimizations have been made in order to improve loading and saving time for Workbooks containing many hyperlinks.
  • Picture:
    • Saving is now optimized so that it doesn’t re-write pictures when they remain unchanged.
    • The Format property is now of type 'PictureFormat' instead of 'ImageFormat'.
    • Picture now has customizable properties.
  • Styles:
    • Improvements have been made in order to reduce delays when several styles are being modified or when a document is saved after several styles have been modified.
    • A new method, called RevertToDefault(), now sets the style of the cell, row or column back to its default value.
    • A new property, called Alignment.IsTextWrapped, can now be used to wrap text in a cell.
    • The new Fill property can now be used to customize the fill behavior of a cell, row, column or range.
  • Tables:
    • Loading and saving has been optimized to improve performance when the Workbook contains many tables.
  • TableCollection:
    • The int indexer now always returns the valid Table based on the Id received.
  • Workbook:
    • Writing styles now overrides the cellStyleXfs's number format Ids and font Ids so that a valid Workbook can be saved.
    • A new property in Workbook, called Theme, is now available to customize the colors of a Workbook's Theme.
  • WorkbookView:
    • The insertion of WorkbookViews is now done as follows: Workbook.WorkbookViews.Add( new WorkbookView() );.
  • Worksheet:
    • A Worksheet can now be inserted in any position in the Workbook.
    • New methods are now available to insert or delete columns.
    • The new InsertRows and DeleteRows methods can now be used to insert or delete multiple rows.
    • Inserting and deleting rows is now faster due to performance improvements.
    • A new ImportData method can now be used to import data of: Array, 2D-Array, ArrayList, ICollection, IDictionary, DataTable, DataView or CSV path/stream type. This new method also includes a parameter that gives more flexibility when importing data of specific types.
  • WorksheetCollection:
    • Optimizations have been made in order to improve loading and saving time for Workbooks containing many Worksheets.
Xceed Workbooks for .NET V1.2
Xceed Workbooks for .NET

Xceed Workbooks for .NET

Créez ou gérez des documents Microsoft Excel à partir de vos applications .NET, sans avoir à installer Excel ou Office.

Demander devis Acheter maintenant

Xceed Workbooks for .NET est également disponible en :

Vous avez une question ?

Discutez en direct avec l'un de nos spécialiste des licences Xceed Software .