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.

Find and Replace Text in Excel Spreadsheets using C#

The Excel spreadsheets have minimized the efforts required to keep the huge data and perform complex calculations automatically. Excel automation was the next big achievement that has streamlined the way of creating Excel spreadsheets and performing a variety of operations on the data programmatically.

Finding and replacing text in Excel is one of the frequently performed operations in Excel automation. Therefore, in this article, I will show you how to find and replace text in large Excel spreadsheets programmatically in … Continue Reading

Posted in Aspose.Cells Product Family | Tagged , ,

ASP.NET Excel Viewer – View Excel Files in ASP.NET MVC using C#

C# ASP.NET Excel Viewer

Do you want to display Microsoft Excel worksheets within your web application? Are you looking for an ASP.NET MVC Excel Viewer? If yes, you have landed in an absolutely correct place. In this blog, you will learn how to create an Excel Viewer and display Excel worksheets in ASP.NET MVC applications using C#. After spending a few minutes and following some simple steps you will have your own Excel (XLS or XLSX) Viewer up and running. … Continue Reading

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

Create MS Excel Files Programmatically in C# without MS Office

In this article, you will learn how to create Excel XLS/XLSX files programmatically in C# without installing MS Office.

Create Excel File in C# API

Spreadsheets nowadays have become an essential part of keeping, organizing and analyzing the data. Spreadsheets, such as MS Excel, are capable of doing calculations and sorting, generating graphs or charts, creating budgets, and performing many other accounting or data analysis tasks. Since automated solutions are more in business these days, the trend of creating and manipulating Excel documents (XLS/XLSX) has … Continue Reading

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

Create Pivot Tables in Excel and Sort or Hide Data using C# .NET

C# Library to Create and Sort PivotTable in Excel

In this article, you’ll learn how to create Pivot Table in Excel and sort or hide the Pivot Table data or items programmatically in C# using Aspose.Cells for .NET – .NET API to create and manipulate Excel spreadsheets without requiring Microsoft Excel.

Pivot Tables in Excel

Things have gone digital and automated solutions for the generation and manipulation of Excel spreadsheets are widely used. The Pivot Tables in Excel are extensively used to summarize and analyze the data. Whereas sorting … Continue Reading

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

Sort and Hide Pivot Table Data in Excel using Java

This image has an empty alt attribute; its file name is aspose_cells-for-java-e1558954178996.jpg

Aspose.Cells for Java v19.11 is released which contains many new features and upgrades. Pivot tables processing is enhanced by providing the sorting and hiding data based upon some criteria to get compact information for reporting and presentations. Reading and writing to tables with QueryTable as a data source is available now. This is not the end of this release but the beginning of a long list of new features like modifying the existing validation by adding CellArea, retrieving OData connection … Continue Reading

Posted in Aspose.Cells Product Family |

Convert Excel XLS and XLSX to PDF in C#

Excel to PDF C#

This article demonstrates how to convert Excel (XLS, XLSX) files to PDF format using C#. The Portable Document Format (PDF) format developed by Adobe is used as a standard by many organizations to share and store documents. Exporting documents to PDF is a common scenario for many applications.

C# API

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

Track conversion progress in image rendering with Aspose.Cells for .NET 19.10

Aspose.Cells for .NET logo Conversion of Excel spreadsheets to image formats always remains a hot topic. Sometimes, you claim the process takes too long. Others complain that the process gets stuck for larger files and they need to stop the process. Aspose.Cells has now included a useful feature where you can track the conversion progress in Sheet to image rendering in the way you want, you may notice which pages are being rendered in the process at the moment. Moreover, you can also convert … Continue Reading

Posted in Aspose.Cells Product Family |

Java Excel to TIFF – Track Conversion Progress with Aspose.Cells for Java

This image has an empty alt attribute; its file name is aspose_cells-for-java-e1558954178996.jpg

We are happy to share the release of the latest version of Aspose.Cells for Java v19.10 having a long-awaited feature of tracking the conversion progress of huge files. This is not the end of features in this release as it also supports custom data sorting for the specific area in PivotTable report and provides Workbook.ContentTypeProperties.Add method to add custom ContentTypeProperties to an excel file. Many other enhancements and bug resolutions are there in this release. You may get complete details of enhancements, … Continue Reading

Posted in Aspose.Cells Product Family |

Adjust Excel Workbook Compression Level using Java

This image has an empty alt attribute; its file name is aspose_cells-for-java-e1558954178996.jpg

Its great pleasure to share that we have achieved another milestone by publishing new release Aspose.Cells for Java 19.9 that will enable developers to adjust the workbook compression level. Don’t worry, this is not the only feature as there are many other enhancements as well including the facility to print multiple copies of a workbook and support for reading and rendering Control of ODS files.  Details of all the new features, enhancements and bugs resolution can be seen in the … Continue Reading

Posted in Aspose.Cells Product Family |

Adjust Excel Workbook Compression Level using C#

Guys, in the blog you will learn how to adjust the workbook compression level. You can also avail the useful feature to print multiple copies of a workbook and support for reading and rendering controls of ODS file. We suggest you to have a look at the release notes to get the complete list of features, enhancements and other fixes which are part of this new release. Let’s not wait another moment to review the release notes.  To get … Continue Reading

Posted in Aspose.Cells Product Family |