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