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.

Read Data in Excel Files using Python

MS Excel provides a convenient way of keeping and sharing data in the form of rows and columns. More often, Excel files are used to store huge datasets having hundreds and thousands of records. While working with Excel files in Python, you may need to read data from each cell in the worksheets. To achieve that, this article shows how to read an Excel file in Python. You will learn how to read data from a single worksheet or all the worksheets in an Excel workbook.

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

Disable Compatibility Checker in Excel in Python

MS Excel compatibility checker ensures that a file in an older format does not use the features provided by the newer Excel version. Thus, people using older versions of Excel do not face compatibility issues. While manipulating Excel files, you may need to disable the compatibility checker dynamically. To achieve it, this article shows how to enable or disable the compatibility checker for MS Excel workbooks in Python.

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

How to Read Excel Files in Java

MS Excel files are largely used to keep tabular data in the form of worksheets. Often, the huge datasets are also maintained in Excel files. Therefore, you may come across the scenario where you need to read and fetch data from the worksheets in an Excel file. To achieve that, this article shows how to read an Excel file in Java. We will demonstrate how to read the whole Excel file or only a single worksheet programmatically.

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

Disable Compatibility Checker in Excel Files using Java

Various versions of MS Excel are available and being used around the world. This makes it possible that the newer versions provide features that may not be available in the older ones. Therefore, MS Excel uses compatibility checker to degrade the features which are not supported by an older format when saving the files. While manipulating Excel files, you may need to disable the compatibility checker dynamically. To achieve it, this article shows how to disable the compatibility checker for MS Excel workbooks in Java.

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

Convert Excel Files to PDF on Linux using Java

In various cases, you need to convert the Excel spreadsheets to PDF format, for example, to print or share the worksheets. In this article, you'll learn how to convert Excel files to PDF format on the Linux platform using Java. Furthermore, you'll come to know about different options to customize the Excel to PDF conversion.

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

Linux: CSV to Excel or Excel to CSV using .NET

CSV files are widely used to store the data in the form of comma-separated values. However, in certain cases, you need to export data from CSV files to Excel spreadsheets or vice versa. For such cases, this article covers how to export data from CSV to Excel and Excel to CSV on Linux.

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

Create or Edit Excel Files on Linux using .NET

The emergence of automated solutions these days has made spreadsheet automation popular in various industries. The spreadsheet documents are created and manipulated programmatically from within the web or desktop solutions. Accordingly, this article covers how to create Excel XLSX and XLS files on the Linux platform using .NET.

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

Export Excel Files to Stream using C#

In various cases, you may need to export or save the Excel XLSX/XLS files to memory streams. For such cases, this article covers how to export Excel files to FileStream objects dynamically using C#. Moreover, you will learn how to load an Excel file from stream.

Posted in Aspose.Cells Product Family | Tagged , ,

Convert Excel XLSX and XLS to SVG using C#

Excel files are widely used to keep and organize small as well as large sized data. Moreover, you can perform various operations on the data stored in Excel worksheets. In certain cases, you may need to convert the Excel workbooks to other formats to embed their content within the web applications. For such cases, this article covers how to convert Excel XLSX/XLS files to SVG format using C#.

Posted in Aspose.Cells Product Family | Tagged , ,

Encrypt or Decrypt Excel Files in Node.js

MS Excel is a powerful tool that allows you to perform various spreadsheet manipulation operations. You can organize data, apply computations, generate charts, define your custom logic using VBA modules, and so on. An important feature that MS Excel provides is encryption and decryption of the Excel files. In accordance with that, this article covers how to encrypt/decrypt and password-protect Excel files in Node.js applications.

Posted in Aspose.Cells Product Family | Tagged , ,