import java.sql.SQLException;
import java.util.List;
import javax.servlet.http.HttpServletRequest;
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.HSSFPrintSetup;
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.CellRangeAddress;
public class Excel {
private HSSFWorkbook wb = null;
private HSSFSheet sheet = null;
private HSSFRow row = null;
private HSSFCell cell = null;
private HSSFCellStyle titleStyle = null;
private HSSFCellStyle headStyle = null;
private HSSFCellStyle bodyStyle = null;
private int num = 0;
private int headLength = 0;
public Excel() {
wb = new HSSFWorkbook();
sheet = wb.createSheet();
sheet.setDefaultColumnWidth(14);
sheet.setDefaultRowHeight((short)20);
//打印设置
HSSFPrintSetup hps = sheet.getPrintSetup();
hps.setPaperSize(HSSFPrintSetup.A4_PAPERSIZE); //设置A4纸
hps.setLandscape(true); //将页面设置为横向打印模式
//sheet.setHorizontallyCenter(true); //设置打印页面为水平居中
//sheet.setVerticallyCenter(true); //设置打印页面为垂直居中
//冻结第一行和第二行
sheet.createFreezePane( 0, 2, 0, 2 );
init();
}
/**
*初始化样式
*/
private void init() {
titleFont();
headFont();
bodyFont();
}
/**
*设置标题样式
*
*/
private void titleFont() {
HSSFFont titleFont = wb.createFont();
titleFont.setBoldweight(HSSFFont.BOLDWEIG