Search
Follow Us
Categories
- Success Stories(157)
Archives
Category Archive: Aspose.Cells Product Family
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#.
Create Excel File in Android Programmatically
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.
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.
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.
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.