Create Excel XLS Files in Java Without MS Office

MS Excel provides an easy way to keep and share a large amount of tabular data. In addition, you can perform various operations such as applying formulas, generating charts and graphs, sorting and filtering data, and so on. In this article, you will learn how to implement Excel automation features from within your Java applications. We will demonstrate how to create Excel XLSX or XLS files from scratch in Java. In addition, we will cover how to update an existing Excel file, generate charts, apply formulas, and add pivot tables in Excel worksheets.
October 13, 2020 · 6 min · Usman Aziz