Access, Modify VBA Code in Spreadsheets & DataBars to Image Conversion using .NET

LANE COVE, Australia - March 25, 2015 - PRLog -- What is new in this release?

We are pleased to announce the new release of Aspose.Cells for .NET 8.4.0.  This release contains many useful features and other enhancements including the long awaited feature to manipulate VBA codes embedded inside the spreadsheets. Many of the Aspose.Cells users had been waiting for this feature, and now it is available with the release of Aspose.Cells for .NET 8.4.0. The latest version has exposed a new namespace named Aspose.Cells.Vba and a few classes to provide the means to access the VBA code embedded inside the macro enabled spreadsheets, and to update the code as per your requirements. Aspose.Cells allows the users to extract Theme related data from Excel file. For example, you can extract Theme Name applied to workbook and Theme Color applied to cell or borders of the cell etc. Another worth mentioning feature is the support for Pivot Table removal. Aspose.Cells has provided this feature by exposing two new methods for the PivotTableCollection class that allows to delete a specific PivotTable from the collection depending upon the input parameter. Microsoft Excel has predefined layouts for the Pivot Tables as listed below. Upon choosing any of these layouts, Microsoft Excel applies formatting to the Pivot Tables accordingly.

·         Compact Form

·         Outline Form

·         Tabular Form

Aspose.Cells for .NET 8.4.0 provides the same functionality while using the newly exposed methods for the PivotTable class that allows to dynamically set the layouts as discussed above. Detailed article and sample code snippets are available at Changing the Layout of Pivot Table. With the release of v8.4.0, the Aspose.Cells API has provided the DataBar.ToImage method to save the conditionally formatted DataBar in image format.  Aspose.Cells can be used to add custom properties inside the workbook object which are visible in the Document Information Panel when accessed through Microsoft Excel using the File > Info > Properties > Show Document Panel menu. In the new version, we have also provided the following new enhancements. Customize the generated CSS file while saving Excel to HTML file format, Retain the Cell’s Number Format after using ImportTwoDimensionArray, Aspose.Pdf and other tools validates the output PDF/A-1B file by Aspose.Cells API and workbook’s RefreshChartCache works with regional and language settings. We have fixed a few exceptions that occurred while reading and writing Microsoft Excel file formats and HTML file format. We have also fixed the exceptions that occurred while manipulating Pivot tables in the template file and combining workbooks. In this release, several important issues have been addressed. For example, issues around reading/ writing Microsoft Excel file formats, combining worksheets, Smart Markers, manipulating PivotTables, applying formattings to the cells, using PageSetup options, rendering HTML file format, applying conditional formatting, manipulating shapes, rendering images from Excel worksheets, manipulating charts with formatting, rendering images files from charts and exporting Excel workbooks to PDF format have been resolved. We have also enhanced the Aspose.Cells formula calculation engine further and fixed a few relevant issues in this release. We have fixed an issue regarding customize row/column headers in the web based Grid control provided by Aspose.Cells for .NET. We also figured out issues around setting background color, alignment of rows and charts in the template file not being refreshed in the web based Grid control by Aspose.Cells for .NET. This release includes several enhanced features and bug fixes as listed below

·         Support to delete a PivotTable from Worksheet

·         Content Type Properties are not shown in XLS format

·         Workbook.ContentTypeProperties.Add(name, value, type) is needed

·         Customizing the generation of CSS while saving Excel to HTML

·         Cannot retain the Cell's Number Format after ImportTwoDimensionArray

·         Aspose.Pdf does not validate output PDF/A-1B

·         PDFA1B compliance of the output PDF was not validated

·         Workbook RefreshChartCache works with regional and language settings

·         The whole workbook will have the text bold

·         Excel found unreadable content after setting up password

·         Spreadsheet to HTML generates a 1GB HTML file

·         Performance issue with CalculateFormula() method

·         Background-color: rgba(0, 0, 0, 0); makes the background color black

·         First column disappears when second Pivot

·         Data in Static Pivot Tables is Re-arranged

·         Pivot Tables always label first column as 'Row Labels'

·         Specifying the BaseItemPosition attribute produces an invalid file

·     Other most recent bug fixes are also included in this release.

Newly added documentation pages and articles

 -  Extract Theme Data from Excel File: http://www.aspose.com/docs/display/cellsnet/Extract+Theme+Data+from+Excel+File

 - Changing the Layout of Pivot Table: http://www.aspose.com/docs/display/cellsnet/Changing+the+Layout+of+Pivot+Table

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/.net/excel-component.aspx

-  Download Aspose.Cells for .NET:  http://www.aspose.com/community/files/51/.net-components/aspose.cells-for-.net/default.aspx

- 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

Australia

http://www.aspose.com/

sales@aspose.com

Phone: 888.277.6734

Fax: 866.810.9465