Xceed Workbooks for .NET V1.2

La nuova classe MergedCellCollection ora si può utilizzare per unire e centrare le celle in un foglio di lavoro.
Maggio 19, 2022
Nuova versione

Funzionalità

  • 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

Xceed Workbooks for .NET

Crea o modifica i documenti Microsoft Excel dalle tue applicazioni .NET, senza la necessità di installare Excel né Office.

Hai una domanda?

Chatta live con i nostri specialisti di gestione delle licenze di Xceed Software ora.