Author Archives: Amjad Sahi

Print a Range of Excel Sheets to PDF using Aspose.Cells for Android 3.0.0

Posted on December 24, 2013 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Android 3.0.0. In this release, you can print a desired number of pages generated in Microsoft Excel to PDF. Aspose.Cells allows you to specify how many pages are generated when converting an Excel spreadsheet to PDF file format. The following sample code illustrates on how to limit the number of pages in the output PDF file that is generated from an Excel template file:

String sdCardPath = Environment.getExternalStorageDirectory().getPath()+ File.separator;

Posted in Aspose.Cells Product Family | Tagged Calculate Excel formulas, Chart to Image, Excel Files, Excel to PDF, Limit the number of pages generated, OOXML API, Sheet to Image, export Excel workbooks to PDF, render MS Excel file formats, render images files from Charts, rendering Charts, retrieve External Data Sources Details

Retrieve External Data Source Details and Limit the Number of Pages Generated in PDF with Aspose.Cells for Java 7.7.0

Posted on December 20, 2013 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.7.0. In this release, we have added a feature that lets you retrieve external data source details. Sometimes, you may want to retrieve details from external data sources, for example if you want to read the SQL connection data. This may include any or all type of data that is required to establish a connection with an SQL Server, such as the server URL, user name, underlying table name, … Continue Reading

C# Excel to PDF – Fit All Worksheet Columns onto Single PDF Page

Posted on December 18, 2013 by Amjad Sahi

Aspose.Cells for .NET 7.7.0 has been released. This new release supports fitting all worksheet columns on single PDF page. This is a useful feature when you want to generate a PDF file that fits all columns on a worksheet onto a single page. We provide PdfSaveOptions.AllColumnsInOnePagePerSheet property which performs complex calculations, such as the height and width of the resultant PDF page to fit all the columns in.

We also provide a feature for detecting file format type and … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Calculate Excel formulas, Embed Ole Objects, Encryption, Excel Files, Fit all worksheet columns in one PDF page, Smart Markers, advanced conditional formatting, export Excel workbooks to PDF, generate password protected Excel files, hide/unhide rows and columns, 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

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

Posted in Aspose.Cells Product Family | Tagged Dom4j Library, OSGi environment support, Remove Dom4j Library Dependency, better chart manipulation, better license settings, convert Excel spreadsheet to PDF, enhanced XML parser, reading Excel files, render Excel spreadsheet to image, writing to Excel files

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

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