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.

Convert Excel Files to PDF in PHP

Excel spreadsheets are widely used to store and analyze data in the form of rows and columns. However, in various cases, you need to convert the Excel files to PDF before sharing them over the internet. In order to automate Excel to PDF conversion, this article shows how to convert Excel files to PDF programmatically using PHP. Furthermore, advanced options to customize the Excel to PDF conversion are also discussed.

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

Convert CSV to Excel or Excel to CSV in Node.js

CSV format is widely used to import or export large datasets from one application to another. However, in some cases, you may need to convert CSV files to Excel XLSX or XLS. Likewise, vice versa can also be required in certain scenarios. In accordance with that, this article covers how to convert CSV to Excel and Excel to CSV format programmatically in Node.js.

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

Create Pivot Tables in Excel using Java

Pivot tables in Excel spreadsheets are used to summarize the data in an interactive way. Suppose, you have the data of a number of invoices in a worksheet. In that case, you can use a pivot table to total the invoices grouped by the customers or products. In this article, you will learn how to deal with pivot tables in Excel programmatically. Particularly, you will come to know how to create a pivot table and generate a chart based on that pivot table in Java.

Posted in Aspose.Cells Product Family | Tagged , ,

Inserting and Deleting Rows and Columns in Excel using C++

MS Excel provides you with many features for working with Excel files. One of the basic operations that you can do is to insert or delete rows and columns. You might find yourself in situations where you need to insert or delete rows and columns while manipulating Excel files programmatically. In light of that, this article will teach you how to insert and delete rows and columns in Excel worksheets using C++.

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

Convert Excel Files to PDF in Android

In various cases, you may need to share the Excel files over the internet. To avoid tampering, it is a best practice to convert these files to PDF format before sharing. Accordingly, in this article, you will learn how to convert Excel XLSX or XLS files to PDF in Android apps. In addition, customization of Excel to PDF conversion will also be discussed.

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

Create Charts in Excel Spreadsheets using C++

Charts are an excellent tool for concisely showing data. Moreover, they represent the data visually, making it easier to consume large amounts of data. You might find charts to be helpful in situations where you need to show data such as the monthly budget comparison or product adoption rate. In light of that, this article will teach you how to create charts in Excel files using C++.

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

Insert and Delete Rows and Columns in Excel using Python

While working with spreadsheet manipulation, you may often need to insert or delete rows and columns within your worksheets. In accordance with that, this article covers how to manipulate rows and columns in worksheets programmatically. Particularly, you will learn how to insert or delete single or multiple rows and columns in an Excel worksheet using Python.

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

Protect VBA Macros in Excel using C#

VBA macros in Excel spreadsheets are used to automate different operations programmatically. For example, you can program a task that is to be done repeatedly, generate graphs using code, etc. However, the protection of VBA macros from unauthorized users is an important aspect. In order to handle this issue, this article covers how to protect VBA macros in Excel spreadsheets programmatically using C#.

Posted in Aspose.Cells Product Family | Tagged ,

Copy or Move Excel Worksheets using C++

Excel files are used for managing complex data such as department budgets or yearly sales reports. There might be situations where you have a ready-made template that you want to use for creating a report. For this, you can create a copy of the template worksheet. You might also need to organize the worksheets to demonstrate the flow of data. For such cases, you can rearrange the worksheets according to your requirements. In light of this, you will learn how to copy and move worksheets programmatically using C++.

Posted in Aspose.Cells Product Family | Tagged , ,

Convert Excel Files to PDF in Python

Nowadays, PDF has become a standard file format for exchanging documents. Various popular document formats are converted to PDF before they are shared over the Internet. Excel to PDF is one of the popular conversion scenarios in which worksheets are converted to read-only PDF pages. In accordance with that, this article covers how to convert Excel XLSX or XLS files to PDF using Python.

Posted in Aspose.Cells Product Family | Tagged , ,