Category Archive: Aspose.Cells Product Family

Official blog of Aspose.Cells for .NET, Java & Reporting Services with news of newly supported features, hot fixes, technical articles, tips and videos.

Export Data from Excel to DataTables in C#

MS Excel spreadsheets are widely used to keep the small, medium, or large-sized data. In various cases, spreadsheets act as a database to store the application data. There could be situations when you need to read the data stored in the Excel files from within your web or desktop applications. For such cases, this article covers how to export data from Excel worksheets to DataTables in C#.

Posted in Aspose.Cells Product Family | Tagged , ,

Convert Excel Files to PDF using C++

PDF format is widely used to exchange documents among the stakeholders. In various cases, the documents are converted to PDF format before they are shared. Thus, PDF is known to be a standard file format in such cases. In this article, we will target Excel to PDF conversion for C++ applications. Particularly, you will learn how to convert Excel XLSX or XLS workbooks to PDF files using C++.

Posted in Aspose.Cells Product Family | Tagged , ,

Encrypt and Decrypt Excel Files using C#

MS Excel provides an encryption mechanism to protect the data in the spreadsheets from unauthorized users. Along with applying encryption, you can specify the password that is required to open the Excel files. This article covers how to perform the encryption of Excel files from within .NET applications. Particularly, you will learn how to encrypt and decrypt the Excel files using C#.

Posted in Aspose.Cells Product Family | Tagged , ,

Protect and Unprotect Excel Files in Java

Excel files are used to store small as well as large-sized data in the form of rows and columns. Along with data storage, you can perform other operations such as computations and data analysis using graphs and charts. Since data is worth being protected, MS Excel allows you to protect the Excel files. This article covers how to automate the protection of MS Excel files programmatically. Particularly, you will learn how to protect and unprotect Excel files using Java.

Posted in Aspose.Cells Product Family | Tagged , , ,

Convert Excel Files to Images using C#

In various scenarios, you may want to convert Excel spreadsheets to high-resolution images, for example, when you need to embed the spreadsheet content within your web or desktop applications. In this article, you will learn how to convert Excel files to image formats using C# from within the .NET applications.

Posted in Aspose.Cells Product Family | Tagged

Convert Excel Files to HTML using Java

Excel spreadsheets allow you to store and well organize the data in tabular form. You can perform computations as well as generate different types of graphs and charts in order to analyze the data. However, in various scenarios, you may need to carry out Excel to HTML conversion to convert worksheets to HTML pages. For example, when embedding the content of the spreadsheets into web pages. In accordance with that, this article aims to cover how to convert Excel XLSX files to HTML programmatically using Java.

Posted in Aspose.Cells Product Family | Tagged , ,

Add or Modify VBA Macros in Excel Files using C#

VBA (Visual Basic for Applications) is a programming language that is used in MS Excel files in order to automate the spreadsheets related operations. VBA macros are used to write user-defined functions that let you speed up the tasks you have to perform manually. In this article, you will learn how to work with VBA macros in MS Excel files programmatically. By the end of this article, you will be able to extract, add, and modify VBA macros in Excel workbooks using C#.

Posted in Aspose.Cells Product Family | Tagged , ,

Protect and Unprotect Excel Files using C#

MS Excel provides convenient ways of storing and managing small or large amounts of data. Workbooks are widely used to maintain the datasets, analyze the data, perform activities related to finance or human resources, and etc. With the advancement in technology, the ways of getting unauthorized access to data have also been increased. Therefore, MS Excel lets you protect the workbooks using the password. In this article, you will learn how to automate the spreadsheet protection features and protect or unprotect Excel files programmatically using C#.

Posted in Aspose.Cells Product Family | Tagged , ,

Find and Replace Text in Excel Spreadsheets using Java

In this post, you will learn how to find and replace text in MS Excel spreadsheets programmatically in Java. In various scenarios, MS Excel spreadsheets consist of a huge amount of data that may spread in multiple sheets. For such cases, the find and replace option could help you minimize the efforts required to update all the occurrences of a particular piece of text. Let's check out how to automate this option when dealing with a large number of spreadsheets from within the Java applications.

Posted in Aspose.Cells Product Family | Tagged , ,

Convert JSON to CSV and CSV to JSON using C# or VB.NET

JSON is abbreviated for Javascript Object Notation, which represents the data as key-value pairs. You can convert JSON to CSV and CSV to JSON format as per your requirements. Both of these file formats are suitable for storing and transmitting data.

Posted in Aspose.Cells Product Family | Tagged , , , , , , ,