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.

Create Excel Files in Node.js Applications – A Complete Guide

Posted on August 5, 2020 by Usman Aziz

In this article, I’ll show you how to implement Excel automation and create Excel files in Node.js applications programmatically. Spreadsheets have made it possible to store a huge amount of data in the form of rows, columns, and sheets. In … Continue reading →

Merge or Unmerge Cells in Excel Worksheet with C#

Posted on June 24, 2020 by Farhan Raza

In this article, we will learn about merging and unmerging of cells in Excel sheet. Generally, merging cells refers to one or more cells joined together to form a large cell. However, the adjacent cells can be merged vertically or … Continue reading →

Posted in Aspose.Cells Product Family | Tagged Split cells, merge cells, merge cells in excel, merge cells in named range, merge range of cells, unmerge cells, unmerge cells in excel | Leave a comment

Create MS Excel Spreadsheets in C++ without MS Office – A Comprehensive Guide

Posted on May 15, 2020 by Usman Aziz

Previously, I have written a post on how to implement Excel automation features and create Excel XLS/XLSX files from scratch using C#. Today, I’ll show you how to create Excel workbooks, insert data to Excel worksheets, calculate formulas, and create … Continue reading →

Posted in Aspose.Cells Product Family | Tagged Add tables in Excel using cpp, Calculate formulas in Excel in CPP, Create Excel XLSX files using Cpp, Create XLSX files using Cpp, Create charts in Excel using CPP | Leave a comment

Import Data from JSON to Excel Worksheet in C# .NET

Posted on April 3, 2020 by Usman Aziz

MS Excel provides a variety of features to keep and organize tabular data in the form of worksheets. Along with data organization, you can perform various operations such as data sorting, graph plotting, mathematical computations and etc. JSON, on the … Continue reading →

Posted in Aspose.Cells Product Family | Tagged Convert JSON to Excel CSharp, Import Data from JSON to Excel, JSON to Excel CSharp | Leave a comment

Find and Replace Text in Excel Spreadsheets using C#

Posted on February 15, 2020 by Usman Aziz

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 … Continue reading →

Posted in Aspose.Cells Product Family | Tagged Find and Replace text in Excel, Replace text in Excel with Regex, find and replace text with regex in Excel | Leave a comment

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

Posted on January 31, 2020 by Usman Aziz

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 … Continue reading →

Posted in Aspose.Cells Product Family | Tagged ASP.NET MVC Excel Viewer, Display Excel Files in ASP.NET, Display Excel Sheets in ASP.NET Web Page, Excel Viewer, Excel Viewer in ASP.NET MVC, Excel file viewer | Leave a comment

Create MS Excel Files Programmatically in C# without MS Office

Posted on January 21, 2020 by Usman Aziz

In this article, you will learn how to create Excel XLS/XLSX files programmatically in C# without installing MS Office. Spreadsheets nowadays have become an essential part of keeping, organizing and analyzing the data. Spreadsheets, such as MS Excel, are capable … Continue reading →

Posted in Aspose.Cells Product Family | Tagged Excel Automation API, Excel Library for .NET, create charts and graphs in excel, create excel files in csharp .net, create excel files programmatically, create excel files without ms office, create tables in excel files in C# .net | Leave a comment

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

Posted on January 10, 2020 by Usman Aziz

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 … Continue reading →

Posted in Aspose.Cells Product Family | Tagged Aspose.Cells for .NET, create excel pivot table in c#, create excel pivot table programmatically, create pivot table excel, hide data in pivot table, how to create pivot table programmatically, pivot tables in excel in c#, sort pivot table excel | Leave a comment

Sort and Hide Pivot Table Data in Excel using Java

Posted on December 17, 2019 by Ahsan Iqbal

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 … Continue reading →

Posted in Aspose.Cells Product Family | Leave a comment

Convert Excel XLS and XLSX to PDF in C#

Posted on November 29, 2019 by Muhammadahmad

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 … Continue reading →

Posted in Aspose.Cells Product Family | Tagged Convert Excel Files, Convert Excel to PDF, XLS to PDF, XLS to PDF C#, XLSX to PDF, XLSX to PDF C#, c# excel to pdf, c# xlsx to pdf, excel to pdf c# | Leave a comment