Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Java > Advise to create regions in excel using HSSF

Thread Tools

Advise to create regions in excel using HSSF

tegueste tegueste is offline
Junior Member
Join Date: Aug 2009
Posts: 1

I have a problem creating my excel file using HSSF. In excel I can merge cells using sheet.addMergedRegion(new CellRangeAddress(int firstRow, int lasRow, int firstCol, int lastCol))

My problem is I have datatables with differents headers which contains cells with rowspan and colspan and I want to create the same structure in excel.

I have defined the structure like you do in regular html to create the cells of a html table.

I have tried reading recursivily this structure and place in excel but no way. Maybe there is another way to do, I don't know but it would be great if somebody can give me an advise to do this.

thanks in advance
Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using HSSF to convert csv to Excel sue yi Chew Java 1 02-10-2011 01:59 PM
convert html to excel using hssf poi??? davisoski Java 0 08-16-2009 04:07 PM
HSSF, excel and "out of memory" tony lincoln Java 0 03-02-2004 08:24 AM
excel---HSSF---not enough memory? tony lincoln Java 0 03-01-2004 05:34 PM
HSSF and Excel Pivot Tables David W. Java 0 07-28-2003 10:02 PM