-
WritableFont fontTitle = new WritableFont(WritableFont.TIMES, 9, WritableFont.NO_BOLD);
-
fontTitle.setColour(jxl.format.Colour.RED);
-
WritableCellFormat formatTitle = new WritableCellFormat(fontTitle);
-
formatTitle.setWrap(true);
-
/*-------------------------------------------------------------------------*/
-
WritableSheet m_sheet = null;
-
m_sheet = m_writeBook.createSheet("第一页", 0);
-
m_sheet.setColumnView(0, 10);
-
m_sheet.setRowView(0, 500);
-
Label label = new Label(0, 0, "阿科是个不错的小伙子阿科是个不错" +
-
"的小伙子阿科是个不错的小伙子", format);
-
//将定义好的单元格添加到工作表中
-
m_sheet.addCell(label);
如上例当中,虽然列宽设置的仅仅是10,而文字的长度远远的超过10,但是由于使用WritableCellFormat的设置选项: formatTitle.setWrap(true)。从而使得单元格的文字按照单元格的列宽来自动换行显示。