Wrap column in Excel

[Former Member]

does anyone know how to wrap column in excel?

i'm trying to export data from dynpro to excel, but i can't find appropriate method to wrap text in a column.

[former_member199223 · Accepted solution]

Hi Oscar Wijaya ,

<i>Try this coding itis working warp text ,</i>

<b>try

{

WritableWorkbook wr=Workbook.createWorkbook(new File("c:
wbook.xls"));

WritableSheet ws=wr.createSheet("First sheet",0);

WritableCellFormat integerFormat = new WritableCellFormat();

integerFormat.setWrap(true);

Label l1=new Label(0,0,"Hai");

Label l2=new Label(0,1,"Hai wgfjahkdfba");

l2.setCellFormat(integerFormat);

ws.addCell(l1);

ws.addCell(l2);

wr.write();

wr.close();

}

catch(Exception e)

{

System.out.println("ERROR");

}</b>

Regards,

Boopathi

[Former Member · Accepted solution]

thanks, it is working ....