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.

Tim Stone · Accepted Answer · 2011-02-03 09:54:24Z

10

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

edited Feb 3, 2011 at 9:54

Tim Stone

19.2k6 gold badges58 silver badges66 bronze badges

answered Feb 3, 2011 at 6:41

Michael

5,0927 gold badges43 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TrueDub · Accepted Answer · 2011-02-03 14:59:04Z

2

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

answered Feb 3, 2011 at 14:59

TrueDub

5,0901 gold badge30 silver badges34 bronze badges

Collectives™ on Stack Overflow

Writing JTable into Excel

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related