Render HTML with Scalable Column Width using Aspose.Cells for .NET v18.10

Aspose.Cells for .NET logo

We are pleased to announce the release of Aspose.Cells for .NET v18.10, the MS Excel file formats API that provides the ability to create, manipulate, convert or render MS Excel spreadsheets, and more importantly – is fully documented. Please check the document on how to install Aspose for .NET APIs directly from NuGet repository. We have added a few important features while keeping the product more stable and feature rich API. In this release, we have also added some useful enhancements and resolved a number of issues. Sometimes when some bug or issue is reported, that guides us to provide some new feature or enhancement thus making this product more user friendly and capable of solving complex problems in an easier way. Simple features that become quite handy while working with a complex product are added like providing last saved time property for keeping track of changes etc.

Please check the release notes which cover all the new features, enhancements and list of bugs that are resolved in this new version.

Scalable Column Width

Depiction of data through the HTML page is very common, however, this page can be opened in a variety of devices including mobiles, tabs, and other handheld devices that contain small screens. The size of the columns is defined in “pt” which works in many cases. However, there can be case where this fixed size may not be required. For example, if the container panel width is 600px where this HTML page is being displayed. In this case, you may get a horizontal scrollbar if the generated table width is bigger. This requirement is addressed by providing scalable units like em or percent for a better presentation.

For a working example refer to the following article:

Handle Self-Closing Tags in HTML

Empty tags are very common while working with HTML like we can face <td></td> or simply <td/>. Earlier self-closing tags were not supported however now this support is provided. Now you can load any HTML with self-closing tags and convert it to an Excel file.

For a working example refer to the following article:

Support for German Locale in Named Range Formulae

Named regions can have English formulae and this file can be used in environments where systems are configured to German locale. There is a need to translate these English formulae completely to the German language for correct usage in MS Excel configured for the German language. This feature is fully functional and can be used without any extra coding.

For a working example along with a template file refer to the following article:

Custom Filter with BeginsWith and EndsWith

MS Excel provides custom filters like filter rows which begins with and ends with some specific string. This feature is available in Aspose.Cells and demonstrated by providing working examples.

For a working example refer to the following article:

Get Connection Points from Shapes 

Aspose.Cells provide rich features to manage shapes in the spreadsheet. Sometimes there is a need to get the connection points of a shape for aligning or placing the shapes at the appropriate place. For this purpose, all the connection points are required. The following code can be used to get the list of connection points of a shape where Shape.GetConnectionPoints() function is used.

For a working example refer to the following article:

Other Enhancements and Fixes

There are some other enhancements included and a few exceptions handled in the new release for the users. A few of the worth mentioning features and other improvements are as follows.

Changes to the Public API

The following is a list of any changes made to the public API such as added, renamed, removed or deprecated members as well as any non-backward compatible change made to Aspose.Cells for Java:

  • Adds HtmlSaveOptions.WidthScalable property, Indicates whether using scalable unit to describe the column width when exporting file to HTML. The default value is false.
  • Adds WorkbookDesigner.UpdateEmptyStringAsNull property
    Indicates whether processing the empty string value as null.
  • Updates the returned value of DocumentProperty.ToDateTime() method, BuiltInDocumentPropertyCollection.CreatedTime, BuiltInDocumentPropertyCollection.LastPrinted and BuiltInDocumentPropertyCollection.LastSavedTime properties Returns the time in local timezone.

Aspose.Cells for .NET Resources

The resources, you may need to accomplish your tasks: