Home > Computing > Export Custom Properties to PDF & Get XML Path from List Object > Table using .NET

Export Custom Properties to PDF & Get XML Path from List Object/Table using .NET

Added: (Tue Oct 09 2018)

Pressbox (Press Release) - What is new in this release?

Aspose development team is pleased to announce the new release of Aspose.Cells for .NET 18.9. Many documents can have custom properties which were not made a part of the output PDFs earlier. Aspose team has 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. 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. 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. It has 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. 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. A few of the worth mentioning features and other improvements are also part of this release, such as 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 and Handled exception while saving the document. This release includes several enhanced features and bug fixes as listed below

• Applying text alignment to partial text inside the TextBox
• Export custom document properties to PDF
• Get XML path from List Object/Table
• Support stock chart in ODS file
• Add Row.FirstDataCell property to retrieve the first data cell in the row
• Create safe sheet names similar to Apache POI
• FilterOperatorType.Contains missing from API
• Retrieve range of Query Table
• Name worksheet same as source file name while converting CSV/TSV to Spreadsheet
• Include unsigned Dlls of Aspose.Cells
• Wrong colors rendered for shapes in Excel to PDF conversion
• Quite small images rendered in PDF
• Broken hyperlink in HTML
• Issues in number and date values while calling the AutoFitColumns()
• Pivot tables not working after load and save
• Issues in Pivot tables while refreshing and hiding pivot items
• PivotTable.RefreshData throws 'Index out of range' exception
• Formula not calculated properly
• Named ranges when converted into SVG, not capturing the exact fonts and spacing
• Issues in output PDF when using German keywords in scripting headers and footers
• Table/List Object overlapped the data below the table when importing xml data into the spreadsheet
• Vertical gridlines appeared in the chart after calling Chart.Calculate() method
• Horizontal axis is missing in rendered images from Excel chart
• Issue while setting rotation angle of category axis
• Application GUID is changed
• Storages and streams missing from OLE Package after re-saving an encrypted XLSX file
• Graphs lost while copying worksheet from one workbook to another
• Conditional formatting is applied without font and shading colors when merging workbooks
• Text out of print area rendered in PDF
• Autofit columns or rows disturbing the grouped shapes
• Difference in XML files
• Missing border in ODS Excel output

Other most recent bug fixes are also included in this release

Newly added documentation pages and articles

Some new tips and articles have now been added into Aspose.Cells for .NET documentation that may guide you briefly how to use Aspose.Cells for performing different tasks like the followings.

- Export Custom properties to PDF: https://docs.aspose.com/display/cellsnet/Convert+Excel+Workbook+to+PDF#ConvertExcelWorkbooktoPDF-ExportCustompropertiestoPDF

- Reading and Writing Query Table of Worksheet: https://docs.aspose.com/display/cellsnet/Reading+and+Writing+Query+Table+of+Worksheet

Overview: Aspose.Cells for .NET

Aspose.Cells is a .NET component for spreadsheet reporting without using Microsoft Excel. It supports robust formula calculation engine, pivot tables, VBA, workbook encryption, named ranges, spreadsheet formatting, drawing objects like images, OLE objects and importing or creating charts. You can also create Excel file using designer spreadsheet, smart marker or API and apply formulae and functions. It supports CSV, XLS, SpreadsheetML, OOXML, XLSB, CSV, HTML, ODS, PDF, XPS and all file formats from Excel 97 to Excel 2007. You can also view, generate, modify, convert, render and print workbooks all without using Microsoft Excel.

More about Aspose.Cells for .NET

- Homepage of Aspose.Cells for .NET: http://www.aspose.com/products/cells/net

- Download Aspose.Cells for .NET: http://www.aspose.com/downloads/diagram/net

- Online documentation of Aspose.Cells for .NET: http://docs.aspose.com/display/cellsnet/Home

Contact Information
Aspose Pty Ltd,
Suite 163, 79 Longueville Road
Lane Cove, NSW, 2066
Phone: 888.277.6734
Fax: 866.810.9465

Submitted by:Aspose
Disclaimer: Pressbox disclaims any inaccuracies in the content contained in these releases. If you would like a release removed please send an email to remove@pressbox.co.uk together with the url of the release.