Search
Follow Us
Categories
- Success Stories(157)
Archives
Category Archive: Aspose.Cells Product Family
Add Watermark to Excel Worksheets in Python
Watermarking is one of the common ways of protecting documents from unauthorized usage. More often, a watermark defines the ownership of the copyrighted content. In accordance with that, this article covers how to perform watermarking in Excel files programmatically. Particularly, you will learn how to add watermark to an Excel worksheet using Python.
Convert CSV to Excel or Excel to CSV in Node.js
CSV format is widely used to import or export large datasets from one application to another. However, in some cases, you may need to convert CSV files to Excel XLSX or XLS. Likewise, vice versa can also be required in certain scenarios. In accordance with that, this article covers how to convert CSV to Excel and Excel to CSV format programmatically in Node.js.
Create Pivot Tables in Excel using Java
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 in a worksheet. In that case, you can use a pivot table to total the invoices grouped by the customers or products. In this article, you will learn how to deal with pivot tables in Excel programmatically. Particularly, you will come to know how to create a pivot table and generate a chart based on that pivot table in Java.
Split Text to Columns in Excel using C#
Text to columns feature in MS Excel allows you to split text in a column into multiple columns. You can split the text on a blank space, a comma, or any other character. In order to automate the feature, this article covers how to split text to columns in Excel files using C#.
Inserting and Deleting Rows and Columns in Excel using C++
MS Excel provides you with many features for working with Excel files. One of the basic operations that you can do is to insert or delete rows and columns. You might find yourself in situations where you need to insert or delete rows and columns while manipulating Excel files programmatically. In light of that, this article will teach you how to insert and delete rows and columns in Excel worksheets using C++.
Convert Excel Files to PDF in Android
In various cases, you may need to share the Excel files over the internet. To avoid tampering, it is a best practice to convert these files to PDF format before sharing. Accordingly, in this article, you will learn how to convert Excel XLSX or XLS files to PDF in Android apps. In addition, customization of Excel to PDF conversion will also be discussed.
Create Charts in Excel Spreadsheets using C++
Charts are an excellent tool for concisely showing data. Moreover, they represent the data visually, making it easier to consume large amounts of data. You might find charts to be helpful in situations where you need to show data such as the monthly budget comparison or product adoption rate. In light of that, this article will teach you how to create charts in Excel files using C++.
How to Insert and Delete Rows and Columns in Excel in Python
While working with spreadsheet manipulation, you may often need to insert or delete rows and columns within your worksheets. In accordance with that, this article covers how to manipulate rows and columns in worksheets programmatically. Particularly, you will learn how to insert or delete single or multiple rows and columns in an Excel worksheet using Python.
Protect VBA Macros in Excel using C#
VBA macros in Excel spreadsheets are used to automate different operations programmatically. For example, you can program a task that is to be done repeatedly, generate graphs using code, etc. However, the protection of VBA macros from unauthorized users is an important aspect. In order to handle this issue, this article covers how to protect VBA macros in Excel spreadsheets programmatically using C#.
Copy or Move Excel Worksheets using C++
Excel files are used for managing complex data such as department budgets or yearly sales reports. There might be situations where you have a ready-made template that you want to use for creating a report. For this, you can create a copy of the template worksheet. You might also need to organize the worksheets to demonstrate the flow of data. For such cases, you can rearrange the worksheets according to your requirements. In light of this, you will learn how to copy and move worksheets programmatically using C++.