More examples of Aspose.Cells for .NET features missing in VSTO to deal with Microsoft Excel Documents

[![][1] helps you to understand the extra features and importance of Aspose.Cells over VSTO Excel. What’s New in the release of v1.1 Save Workbook to Text or CSV Format Encrypting Excel Files Display or Hide Tabs Display or Hide Scroll Bars Display or Hide Gridline Display or Hide Row Column Headers Advanced Protection Settings since Excel XP Tracing Precedents and Dependents Adding Hyperlinks to Link Data Exisiting Examples Smart Markers Smart Markers feature Grouping Data Using Anonymous Types or Custom Objects Image Markers Using Nested Objects Converting Worksheet Converting Worksheet to Image Converting Worksheet to Image File By Page Import and Export Worksheet Import data from document Importing from Array Importing from ArrayList Importing from Custom Objects Importing from DataTable Export data from document Columns Containing Strongly Typed Data Columns Containing Non-Strongly Typed Data Conversion Conversion Download Latest Examples You can download latest examples from one of the following locations:
<span title='2015-11-20 09:05:18 +0000 UTC'>November 20, 2015</span>&nbsp;·&nbsp;2 min&nbsp;·&nbsp;Zeeshan Shafqat

Aspose.Cells for Java 7.5.3 Maintenance Release

We are pleased to announce the release of Aspose.Cells for Java 7.5.3. This is a maintenance release that contains a few enhancements and fixes for issues reported in earlier versions. We resolved an issue caused by Aspose.Cells for Java’s formula calculation engine. A few other important issues have been addressed. For example, issues around rendering Microsoft Excel files and manipulating pivot tables have been resolved. Issues pertaining to the formula calculation engine have also been fixed in this release.
<span title='2013-09-09 10:26:32 +0000 UTC'>September 9, 2013</span>&nbsp;·&nbsp;1 min&nbsp;·&nbsp;Amjad Sahi

More Enhancements for PivotTables Included in Aspose.Cells for .NET 7.5.3

Aspose.Cells for .NET 7.5.3 has been released. This month’s release includes an enhancement for reading and writing page setup options in HTML files. We have also made several enhancements for rendering, manipulating and refreshing PivotTables. We have fixed a few exceptions when reading and writing Excel files and manipulating PivotTables in a template file. In this release, several important issues have been addressed. For example, issues around rendering Excel files, rendering and manipulating PivotTables, rendering image files, converting Excel files to HTML/MTHML file format and exporting to PDF have been resolved.
<span title='2013-09-09 08:41:22 +0000 UTC'>September 9, 2013</span>&nbsp;·&nbsp;1 min&nbsp;·&nbsp;Amjad Sahi

Add Conditional Formatting Icons with Cell Text using Aspose.Cells for Java 7.5.2

We are pleased to announce the release of Aspose.Cells for Java 7.5.2. We include some useful enhancements in the new release. For example, you may add conditional icons set (images) with your data to make it more meaningful. You may also auto-resize the textbox control based on the text or contents. The component now allows you to create a CellArea by using “$” included in the cell address. This release is also a maintenance release that contains enhancements and fixes for issues reported in the earlier versions.
<span title='2013-08-15 18:59:13 +0000 UTC'>August 15, 2013</span>&nbsp;·&nbsp;1 min&nbsp;·&nbsp;Amjad Sahi

Custom Data Sorting Supported and Other Enhancements in Aspose.Cells for .NET 7.5.2

Aspose.Cells for .NET 7.5.2 has been released. The new release supports adding custom data sorting. We have added some significant enhancements for copying ranges with conditional formatting and clearing the Textbox collection. We have fixed a few exceptions when reading and writing Excel files, and writing legend entries in charts. In this release, several important issues have been addressed. For example, issues around rendering Microsoft Excel file formats, rendering and manipulating PivotTables, converting Excel files to HTML format, adding background watermarks in worksheets, rendering charts, rendering image files and exporting to PDF have been resolved.
<span title='2013-08-13 10:05:58 +0000 UTC'>August 13, 2013</span>&nbsp;·&nbsp;1 min&nbsp;·&nbsp;Amjad Sahi

Insert a Picture Based on Cell Reference in Excel using Java

We are pleased to announce the release of Aspose.Cells for Java 7.5.1. In this release, we supported inserting pictures based on cell references in a worksheet. The data in the picture is reflected accordingly when you update the source cells range. You can now also detect a category number’s formatting type via the Cell.getNumberCategoryType() method. We have fixed an issue regarding JDK1.7 versions for chart to image, sheet to image, and Excel to PDF rendering.
<span title='2013-07-15 11:59:20 +0000 UTC'>July 15, 2013</span>&nbsp;·&nbsp;1 min&nbsp;·&nbsp;Amjad Sahi

Retrieve Conditional Formatting Objects in Excel using C#

Aspose.Cells for .NET 7.5.1 has been released. The new release includes a useful feature to get icon sets, data bars or color scales objects used when adding conditional formatting to a cell or a range of cells. We have also added support for rendering a worksheet’s background in an output HTML file. The component also supports parsing custom views and scenarios while converting from one Microsoft Excel file format to another.
<span title='2013-07-15 11:36:22 +0000 UTC'>July 15, 2013</span>&nbsp;·&nbsp;2 min&nbsp;·&nbsp;Amjad Sahi

Aspose.Cells for SharePoint 3.0.2 Enhances Searching in Excel Documents

[![Aspose.Cells for SharePoint logo][1] at the document root folder in Aspose.Cells for SharePoint on SharePoint 2007. To see a complete list of fixes and to download Aspose.Cells for SharePoint 3.0.2, please visit the [download page][2]. [1]: https://blog.aspose.com/wp-content/uploads/sites/2/2013/07/aspose-Cells-for-SharePoint_100.png “Aspose.Cells for SharePoint logo”)](https://blog.aspose.com/wp-content/uploads/sites/2/2013/07/aspose-Cells-for-SharePoint_100.png)We are happy to announce Aspose.Cells for SharePoint 3.0.2. In this release, we have provided enhanced support for the searching in a document feature. We have also included some other enhancements and fixes: we have fixed an issue regarding setting license using Aspose.
<span title='2013-07-02 13:25:25 +0000 UTC'>July 2, 2013</span>&nbsp;·&nbsp;1 min&nbsp;·&nbsp;Amjad Sahi

Improved PST Operations & Message Conversion with Aspose.Email for .NET 3.1.0

We are pleased to announce the release of Aspose.Email for .NET 3.1.0. In our continuous efforts to improve the performance and functionality of the Aspose.Email library, we have fixed a number of issues related to different functionality areas of the API. This month’s release is sort of a maintenance release where a number of bugs reported by our users have been fixed in addition to our ongoing quality assurance efforts.
<span title='2013-06-30 05:21:03 +0000 UTC'>June 30, 2013</span>&nbsp;·&nbsp;1 min&nbsp;·&nbsp;Kashif Iqbal

Aspose.Cells for JasperReports 1.1.3 supports JasperReports Server 5.1

We have published Aspose.Cells for JasperReports 1.1.3. In this version, we provide support for JasperReports 5.1. We have also fixed some internal bugs and added other fixes. Download URL: https://www.aspose.com/community/files/67/jasperreports-exporters/aspose.cells-for-jasperreports/entry475864.aspx
<span title='2013-06-25 14:22:17 +0000 UTC'>June 25, 2013</span>&nbsp;·&nbsp;1 min&nbsp;·&nbsp;Amjad Sahi