All geek questions in one place

What is the best way to write an excel file with Java?

In which library would you guys recommend writing an excel file with Java? It should be a pure Java solution, so it will work on any platform.

Thanks Grae

EDIT: CSV file format cannot be. It should have column headers, data format type, etc.

+4
source share
2 answers

The best solution I've found for creating Microsoft document formats is the Apache POI library: http://poi.apache.org/

+8
source

Starting with MS Office 2007, Excel files are saved in Office Open XML ( .xlsx ) by default. Create such a file with any content, rename it to .zip and take a look inside. This is a bunch of folders and XML files compressed together.

Java provides support for creating zip files using java.util.zip . And that’s all you need.

+1
source

Source: https://habr.com/ru/post/1337620/

More articles:


All Articles