Create Excel Files using Java without MS Office

MS Excel spreadsheets have made it easier to keep and share a large amount of tabular data. Not only this, 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. After reading this article, you will be able to create MS Excel XLSX or XLS files from scratch using Java. In addition, this article will cover how to update an existing Excel file, generate charts, and add tables in Excel worksheets.
October 13, 2020 · 5 min · Usman Aziz