Search
Follow Us
Categories
- Success Stories(157)
Archives
Category Archive: Aspose.Cells Product Family
Disable Compatibility Checker in Excel Files using C#
Various versions of MS Excel are available and being used around the world. This makes it possible that the newer versions provide features that may not be available in the older ones. Therefore, MS Excel uses the compatibility checker to degrade the features which are not supported by an older format when saving the files. However, in certain cases, you have to disable the compatibility checker. In this article, you will learn how to disable the compatibility checker for MS Excel workbooks in C#.
How to Read Excel Files in C#
MS Excel files are largely used to keep tabular data in the form of worksheets. Often, the huge datasets are also maintained in Excel files. Therefore, you may come across the scenario where you need to read and fetch data from the worksheets in an Excel file. To achieve that, this article shows how to read an Excel file in C#. We will demonstrate how to read the whole Excel file or only a single worksheet programmatically.
Create or Edit Excel Files on Linux using Java
These days, spreadsheets are widely used to keep and share a large amount of tabular data. Also, you can perform various operations such as applying formulas, generating charts and graphs, sorting and filtering data, and so on. The spreadsheets automation has brough a revolution in various industries. The dynamic creation and manipulation of the spreadsheets have made the data handling quite easier. In order to perform spreadsheet manipulation programmatically, this article covers how to create Excel XLSX or XLS files from scratch on Linux using Java.
Convert JSON to CSV Programmatically using C#
JSON is an immensely used format to store structured data. In various cases, JSON files are used to transmit data between applications. Alongside, CSV is also used to store the data as comma separated values. In this article, you will learn how to import data from JSON files to CSV programmatically. Particularly, the article will cover how to convert JSON data to CSV using C#.
Convert JSON to Excel Worksheet in Python
MS Excel is a feature-rich program that lets you keep and organize data in tabular form. Moreover, it allows you to store the data in multiple worksheets. In addition to the data organization, you can perform sorting, graph plotting, mathematical computations and etc. JSON, on the other hand, is a widely used format to store and transmit the data in the form of key-value pairs. In certain cases, you may need to import data from JSON files to Excel worksheets programmatically. In accordance with that, this article covers how to convert JSON data to Excel XLSX/XLS using Python.
Posted in Aspose.Cells Product Family Tagged JSON to Excel Python, JSON to XLS Python, JSON to XLSX Python
Import Data from JSON to Excel on Linux
Import Data from JSON to Excel on Linux using .NET
MS Excel is a rich spreadsheet manipulation software that allows you to organize the data in the form of worksheets and workbooks. Alongside, it provides features such as data sorting, graph plotting, mathematical computations and etc. On the other hand, JSON is a popular format to store structured data. In certain cases, JSON data needs to be converted to Excel worksheets. For such cases, this article shows how to import data from JSON files to Excel worksheets on Linux.
Posted in Aspose.Cells Product Family Tagged JSON to Excel Linux, JSON to XLS Linux, JSON to XLSX Linux
Convert JSON Data to CSV using Node.js
JSON files are widely used to transmit data between different applications. CSV, on the other hand, is also a commonly used format to store the data in a comma separated format. In certain cases, you may need to import data from JSON files to CSV. For such cases, this article covers how to convert JSON data to CSV programmatically using Node.js.
Convert JSON Data to CSV using Python
JSON is a well-known and widely used format to keep and share structured data. Often, it is used to transmit data between different types of applications. CSV, on the other hand, is also used to store the data in a comma separated format. In certain cases, you may need to import data from JSON files to CSV. Therefore, in this article, you will learn how to convert JSON data to CSV programmatically using Python.
Add Comments in Excel Worksheets using C++
Microsoft Excel provides the option to add comments in Excel files. There can be several reasons for adding comments, such as explaining a formula or adding contextual information that might be useful to the reader. Comments may also be used to suggest edits in the worksheet. Furthermore, you can set the font size, height, width, etc., of the comments. In this article, you will learn how to add comments to Excel worksheets programmatically using C++.