Ahora incluye un sistema de protección de libros que restringe las modificaciones.
Octubre 7, 2022
Nueva versión
Características
- The Microsoft .NET Standard version of this product is no longer supported. The .NET 5 version should be used instead.
- Workbooks now supports notes and comments.
- Workbooks now contains a workbook protection system that restricts modifications.
- The name of a workbook is now an available property.
- It is now possible to partially format the text inside of cell.
- Added a new class, called CellHelper, which now offers conversion methods like ConvertNumberToLetter() and ConvertLetterToNumber().
- Added new methods in the ColorHelper class to help with the manipulation of the indexed color palette.
- Macros that do not use definedNames are now preserved when loading a document.
- When raised, exceptions that are related to one of the main elements of a worksheet (cell, row, column, etc) will now provide as much detail as possible on the source of the problem.
- Row, Column, Worksheet, Workbook and Ranges:
- Added a new method, called Clear, which can now be used to clear some parts of the targeted element.
- Worksheet, Workbook, Column, Row and all types of Ranges (CellRange, RowRange, ColumnRange, WorksheetRange):
- Added a new method, called ReplaceContent, which can now be used to replace the content of a cell with a new value.
- Alignment:
- The RotationAngle property can now be used to rotate the content of a worksheet.
- Annotation:
- Deleting a row or column which contains notes or comments now removes the notes or comments during the deletion.
- AnnotationCollection:
- Added new methods which are now available to remove specific notes or comments from the collection.
- Cell:
- Added a new property, called DataType, which can now be used to retrieve the type of values in a cell.
- ColorHelper:
- The ToColor(Workbook, ThemeColor) method now returns the ThemeColor's color by getting the value of its Tint property.
- Column:
- Added a new property, called IdName, which can now return the index of a column as a letter.
- The ColumnCellCollection now uses a cache to retrieve its cells faster.
- Column and ColumnRange:
- Added a new property, called IsHidden, which can now be used to decide if columns are hidden or not.
- FormattedText:
- The constructor receiving a font now uses a copy of the font, which prevents any future modification of that font from having an impact on the FormattedText.
- Hyperlink:
- Added a new constructor which can now be used in order to create a hyperlink that will be used with the ReplaceContent method.
- HyperlinkCollection:
- Remove methods are now available to remove specific hyperlinks.
- MergedCellCollection:
- Added a new method, called Remove, which is now available to remove a CellRange from the merged cells.
- Note:
- A Note can now be modified when its Protection property is set and its associated worksheet has protection.
- Picture:
- The Picture.DrawingClientData.LocksWithSheet property is now called Picture.DrawingClientData.Locked.
- A picture can now be modified when the Picture.DrawingClientData.Locked property is set to false and the associated worksheet has protection.
- PictureCollection:
- Added new methods which are now available to remove specific pictures.
- Row:
- The height of the highest cell will now be returned based on either the font or the text wrapping settings when the Height property is not set. In both cases, the minimum return value will be the row’s default Height.
- Row and RowRange:
- Added a new property, called IsHidden, which can now be used to decide if rows are hidden or not.
- SheetView:
- Added new properties which are now available to set views and determine their zoom level.
- Added two new properties, called FrozenColumns and FrozenRows, which are now available to freeze columns or rows in a Worksheet.
- Added two new properties, called SplitColumns and SplitRows, which are now available to add a vertical or horizontal split in the SheetView.
- Style:
- Added a new property, called Protection, which can now be used to protect or unprotect specific cells in a protected worksheet.
- Added a new property, called BuiltinType, which now allows the use of Microsoft Excel’s built-in styles inside of workbooks.
- Using a style on columns or rows now merges that style with the one that is already set on their cells.
- Table:
- Added a new property, called StyleName, which can now be used to apply a custom style on a table.
- Adding a new table which intersects with an existing table now raises an InvalidOperationException.
- TableCollection:
- Added new methods which are now available to remove a table from a worksheet.
- The Remove method that uses an index to identify the worksheet that will be removed is now named RemoveAt.
- Worksheet:
- Added new methods which are now available to protect or unprotect a worksheet. This protection can be implemented with or without a password.
- Added a new property, called Visibility, which can now be used to determine the way in which the worksheet will be displayed.
- The ReplaceContent method is now optimized to replace content faster.
- WorksheetCollection:
- WorksheetRanges can now be retrieved in order to act on multiple worksheets at the same time. This can be useful to do things like modifying the visibility of the selected worksheets, changing the color of their tabs and moving or removing multiple worksheets at the same time.
- The Remove method that uses an index to identify the worksheet that will be removed is now named RemoveAt.
Cree o manipule documentos de Microsoft Excel desde sus aplicaciones .NET, sin necesidad de instalar Excel u Office.
¿Alguna pregunta?
Chatee en vivo ahora mismo con nuestros especialistas en licencias de Xceed Software.
Distribuidor oficial desde 1998
