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


Well-known member
Mar 10, 2010
Programming Experience
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
- PivotTable calculation issue: cell value is truncated
- PivotTable.RefreshData corrupting content
- Excel file becomes corrupted after creating pivot table
- Position of images is wrong in the output PDF
- Buttons appeared in the PivotChart when the file is re-saved
- "Excel found unreadable..." error after refreshing Pivot Data
- Alignment issue while rendering the worksheet to image
- Gap between the header and the body is different
- Newer version could not accept less than 96dpi
- Incorrect spacing with each Environment.NewLine in output PDF
- FitToPagesTall and FitToPagesWide attribute not working as expected
- Incorrect rendering of the Chart Title while converting Chart to Image
- Incorrect rendering of the Chart Title while converting Chart to Image
- Chart Title is incorrectly rendered while converting Chart to Image
- PDF size doubles when it is converted from XLSX
- Chart Legend issue while converting XLSX to PDF
- Chart Axis issue while converting XLSX to PDF
- Graphic Issue while converting XLSX to PDF
- Chart's Series Shadow does not copy while copying the Workbook
- Charts are not rendered properly in the output PDF
- Pie chart labels are overlapping
- Labels overlapping when rendering the pie chart
- Pie Chart Data Labels overlapped
- Issue with OLE Pie charts Data Labels / Leader Lines
- Problem with Array formula
- Cell values are replaced by values from other cells
- Font color of WordArt changes after loading and saving xls
- Conversion from XLSX to XLSB produce corrupted spreadsheet
- Embedded Docm or Dotx in xls cannot be opened
- Smart Markers stops merging data after X number of rows
- Combining worksheets breaks apostrophe
- Lookup formula is not calculated correctly
- PageSetup.IsHFAlignMargins gets automatically true in the output Excel file
- Hyperlinks without subaddresses are lost
- Conditional Formatting - Cells should not have Red background
- "Invalid data format" error after manipulating VBA codes
- Updated formula not saving when it contains an external reference
- Error occured with images in the template file
- Formula value is not calculated correctly by Workbook.CalculateFormula
- Spreadsheet built-in document property 'Version' inconsistency
- Format of the Hyperlink changes while copying the range
- Inserting columns in a table causes the unreadable warning
- Issue with rendering conditional formatting - Excel to HTML
- Issue with rendering conditional formatting - Excel to PDF
- Insert Rows parameter is not working fine in Cells.ImportDataReader() method
- Removing Border does not work in the output Excel file

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.

- Extract Theme Data from Excel File
- 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, SpreadsheetML, PDF and all file formats from Excel 97 to Excel 2007.

More about Aspose.Cells for .NET

- Homepage of Aspose.Cells for .NET C#
- Download Aspose.Cells for .NET
- Online documentation of Aspose.Cells for .NET
- Demos of Aspose.Cells for .NET

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