Author Archives: Amjad Sahi

Optimize Memory Usage and Show Formulas instead of Values in Worksheet in Android

Posted on April 8, 2014 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Android 6.0.0 with new features, enhancements, and bug fixes. The new release supports optimizing memory usage when working with big Microsoft Excel files with large data sets. When building a workbook with large data sets, or reading a big template file, the total amount of RAM the process will use is always a concern. Aspose.Cells provides measures that can be adopted to cope with the challenge. Aspose.Cells provides some relevant … Continue Reading

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

Set Creation Time in Excel to PDF with Aspose.Cells for Java 8.0.0

Posted on April 1, 2014 by Amjad Sahi

We are pleased to announce the release of Aspose.Cells for Java 8.0.0 with new features, enhancements and bug fixes. This release supports optimizing memory usage when working with big Microsoft Excel files with large data sets. When building a workbook with large data sets, or reading a big template file, the total amount of RAM the process will use is always a concern.Aspose.Cells provides measures that can be adopted to cope with the challenge. Aspose.Cells provides some relevant options … Continue Reading

Export Excel Data Excluding Hidden Rows in C# using Aspose.Cells for .NET

Posted on March 31, 2014 by Amjad Sahi

Aspose.Cells for .NET 8.0.0 has been released. This new release supports optimizing memory use when working with big Microsoft Excel files that have large data sets. When building a workbook with a large data set, or reading a big template file, the total amount of RAM the process will take is always a concern. Aspose.Cells provide measures to cope with this challenge. Aspose.Cells provides relevant options and API calls to lower, reduce and optimize memory usage accordingly. For example, MemorySetting.MemoryPreference … Continue Reading

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

Optimized Report Designer and Other Enhancements in Aspose.Cells for Reporting Services 2.0.0

Posted on March 26, 2014 by Amjad Sahi

We are happy to announce the release of Aspose.Cells for Reporting Services 2.0.0. In this release, we have optimized the Aspose.Cells for Reporting Services Report Designer. You can now load Aspose.Cells for Reporting Services add-ins for Excel x64. You can configure Report Servers to store or cache the report server data. Aspose.Cells for Reporting Services Report Designer saves current accessed report server URL. When you open the report server manager dialog in the Aspose.Cells Report Designer again, the dialog form … Continue Reading

Posted in Aspose.Cells Product Family |

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