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.

Copy sparklines between workbooks, set tab color and other enhancements in Aspose.Cells for Java 7.3.2

Posted on September 26, 2012 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.3.2. In this release we have added support for copying sparklines between workbooks. We also made an important enhancement regarding obtaining the offset of the right-bottom corner of a given shape. Users can now set the default color of the worksheet tab. Moreover, several important customer issues have been rectified. Many important issues with reading and writing Microsoft Excel files, manipulating charts and exporting to PDF have been resolved … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Microsoft Excel, java, product release, set tab color, sparklines, tab color

Copy sparklines between workbooks and other enhancements in Aspose.Cells for .NET 7.3.2

Posted on September 26, 2012 by Amjad Sahi

We proudly to announce the release of Aspose.Cells for .NET 7.3.2. In this release we have added support for copying sparklines between workbooks. We have also made an important enhancement to how protected ranges in the worksheet are handled: users can now set permissions for domain users/groups. Moreover, several important customer issues have been rectified. Many important issues with reading and writing Microsoft Excel files, manipulating charts, the Page Setup module and PDF export have been resolved in this release. … Continue Reading

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

Gjensidige supported highly advanced Data Export from SAS to Excel using Aspose.Cells for .NET

Posted on August 24, 2012 by Bjarke Felbo

About Gjensidige Insurance

Gjensidige Insurance is a multinational insurance company, which primarily is located in Scandinavia. The team of Analysis Denmark consists of 12 members, who examine and manipulate huge amounts of data. This data is turned into easily understandable graphs and sheets using Excel sheets or other similar tools. Many leaders throughout the company then examine this material and use it to better lead the company in the right direction.

Problem

We have been using a SAS server for … Continue Reading

Posted in Aspose.Cells Product Family, Aspose.Cells, Success Stories | Tagged .NET API for data export to Excel, Advance data export to Excel format in .NET Application, Data Export from SAS to Excel using Aspose.Cells for .NEt, Memory Efficient data export to Excel

Parse Headers and Footers in Excel using Java

Posted on August 23, 2012 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.3.1. In this release, you can parse headers and footers to get strings for different sections. We have also made some valuable enhancements regarding Microsoft Excel 2007/2010’s advanced conditional formatting file formats types that were not supported in the product. Moreover, Microsoft Excel 2010’s advanced data validation is now supported. We have also supported data filters in Pivot Tables. We have made several enhancements regarding redundant temporary files … Continue Reading

Posted in Aspose.Cells Product Family | Tagged HTML output, Microsoft Excel, PDF output, advanced formatting, headers and footers, java, product release

Advanced Conditional Formatting Types of Excel 2010 Supported, Formula Calculation Engine is Improved in Aspose.Cells for .NET 7.3.1

Posted on August 23, 2012 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for .NET 7.3.1. In this release, we have made some valuable enhancements to the advanced conditional formatting types of Microsoft Excel 2007/2010 file formats that were not supported in the product. Moreover, Microsoft Excel 2010’s advanced data validation is now supported. We have also supported data filters in Pivot Tables. We have made several enhancements regarding data series and markers for charts. The auto-shapes rendering in output HTML has also … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Microsoft Excel, advances conditional formatting, formulas, product release

Apply Themes to Charts in Excel Files using Java

Posted on July 16, 2012 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.3.0. In this release, we have included some valuable new features, enhancements to existing features and resolution of the reported issues. One of the new features introduced in this release is the ability to open and save MHT files. We have also introduced a feature that lets you apply Microsoft Excel themes and colors to charts. Another one is a long-awaited feature: support for XML maps. The component … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Excel, MHT, java, product release, themes

Read/Write MHTML Files and Apply Themes to Charts in Aspose.Cells for .NET 7.3.0

Posted on July 16, 2012 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for .NET 7.3.0. In this release, we have included some valuable new features, enhancements to existing features and resolution of the reported issues. One of the new features introduced in this release is the ability to open and save MHT files. We have also introduced a feature that lets you apply Microsoft Excel themes and colors to charts. Another one is a long awaited feature: support for XML maps.

Our … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Excel, MHTL files, product release, themes

Use RegEx Text Search in Excel Spreadsheets using Java

Posted on June 15, 2012 by Amjad Sahi

We’re pleased to share the announcement of Aspose.Cells for Java 7.2.2. We have added a new feature to search text in the cells with Regular Expressions. We have added some other useful enhancements around conditional formatting and OLE embedded in OOXML files. The ExportObjectListener for saving HTML files has been made available in the latest version. We have also fixed a few issues regarding Pivot Tables, data validation and charts.

To see a complete list of enhancements and fixes and … Continue Reading

Posted in Aspose.Cells Product Family | Tagged OLE, OOXML, java, pivot tables, product release, regex

Disable Compatibility Checker in Excel and Other Useful Enhancements using Aspose.Cells for .NET 7.2.2

Posted on June 14, 2012 by Amjad Sahi

We’re pleased to share the announcement of Aspose.Cells for .NET 7.2.2. We have added a new feature, disabling Microsoft Excel’s Compatibility Checker in this release. We have also added support for adding quotes around your data when saving to CSV format, as one of our customers asked us to. We have added some other useful enhancements around the Subtotals feature. The XML Map properties will now be retained when re-saving the template file. We have also improved the Formula Calculation … Continue Reading

Posted in Aspose.Cells Product Family | Tagged .NET, Excel, XMP map, calculation engine, compatibility checker, pivot tables, product release

Use Regular Expression for Searching String in Excel using Java

Posted on May 17, 2012 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.2.1. This month’s release provides support for applying custom formatting and styles to pivot tables. We have provided a new RegEx feature for when you’re searching for a string of a given pattern in the cells (of a worksheet). We have also made enhancements to chart rendering in ODS format. This release also sees enhancements that makes the Aspose.Cells’ generated file compatible with POI. There are some other fixes … Continue Reading

Posted in Aspose.Cells Product Family | Tagged java, pivot tables, product release, regular expression, searching