Java中POI输出报表的基本应用

import java.io.FileOutputStream;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFCellStyle;import org.apache.poi.hssf.usermodel.HSSFFont;import org.apache.poi.hssf.usermodel.HSSFRow;import org.apache.poi.hssf.usermodel.HSSFSheet;import org.apache.poi.hssf.usermodel.HSSFWorkbook;public class TestExcelPoiPrint{public static void main(String[] args) throws Exception{TestExcelPoiPrint ep = new TestExcelPoiPrint();ep.print();}/* * poi实现输出信息到excel文件  *  */public void print() throws Exception{String xlsFile = "d:/testpoi.xls";//STEP 1:打开excel文件HSSFWorkbook wb = new HSSFWorkbook();//创建excel文件//HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(xlsFile));//打开已存在的excel文件//STEP 2:打开当前工作簿HSSFSheet sheet = wb.createSheet("我的第一个工作簿");//建立新的sheet对象//HSSFSheet sheet = wb.getSheetAt(0);//选择第一个工作簿//wb.setSheetName(0, "我的第一个工作簿");//设置工作簿的名称//STEP 3:创建行对象HSSFRow nRow = sheet.createRow((short)1);//第2行//STEP 4:指定列 创建单元格对象HSSFCell nCell = nRow.createCell((short)(2));//第3列//STEP 5:指定列 创建单元格对象nCell.setCellValue("我是单元格");//STEP 6:设置样式nCell.setCellStyle(leftStyle(wb));//STEP 7:关闭保存excel文件FileOutputStream fOut = new FileOutputStream(xlsFile);wb.write(fOut);fOut.flush();fOut.close();}//设置单元格样式private HSSFCellStyle leftStyle(HSSFWorkbook wb){HSSFCellStyle curStyle = wb.createCellStyle();HSSFFont curFont = wb.createFont();//设置字体//curFont.setFontName("Times New Roman");//设置英文字体curFont.setFontName("微软雅黑");//设置英文字体curFont.setCharSet(HSSFFont.DEFAULT_CHARSET);//设置中文字体，那必须还要再对单元格进行编码设置curFont.setFontHeightInPoints((short)10);//字体大小curStyle.setFont(curFont);curStyle.setBorderTop(HSSFCellStyle.BORDER_THICK);//粗实线curStyle.setBorderBottom(HSSFCellStyle.BORDER_THIN);//实线curStyle.setBorderLeft(HSSFCellStyle.BORDER_MEDIUM);//比较粗实线curStyle.setBorderRight(HSSFCellStyle.BORDER_THIN);//实线curStyle.setWrapText(true);  //换行   curStyle.setAlignment(HSSFCellStyle.ALIGN_RIGHT);//横向具右对齐curStyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);//单元格垂直居中return curStyle;}}