Category Archive: Aspose.Cells Product Family

Official blog of Aspose.Cells for .NET, Java & Reporting Services with news of newly supported features, hot fixes, technical articles, tips and videos.

Dom4j Library Dependency Removal in Aspose.Cells for Java 7.6.1

Posted on November 22, 2013 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.6.1. In this release, the dependency on the dom4j library has been removed. So, now dom4j-1.6.1.jar can be excluded from the classpath when using Aspose.Cells as we have written our own XML parser for certain operations. We have done a number of enhancements in the new release.

For example, we fixed an issue regarding set license, specifically the “Cannot find blacklisted licenses resource” exception as sometimes our users find … Continue Reading

Compute Microsoft Excel Selected Color for ColorScale Conditional Formatting using C#

Posted on November 22, 2013 by Amjad Sahi

Aspose.Cells for .NET 7.6.1 has been released. This new release supports calculating the color selected by Microsoft Excel when a ColorScale conditional formatting is used in a template file. Moreover, we have enhanced how the product handles encrypted files so that these do not raise FIPS validation errors now. We have also added some significant improvements for the generated password protected files (by Aspose.Cells), so OOXML API does not raise an exception when loading/opening the files in it. Please see … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Apply ColorScale Conditional Formatting, Excel Files Encryption, advanced conditional formatting, export Excel workbooks to PDF, generate password protected Excel files, improved OOXML API, manipulate PivotTables, render MS Excel file formats, render images files from Charts, rendering Charts, select range of cells, web based grid control

Work with Binary File Formats on Hadoop using Aspose

Posted on October 30, 2013 by Sabir

Apache Hadoop has great capabilities for archiving big data through its flexible distributed file system (HDFS) across several nodes. This big data solution is also powered by the MapReduce Framework which enables developers to analyze the archived data through its APIs. The big data may be structured or unstructured and may be in any file format. Keeping this in mind, we have the released first version of the Aspose for Hadoop project which enables developers to work with a number … Continue Reading

Posted in Aspose.Words Product Family, Aspose.Total Product Family, Aspose.Cells Product Family, Aspose.Email Product Family, Aspose.Slides Product Family |

Add Image to First Page’s Header and Footer in Excel using Aspose.Cells for Java

Posted on October 29, 2013 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.6.0. This release supports selecting a range of cells in the worksheet while activating the worksheets in the output Excel file. You may also specify a first page header and footer image for worksheet.

We had a number of complaints regarding the image quality in chart-to-image conversion and have improved the quality to a certain extent. We have also resolved a number of exceptions encountered when reading and writing … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Add graphics in header footer of Excel in Java, Add image in header footer of Excel in Java

Resample Images in Excel to PDF Conversion and Other Enhancements in Aspose.Cells for .NET 7.6.0

Posted on October 23, 2013 by Amjad Sahi

Aspose.Cells for .NET 7.6.0 has been released. The new release lets you select a different paper source when printing worksheets. Moreover, the collection objects are now Lambda/Linq friendly. We have added some significant enhancements for reading non-native Microsoft Excel files: now the component throws the appropriate exception when loading such files. We have improved the module for inserting OLE objects.

This release, also supports resampling images added to PDF documents to reduce the overall file size and improve performance. So, … Continue Reading

Posted in Aspose.Cells Product Family |

Excel to PDF, Worksheet to Image and Chart to Image Features Supported in Aspose.Cells for Android 1.1.0

Posted on October 4, 2013 by Amjad Sahi

We are pleased to publish the next version of Aspose.Cells for Android 1.1.0. This release supports more file formats, for example ODS, XPS, and SVG. Moreover, Aspose.Cells for Android 1.1.0 includes all the important and useful features present in its native Aspose.Cells for Java. For example, the component now supports the following file formats and conversions:

Rendering Workbook to PDF, XPS, ODS and SVG formats
Worksheet to Image
Chart to Image
Excel to PDF
Shape to Image

To see a … Continue Reading

Posted in Aspose.Cells Product Family |

Aspose.Cells for Java 7.5.3 Maintenance Release

Posted on September 9, 2013 by Amjad Sahi

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 … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Microsoft Excel, java, maintenance release, pivot table, product release

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

Posted on September 9, 2013 by Amjad Sahi

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 … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Microsoft Excel, maintenance release, pivot tables, product release

The Digital Group Automated the creation of complex financial reports in Excel format using Aspose.Cells for .NET

Posted on September 4, 2013 by The Digital Group

About The Digital Group (T/DG)

The Digital Group (T/DG) is a premier provider of information technology services with extensive expertise in all facets of software development. With capabilities at all points of the software life-cycle, we can provide support from concept to development to operations. For the last decade, our teams have been delivering industry-leading solutions for our customers.

The Digital Group, with its headquarters in Princeton, New Jersey, was incorporated in 1999 having a global talent pool of top-notch … Continue Reading

Posted in Aspose.Cells Product Family, Aspose.Cells, Success Stories |

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

Posted on August 15, 2013 by Amjad Sahi

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 … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Microsoft Excel, conditional data, java, maintenance release, product release