How can I create a Excel Table using Java?

Question

I am using JExcel for creating an excel document. I want to create a Excel table in Excel document using JAVA. I have populated the rows and columns in cells, I could not able to create Excel table and populate data into Excel Table

Tim Sparg · Accepted Answer · 2011-07-15 13:06:04Z

3

Use Apache POI, it has very good support for all types of Excel manipulation.

answered Jul 15, 2011 at 13:06

Tim Sparg

3,3142 gold badges29 silver badges40 bronze badges

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

Comments

Shahzeb · Accepted Answer · 2011-07-15 06:35:03Z

2

Very limited info but being thirsty for votes I will take a stab

Tables in excel are nothing but cells with boarders around them . Once you have data in your cells you use jxl.format.BorderLineStyle to create boarder around them and that would be your table . Simple :)

answered Jul 15, 2011 at 6:35

Shahzeb

4,7834 gold badges30 silver badges41 bronze badges

1 Comment

Dhakshana Murthy Over a year ago

Ya i know that to populate the cells and putting borders arround them..but my requirement is to get the output excel document should have the data populated in ExcelTable.

Collectives™ on Stack Overflow

How can I create a Excel Table using Java?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related