用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);