java导出excel设置表头

最新推荐文章于 2024-05-09 19:27:14 发布

最新推荐文章于 2024-05-09 19:27:14 发布

分类专栏： java 文章标签： excel java list null xml object

0
点赞
踩
5

收藏

觉得还不错? 一键收藏
0
评论
java导出excel设置表头

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.HSSFCel
复制链接

扫一扫

java导出excel设置表头

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.BOLDWEIGHT_BOLD);

titleFont.setFontName("宋体");

titleFont.setFontHeightInPoints((short) 18);

titleStyle = wb.createCellStyle();

titleStyle.setFont(titleFont);

// titleStyle.setBorderTop((short)1);

// titleStyle.setBorderRight((short)1);

titleStyle.setBorderBottom((short)1);

// titleStyle.setBorderLeft((short)1);

titleStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);

}

/**

* 设置head样式

*

*/

private void headFont() {

HSSFFont headFont = wb.createFont();

headFont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);

headFont.setFontName("宋体");

headFont.setFontHeightInPoints((short) 11);

headStyle = wb.createCellStyle();

headStyle.setFont(headFont);

headStyle.setBorderTop((short)1);

headStyle.setBorderRight((short)1);

headStyle.setBorderBottom((short)1);

headStyle.setBorderLeft((short)1);

headStyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);

}