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.

Read Encrypted Microsoft Excel 2013 Files and Apply Justify Distributed Alignment Setting in Aspose.Cells for Android 5.0.0

Posted on February 26, 2014 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Android 5.0.0 with new features, enhancements and bug fixes. This new release supports reading password protected Microsoft Excel 2013 files. We provide the Style.setJustifyDistributed() method so you can apply the justify distributed setting while applying text alignment settings on cells.

We also provide support for the B3 (13.9 x 19.7 inches) and Business Card (90 mm x 55 mm) PaperSizeType options.

We have added a number of enhancements and fixes … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Calculate Excel formulas, Encryption, Excel Files, advanced conditional formatting, export Excel workbooks to PDF, improved OOXML API, manipulate PivotTables, render MS Excel file formats, render images files from Charts, rendering Charts

Read Encrypted Microsoft Excel 2013 Files, Unhide Rows/Columns to their Original Height/Width and More in Aspose.Cells for Java 7.7.2

Posted on February 19, 2014 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.7.2 with new features, enhancements and bug fixes. This new release supports reading password protected Microsoft Excel 2013 files. We provide the Style.setJustifyDistributed() method so you can apply the justify distributed setting while applying text alignment settings on cells.

We also provide support for B3 (13.9 x 19.7 inches) and Business Card (90 mm x 55 mm) PaperSizeType.

We have enhanced the unhiding rows/columns feature in this release. … Continue Reading

Read Encrypted Microsoft Excel 2013 Files, Apply Justify Distributed Alignment Setting and Other Enhancements in Aspose.Cells for .NET 7.7.2

Posted on February 18, 2014 by Amjad Sahi

Aspose.Cells for .NET 7.7.2 has been released. This new release supports reading password protected Microsoft Excel 2013 files. We provide the Style.IsJustifyDistributed property so you can apply the justify distributed setting while applying text alignment settings on cells.

We also provide support for B3 (13.9 x 19.7 inches) and Business Card (90 mm x 55 mm) PaperSizeType. We have added the PaperB3 and PaperBusinessCard enumeration members to the PaperSizeType enumeration that can be used when setting page options.

Fixes

Find Cells Based on Formatting and Create Transparent Images of Worksheets in Aspose.Cells for Android 4.0.0

Posted on January 22, 2014 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Android 4.0.0. In this release, you can find cells with particular style or formatting. Aspose.Cells supports finding all cells that have a common style or formatting. Aspose.Cells provides the FindOptions.setStyle() method which you can use to specify the style to search cells for.

You can now create transparent images of Microsoft Excel worksheet. Sometimes, you need to generate an image of your worksheet as a transparent image. For example, you … Continue Reading

Posted in Aspose.Cells Product Family |

Read Large Excel Files with LightCells API using Java

Posted on January 21, 2014 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 7.7.1 with certain new features, enhancements, and other bug fixes. This new release supports reading large Excel files with LightCells API. This is a useful feature. Sometimes you need to read data from a huge Microsoft Excel workbook with millions of records and you are always worried about the performance. You want it to take less time and memory to process big files. The LightCells API is useful … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Excel Files, LighCells API, conditional formatting, export Excel workbooks to PDF, improved OOXML API, manipulate PivotTables, render MS Excel file formats, render images files from Charts, rendering Charts

Read Large Excel Files with LightCells API and Create Transparent Images from Worksheets in Aspose.Cells for .NET 7.7.1

Posted on January 20, 2014 by Amjad Sahi

Aspose.Cells for .NET 7.7.1 has been released with over 80 useful new features, enhancements and bug fixes. This new release supports reading large Excel files with LightCells API. This is a useful feature. Sometimes you need to read data from a huge Microsoft Excel workbook with millions of records and you always worry about the performance. You want it to take less time and memory to process big files. The LightCells API is useful in that scenario: to read … Continue Reading

Posted in Aspose.Cells Product Family | Tagged Convert Excel worksheet to transparent image, Smart Markers, manipulate PivotTables, render images files from Charts, rendering Charts

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

Ignite Technologies used Aspose.Cells for .NET within Right90 for intuitive Sales Forecasting

Posted on December 22, 2013 by Right90

About Ignite Technologies

As the leader in Enterprise Performance Acceleration, its powerful enterprise software platform helps organizations grow revenue, optimize expense and accelerate transformation through a model where every customer has access to every product in our portfolio.

Right90 Sales Forecasting is one of the leading products which helps manufacturing companies see and manage changes to their sales forecasts. Right90 is intuitive enough for anyone to use and provides actionable insight to help managers stay alert to changes, be confident … Continue Reading

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

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