MS Excel provides a wide range of features to keep and organize data in the form of worksheets contained by workbooks. In addition to the data organization, it lets you perform sorting, data visualization, mathematical computations and etc. In certain cases, you receive the data in JSON format and need to import it to Excel worksheets programmatically. For such cases, this article covers how to convert JSON data to Excel XLSX/XLS in Node.js.
Create, Read, and Edit Excel Spreadsheets in ASP.NET MVC
In this article, you will learn **how to create, read, and edit Excel spreadsheets in an ASP.NET MVC application. For this, we will create a spreadsheet application consisting of a feature-rich grid control to display and edit Excel files, as shown below.
Convert JSON to CSV Programmatically using Java
JSON files are widely used to store and transmit structured data between applications. On the other hand, CSV is also used to store the data, such as datasets, as comma-separated values. In this article, you will learn how to export data from JSON files to CSV programmatically. More specifically, the article will cover how to convert JSON data to CSV using Java.
Copy Rows and Columns in Excel using C#
In certain cases, you need to copy rows and columns in an Excel file without copying the entire worksheet. To perform this operation programmatically, this article covers how to copy rows or columns in an Excel worksheet using C#.
Add Comments in Excel Worksheets using C#
Comments in Excel worksheets are used to add additional information or to explain a formula. These comments can be formatted as well by defining the font size, height, width, etc. In this article, you will learn how to add comments to the Excel worksheets using C#. Furthermore, the article will also demonstrate how to apply formatting and add images to the comments programmatically.
Copy or Move Worksheets in Excel Files using Java
You may often need to copy worksheets within an Excel workbook or from one workbook to another. Also, changing the position of the worksheets is also required in certain cases. In order to perform the above-mentioned tasks programmatically, this article shows how to copy worksheets within Excel workbooks using Java. Furthermore, it also covers how to move a worksheet in an Excel workbook.
Add Watermark to Excel Worksheets using C#
Watermarks are one of the ways to protect Excel files from being used illegally. Often, a watermark defines the ownership of the copyrighted content. In this article, you will learn about adding watermarks to Excel files programmatically. Particularly, the article will cover how to add watermark to Excel worksheets using C#.
Split Text to Multiple Columns in Excel using Python
In various cases, you may need to split text in a column into multiple columns in an Excel worksheet. The splitting criteria could be a blank space, a comma, a special character, etc. In this article, you will learn how to split a text into columns in an Excel worksheet using Python. It automates the Text to Columns feature of MS Excel.
Create Charts in Excel using Java
Charts and graphs are used to summarize and visually represent the data. They give an insight that can further be used to make the decisions. Charts are considered to be an integral part of Excel spreadsheets and are widely used in various applications. In this article, you will learn how to generate charts programmatically from the data provided in the Excel worksheets. Particularly, the article covers how to create different types of charts in Excel using Java.
Convert JSON to PDF using C#
In various cases, you may need to convert the JSON files to PDF for sharing, printing, or other purposes. To achieve it programmatically, this article covers how to convert JSON to PDF using C#.