读书人

用apache的POI 导出Excel怎么合并单元

发布时间: 2011-12-06 23:05:08 作者: rapoo

用apache的POI 导出Excel怎样合并单元格,设置字体,和改变行高
用apache的POI 导出Excel怎样合并单元格,设置字体,和改变行高?

[解决办法]
帮你顶下
[解决办法]
public class MergedCells {
public static void main(String[] args) throws IOException {
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet( "new sheet ");

HSSFRow row = sheet.createRow((short) 1);
HSSFCell cell = row.createCell((short) 1);
cell.setCellValue( "This is a test of merging ");

sheet.addMergedRegion(new Region(1, (short) 1, 1, (short) 2));

// Write the output to a file
FileOutputStream fileOut = new FileOutputStream( "workbook.xls ");
wb.write(fileOut);
fileOut.close();

}
}
[解决办法]
HSSFRow row = sheet2.createRow(2);
row.setHeightInPoints(240);
sheet2.setColumnWidth((short) 2, (short) 9000);

读书人网 >J2SE开发

热点推荐