In various cases, to process the Excel data in XLS or XLSX files, it is first converted into CSV format programmatically. In this article, we’ll show you how to convert an Excel file to CSV in C#.
Python: Adjust Row Height and Column Width in Excel
If you are a programmer, you may need to programmatically manipulate the height and width of rows and columns in Excel, respectively. Accordingly, in this article, you will learn how to adjust row height and column width in Excel in Python.
Copy Data from Excel Sheets in Python
While processing the Excel files programmatically, you may need to copy data from one Excel sheet to another. Also, you may have to copy data from a sheet in one Excel workbook to another. To deal with such cases, this article shows how to copy data from Excel sheets in Python. We will explicitly cover copying sheets’ data within an Excel file or from one file to another in Python.
Password-Protect and Unprotect Excel Files in Python
MS Excel provides a quick and easy way to store small as well as large-sized data in the form of rows and columns. In addition, it lets you perform various other operations such as data formatting, computations, data analysis, graphs and charts, and so on. Since data is worth being protected, MS Excel allows you to password-protect the Excel files. In this article, you will learn how to password-protect Excel files in Python.
Create Charts in Excel Files using Python
Excel charts are commonly used to visually represent and depict the data in the spreadsheets. You can create a variety of charts in Excel, such as, line, bar, pie, doughnut, pyramid, bubble, etc. In this article, you will learn how to create charts in Excel files in Python. We will create a few charts to demonstrate how easy it is for you to programmatically create Excel charts in Python.
Create Pivot Tables in Excel using Python
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 and you want to get their total grouped by the customers or products. The pivot tables come into play in such cases. In this article, you will learn how to deal with pivot tables in Excel in Python. Particularly, you will come to know how to create a pivot table in Excel in Python. Furthermore, we will demonstrate how to format data in the Excel pivot tables programmatically.
Convert Word to JSON in C#
Word to JSON conversion could be required in various cases when you need to export data in a Word document to JSON format programmatically. This article demonstrates how to easily convert the text in a Word document to JSON format from within your C# applications. You will also learn how to convert protected Word documents to JSON programmatically. So let’s proceed to convert Word to JSON in C#.
Steps to Convert Word to JSON in C# C# Library to Convert Word to JSON - Free Download Convert Word to JSON in C# Convert Protected Word to JSON in C# How to Convert Word to JSON in C# For Word document to JSON conversion, we need to perform the following steps:
Add or Delete Rows and Columns in Excel in C#
Excel files are widely used to create and manipulate spreadsheets within different applications programmatically. While processing a spreadsheet, you may need to add new rows and columns or delete the existing ones from the worksheets. To achieve that, this article shows how to add or delete rows and columns in Excel in C#.
Convert TXT to XML in Java
TXT files provide a convenient way to note down the textual data quickly and easily. On the other hand, XML files are commonly used to store and transport the data within or between the applications. In certain cases, you need to export TXT file’s data to XML format programmatically from within your Java applications. To achieve that, this article shows how to convert a TXT file to XML in Java.
Convert Excel File to JSON in C#
JSON is a popular format to exchange data within or between the applications. The lightweight JSON files make it possible for you to store and process small or large sized data easily. On the other hand, Excel worksheets are commonly used to keep and share the data. However, in certain cases, you may need to convert Excel data to JSON format from within .NET applications. To achieve that, this article covers how to convert Excel to JSON programmatically in C#.