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;
import org.apache.poi.ss.util.CellRangeAddress;
public class testExcel{
public static void main(String[] args) throws Exception {
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet("测试生成excel");
//指定合并区域CellRangeAddress(int firstRow, int lastRow, int firstCol, int lastCol)
sheet.addMergedRegion(new CellRangeAddress(1,1,1, 17));
/*设置样式*/
HSSFCellStyle cellStyleHeader = workbook.createCellStyle();
//列的值换行除了添加:\r\n之外还要设置列的样式setWrap为true,
cellStyleHeader.setWrapText(true);
HSSFRow rowHeader = sheet.createRow(2);
HSSFCell cellHeader = null;
cellHeader = rowHeader.createCell(1);
cellHeader.setCellStyle(cellStyleHeader);
//设置列的值换行: \r\n
cellHeader.setCellValue(new HSSFRichTextString("所属SBU或\r\n直属一级利润中心"));
}
}
需要的jar包:poi-3.9.jar