java输出excel 异常处理_使用poi导出Excel，并设定单元格内容类型，抛出异常

本例子使用的是HSSF,为Excel2003提供处理方案。

设定为输入类型为数值

import org.apache.poi.hssf.usermodel.DVConstraint;

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFCellStyle;

import org.apache.poi.hssf.usermodel.HSSFDataValidation;

import org.apache.poi.hssf.usermodel.HSSFDataValidationHelper;

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;

import org.apache.poi.hssf.util.CellRangeAddress;

import org.apache.poi.hssf.util.CellRangeAddressList;

import org.apache.poi.ss.usermodel.CellStyle;

import org.apache.poi.ss.usermodel.DataValidation;

import org.apache.poi.ss.usermodel.DataValidationConstraint;

import org.apache.poi.ss.usermodel.DataValidationHelper;

import org.apache.poi.ss.usermodel.IndexedColors;

import org.apache.poi.ss.usermodel.Workbook;

import org.apache.poi.ss.usermodel.DataValidationConstraint.ValidationType;

import org.apache.poi.ss.usermodel.DataValidationConstraint.OperatorType;

/**

* 设定为输入类型为数值

* @param firstRow

* @param endRow

* @param firstCol

* @param endCol

* 注意：如果是一个单元格，需要firstRow = endRow, firstCol = endCol

* @return

*/

public static HSSFDataValidation setDataValidation(int firstRow,int endRow,int firstCol,int endCol)