In this article, you will learn how to implement Excel automation features from within your Android applications. After reading this article, you will be able to create Excel XLSX or XLS file from scratch in your Android app programmatically. In addition, this article will cover how to update an existing Excel file, generate charts, apply formulas, and add pivot tables in Excel worksheets.
Copy Rows and Columns in Excel using Java
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 Java.
Add Comments in Excel Worksheets using Python
MS Excel supports adding comments to the cells in the worksheets to provide additional information. In various cases, comments are used to explain a formula. Moreover, MS Excel allows you to define the font size, height, width, etc. of the comments. In this article, you will learn how to add comments to the Excel worksheets programmatically using Python.
Create Excel Files from Scratch using PHP
Spreadsheets have become an essential part of keeping, organizing, and analyzing the data. Since automated solutions are more in business these days, the trend of creating and manipulating Excel documents (XLS/XLSX) has emerged and growing at a huge pace. In accordance with the above-mentioned scenario, this article covers how to create Excel XLSX or XLS files in PHP based web applications.
Working With Pivot Tables in Excel Files using C++
Pivot tables rearrange data to represent it in a meaningful way. They provide different sorting options and provide sums, averages, or other statistics by grouping data together. It is an essential tool for data analysis and is a fundamental part of MS Excel. You might find yourself in scenarios where you need to create and manipulate pivot tables programmatically. To that end, this article will teach you how to work with pivot tables in Excel files using C++.
Add or Modify VBA Macros in Excel Files using Java
VBA is a programming language used to automate various operations in MS Excel files. Particularly, VBA macros are user-defined codes that let you speed up the spreadsheet manipulation tasks. In this article, you will learn how to work with VBA macros in Excel files programmatically. Ultimately, you will be able to add and modify VBA macros in Excel using Java.
Add Watermark to Excel Worksheets using Java
Watermarks are used to define the ownership of the copyrighted content and protect the Excel files from theft or being used illegally. In this article, you will learn how to add watermarks to Excel sheets programmatically. More precisely, the article will cover how to add watermark to Excel worksheets using Java.
Find and Replace Text in Excel using Python
Excel spreadsheets often contain thousands of records in multiple sheets. In such cases, finding and replacing a particular text manually could be a hectic task. Therefore, MS Excel provides the find and replace option to update the desired text with a single click. In this article, you will learn how to find and replace text in Excel files programmatically in Python.
Encrypt and Decrypt Excel Files in Python
Security and privacy have always been important aspects of safeguarding data. Since Excel files are widely used to store data, safety is ensured to avoid tampering and unauthorized access. In accordance with that, this article covers how to encrypt and decrypt Excel files in Python.
Convert Excel Files to Image in Python
In various cases, Excel spreadsheets are required to be embedded in the web or desktop applications. One of the solutions in such cases is the conversion of Excel worksheets to image formats. In this article, you will learn how to convert Excel XLSX or XLS to PNG, JPEG, SVG, or other images in Python.