使用POI导出Excel,需要的Jar包:poi-bin-3.9-20121203.zip
示例代码如下:
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.HSSFRichTextString;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.HSSFColor;
---------------------------------------------------------------
HSSFWorkbook workbook=new HSSFWorkbook();//创建一个Excel文件
HSSFSheet sheet=workbook.createSheet();//创建Excel的Sheet
// 设置列宽
sheet.setColumnWidth(0, 1000);
sheet.setColumnWidth(1, 1000);
sheet.setColumnWidth(2, 1000);
sheet.setColumnWidth(3, 1000);
// Sheet样式
HSSFCellStyle sheetStyle = workbook.createCellSty