当前位置: 代码迷 >> J2SE >> 用apache的POI 导出Excel怎么合并单元格,设置字体,和改变行高
  详细解决方案

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

热度:6   发布时间:2016-04-24 14:27:43.0
用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);
  相关解决方案