开发生成中,经常需要生成Excel报表,下拉选项也是经常会出现的
在最近工作中用到这一块内容,特意查了一下希望跟大家一块学习
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.DVConstraint;
import org.apache.poi.hssf.usermodel.HSSFDataValidation;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.util.CellRangeAddressList;
public class PoiTest2 {undefined
public static void main(String[] args) throws IOException {undefined
HSSFWorkbook wb = new HSSFWorkbook();// excel文件对象
HSSFSheet sheetlist = wb.createSheet("sheetlist");// 工作表对象
FileOutputStream out = new FileOutputStream("d:\\success.xls");
String[] textlist = { "列表1&#