Export custom document properties to PDF and create safe sheet names using Aspose.Cells for .NET 18.9

Share on FacebookTweet about this on TwitterShare on LinkedIn


Aspose.Cells for .NET logo
We are pleased to announce the release of Aspose.Cells for .NET v18.9, 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. Please check the release notes which cover all the new features, enhancements and list of bugs which are resolved in this new version. Exceptions handling empowers the developers to keep control of the applications and assist users in a better way to continue using the application without any interruption. We have resolved many exceptions to achieve this goal. You will get an idea about what is new and what has been enhanced or fixed with this revision of Aspose.Cells for .NET.

 

Export custom document properties to PDF

Many documents can have custom properties which were not made a part of the output PDFs earlier. Now we have provided this feature to maintain the precious information through custom properties by exporting these to the PDF files. These properties can be observed in Adobe Acrobat Reader by clicking on File and then Custom tab page in properties sheet.   

For a working example refer to the following article:

Get XML path from List Object/Table

XML data can be imported to worksheets where sometimes XML path is required from the ListObjects of the worksheet. This feature is available in MS Excel by using expression like Sheet1.ListObjects(1).XmlMap.DataBinding. We are glad to share that this feature is available now in Aspose.Cells as well. 

For a working example refer to the following article:

Create safe sheet names 

Sometimes there is a need of assigning the sheet name at runtime. In this scenario, there may be sheet names which may contain some additional characters like <>+(?”. You might need to replace any such character, which is not allowed as a sheet name with some preset character. Similarly the length may increase to more than 31 characters which needs to be truncated. Apache POI provides certain features of creating safe names, hence similar feature is provided by Aspose.Cells to handle all these issues.

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

Enhanced filters like Contains, Not Contains, Blank and Non-Blank 

We have increased the range of auto filters like filtering based on fill colour, date, dynamic date, number and texts. These filters were already part of our previous releases. Need was felt to add filters like blank/non-blank and custom filters with contains and not-contains. This time these filters are added along with sample files so that these features can be tested easily. 

For a working example refer to the following article:

Retrieve query table result range 

QueryTable represents a worksheet table built from data returned from an external data source, such as an SQL Server or a Microsoft Access database. Aspose.Cells provides an option to read the address i.e. result range of cells for a query table.  

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.

  • Support stock chart in ODS file
  • Included unsigned Dlls of Aspose.Cells
  • Add Row.FirstDataCell property to retrieve the first data cell in the row
  • Handled exception when converting an XLSX file to PDF file format 
  • Handled ArgumentOutOfRangeException while calling Slicer.Refresh()
  • Handled exception when retrieving the url of the list object’s xml data binding map
  • Handled System.OverflowException while calling Chart.Calculate
  • Handled exception while saving the document

In Aspose.Cells 18.9, we fixed several important bugs and other issues. For example, issues around reading/writing MS Excel file formats, applying conditional formatting, setting borders in ODS file, reading/writing HTML files, manipulating List Object/Table, adding OLE packages, rendering and manipulating charts and shapes, manipulating PivotTables, rendering images from Excel worksheets, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved in the release. 

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 .NET:

  • Adds CellsHelper.CreateSafeSheetName(string nameProposal)/CreateSafeSheetName(string nameProposal, char replaceChar) methods ,Methods for user’s convenience to create valid sheet name
  • Adds Row.FirstDataCell, Gets the first non-blank cell in the row.
  • Adds MapChartLabelLayout enum, Represents the label layout type of the map chart
  • Adds MapChartProjectionType enum, Represents the projection type of the map chart
  • Adds MapChartRegionType enum, Represents the region type of the map chart
  • Adds QuartileCalculationType enum, Represents the quartile calculation type of the chart
  • Adds Series.LayoutProperties property and class SeriesLayoutProperties, Represents the layout properties of the series
  • Adds TickLabels.IsAutomaticRotation property, Indicates whether the rotation of the tick labels is automatic
  • Adds FilterOperatorType.BeginsWith, Contains, EndsWith and NotContains enum, Represents the text filter operator type
  • Adds Cell.GetDisplayStyle(bool) method, Gets the display style of the cell
  • Adds GlobalizationSettings.GetStandardHeaderFooterFontStyleName(string localFontStyleName) method, Gets standard English font style name (Regular, Bold, Italic) for Header/Footer according to given locale font style name
  • Adds PdfCustomPropertiesExport enum, Specifies the way CustomDocumentPropertyCollection are exported to PDF file
  • Adds PdfSaveOptions.CustomPropertiesExport property, Gets or sets a value determining the way CustomDocumentPropertyCollection are exported to PDF file. Default value is None
  • Adds class XmlDataBinding, Represents Xml Data Binding information
  • Adds ListObject.XmlMap property, Gets an XmlMap used for this list
  • Adds XmlDataBinding.Url property, Gets source url of this data binding
  • Adds XmlMap.DataBinding property, Gets an XmlDataBinding of this map

Aspose.Cells for .NET Resources

The resources, you may need to accomplish your tasks: