PDF/A-1a Compliance Support, Custom Page Size Options & Working of GridWeb with SQL Server ASP.NET Session State

Aspose.Cells for .NET logoWe are pleased to announce the release of Aspose.Cells for .NET v17.5. This release includes many new features and enhancements along with some critical bug fixes that further improve the overall stability of the API. Please check the release notes in order to get an idea about what is new and what has been fixed with this revision of Aspose.Cells for .NET. You can also install Aspose for .NET APIs directly from NuGet repository.

Support PDF/A-1a compliance in PdfSaveOptions

Aspose.Cells now allows you to create PDF with PDF/A-1a – Level A (accessible) conformance. It already supports PDF/A-1b – Level B (basic) conformance. Following code snippet demonstrates how to convert an Excel file to PDF compatible with PDFA-1a.


//Open an Excel file.
Workbook wb = new Workbook("e:\\test2\\Book1.xlsx");

//Create pdf save options and set its compliance to PDFA-1a.
PdfSaveOptions opts = new PdfSaveOptions();
opts.Compliance = PdfCompliance.PdfA1a;

//Save the output pdf.
wb.Save("e:\\test2\\out1.pdf", opts);

Please see this article that explains how to convert your Excel file into PDF with PDF/A-1a conformance.

Remove existing Printer Settings in Excel file

Sometimes developers want to remove existing Printer Settings in Excel file. These settings are found inside the “[file “root”]\xl\printerSettings” folder in the form of .bin files. Aspose.Cells can remove existing printer settings in the Excel workbook. For more detail, please see this article.

Implement Custom Page Size Options for the Worksheet

There is no direct option available to create custom paper sizes in MS Excel, however you can set custom paper size of your desired worksheets when rendering Excel file to PDF file format. This document explains how to set custom paper size of a worksheet using Aspose.Cells APIs.

Export HTML String Value of the Cells to the DataTable

Using Aspose.Cells APIs, developers can fill a DataTable with corresponding HTML strings (based on cells values) while exporting worksheet data. This document explains how to export HTML strings for the formatted cells data to fill a DataTable using Aspose.Cells APIs.

Working of GridWeb when ASP.NET Session state mode is SQL Server

If you want to use SQL Server or StateServer to hold sessions, use GridWeb Session Mode. The GridWeb control now supports serializing its data to SQL Server or StateServer. For detail, please see this article.

Shift First Row down when inserting Cells Data Table Rows

Earlier, Aspose.Cells does not shift first row down when inserting rows. But for some users’ requirements, it has supported this feature now. Please see this article for more detail about this feature. It also shows an example of ICellsDataTable implementation.

Copy Page Setup Settings from Source Worksheet into Destination Worksheet

When you copy worksheet into another worksheet, then page setup settings of the source worksheet are not copied to destination worksheet. Please use PageSetup.Copy() method to copy the setting of the page setup from source to destination worksheet. Please see the following article for more detail.

Changes to the Public API

This version of Aspose.Cells for .NET has made some changes to the Public API. A few of the worth mentioning changes are as follow.

  • Added ExportTableOptions.ExportAsHtmlString property that exports the HTML string value of the cells to the DataTable.
  • Added PageSetup.Copy(PageSetup source,CopyOptions copyOptions) method that copies the settings of the Page Setup.
  • Added PageSetup.CustomPaperSize() method that sets the custom paper size, in the unit of inches.
  • Added PageSetup.PrinterSettings property that gets and sets the settings of the default printer.
  • Added enum member PdfCompliance.PdfA1a that represents PDF format compatible with PDFA-1a.

Aspose.Cells for .NET Resources

The resources, you may need to accomplish your tasks:


To keep up with our news, you can follow us on Twitter or follow our Facebook page.

Leave a Reply