En

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.
April 28, 2021 · 2 min · Usman Aziz

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.
April 26, 2021 · 3 min · Usman Aziz

Split Text to Columns in Excel using C#

Text to columns feature in MS Excel allows you to split text in a column into multiple columns. You can split the text on a blank space, a comma, or any other character. In order to automate the feature, this article covers how to split text to columns in Excel files using C#.
April 24, 2021 · 2 min · Usman Aziz

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++.
April 23, 2021 · 4 min · Muhammad Ahmad

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.
April 21, 2021 · 3 min · Usman Aziz

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++.
April 16, 2021 · 4 min · Muhammad Ahmad

How to Insert and Delete Rows and Columns in Excel in 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.
April 13, 2021 · 3 min · Usman Aziz

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#.
April 6, 2021 · 2 min · Usman Aziz

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++.
April 6, 2021 · 3 min · Muhammad Ahmad

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.
April 2, 2021 · 3 min · Usman Aziz