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.
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.
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.
Convert CSV to Excel or Excel to CSV on Linux 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.
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.
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.
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 files to SVG format using C#.
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.
Convert Excel Files to PDF on Linux using .NET
PDF is a popular file format which is widely used to share or print documents. In various cases, the documents of other file formats, such as spreadsheets, are converted to PDF. In this article, you are going to learn how to convert Excel files to PDF programmatically on the Linux platform. We will perform this conversion using a .NET spreadsheet manipulation API named Aspose.Cells for .NET.
Disable Compatibility Checker in Excel Files using C#
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 the compatibility checker to degrade the features which are not supported by an older format when saving the files. However, in certain cases, you have to disable the compatibility checker. In this article, you will learn how to disable the compatibility checker for MS Excel workbooks in C#.