Writing JTable into Excel

Question

I am planning to move the contents of a JTable into a Microsoft Excel sheet. The Excel sheet should have some format specifications. For instance if a column has a value 'A' it should be green in colour. If it is 'B' red in colour.

I am in analysis stage. Which Jar should I use? The data is not huge.Performance is not a big concern.

score 10 · Accepted Answer · edited Feb 03 '11 at 09:54

10

I would recommend Apache POI. It is easy to use, allows styling, etc. See the quick guide here.

edited Feb 03 '11 at 09:54

Tim Stone

19,119
6
56
66

answered Feb 03 '11 at 06:41

Michael

4,722
6
37
58

score 2 · Answer 2 · answered Feb 03 '11 at 14:59

2

An alternative could be JExcelAPI - I've used this and found it excellent.

answered Feb 03 '11 at 14:59

TrueDub

5,000
1
27
33

Writing JTable into Excel

2 Answers2