writing excel through JAVA using HSSF workBook

Question

I am using HSSF work book to write data into excel using java, Now i have a column name with n-no of words, if i insert it normally its coming in a same line, i want to break the sentences into two different line and insert into same cell.

below is the code iam using to set the column

 rowhead.createCell((short) 0).setCellValue("Hi there it is my lengthy column please help");

Thanks, Tom

Benoit Wickramarachi · Accepted Answer · 2014-05-28T15:17:15.523

2

You just need to use the Java new line '\n' char to break your sentence into 2 lines then set WrapText to true:

    Cell cell = rowhead.createCell((short) 0));
    cell.setCellValue("Hi there it is my lengthy \n column please help");
    CellStyle cs = wb.createCellStyle();
    cs.setWrapText(true);
    cell.setCellStyle(cs);

edited May 28 '14 at 15:17

answered May 28 '14 at 15:10

Benoit Wickramarachi

6,096
5
36
46

U mean i need to do like --- ' rowhead.createCell((short) 0).setCellValue("Hi there it is my '\n' lengthy column please help") ' – tom May 28 '14 at 15:13
1

Yes but you need to apply a CellStyle with the property WrapText set to 'true' to make it works. – Benoit Wickramarachi May 28 '14 at 15:17

writing excel through JAVA using HSSF workBook

1 Answers1