Tag Archives: Calculate Excel formulas

Calculate Excel Formulas and Implement Custom or User Defined Functions in C++

create user defined function in excel

Aspose Team is pleased to announce the release of Aspose.Cells for C++ 17.02.0. This release includes some new features and enhancements that further improve the overall feature set of the API. Please check the release notes in order to get an idea about what is new and what has been enhanced with this revision of Aspose.Cells for C++. If you are planning to upgrade the API from any previous version, we strongly suggest you to check the Public API Changes section … Continue Reading

Posted in Aspose.Cells Product Family | Tagged , , , ,

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

Aspose.Cells for Android logo

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 , , , , , ,

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

Aspose.Cells for Java logo

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

Posted in Aspose.Cells Product Family | Tagged , , , , , ,

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

Aspose.Cells for .NET logo

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 , , , , , , ,

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

Aspose.Cells for Android logoWe 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 , , , , , , , , ,

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

Aspose.Cells for Java logoWe 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

Posted in Aspose.Cells Product Family | Tagged , , , , , , , , ,

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

Aspose.Cells for .NET logoAspose.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

Continue Reading
Posted in Aspose.Cells Product Family | Tagged , , , , , , , , ,

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

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; 
Continue Reading
Posted in Aspose.Cells Product Family | Tagged , , , , , , , , , , ,

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

Aspose.Cells for Java logoWe 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

Posted in Aspose.Cells Product Family | Tagged , , , , , , , , , , ,

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

Aspose.Cells for .NET logo

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 , , , , , , , , , , , , , , , ,