作者:乔山办公网日期:
返回目录:excel表格制作
HSSFWorkbook wb=new HSSFWorkbook(); //创建来一个Excel
HSSFSheet sheet=wb.createSheet("sheet1");//创建一个Sheet
HSSFRow row=sheet.createRow(0);//创建一个行
HSSFCell cell=row.createCell((short)0); //创建一个单元格
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("序号"); //设置值源
cell=row.createCell((short)1);
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("姓");
这个是最简单的一百个例子 ,下面的参度考资料 你可以看看....
对于问新使用者很不错, 介绍也很详细 ,希望答能够帮到你
看似越界问题,看看是不是大小设置错了?
import java.io.File;
public class Test {
public static void main(String[] args) throws Exception {
File f = new File("d:/1.xls");
f.createNewFile();
}
}
好吧,之前没看到“用poi”这句话。现7a64e59b9ee7ad94366在下面的是用poi的:
import java.io.FileOutputStream;
import java.io.IOException;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class Test {
public static void main(String[] args) {
try {
HSSFWorkbook workbook = new HSSFWorkbook();
FileOutputStream fileOut = new FileOutputStream("D:/2.xls");
workbook.write(fileOut);
fileOut.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
Java代码package poiexcel; import java.io.FileOutputStream; import java.util.Date; import org.apache.poi.hssf.usermodel.DVConstraint; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFDataValidation; 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.CellRangeAddressList; public class POI { public static void main(String [] args) { String [] list={"东软","华信","SAP","海辉"}; new POI().createListBox(list); return; } public void createListBox (String [] list) { //文件初始化 HSSFWorkbook wb = new HSSFWorkbook(); HSSFSheet sheet = wb.createSheet("new sheet"); //在第一行第一个单元格,插入下拉框 HSSFRow row = sheet.createRow(0); HSSFCell cell = row.createCell(0); //普通写入操作 cell.setCellValue("请选择");//这是实验 //生成下拉列表 //只对(0,0)单元格有效 CellRangeAddressList regions = new CellRangeAddressList(0,0,0,0); //生成下拉框内容 DVConstraint constraint = DVConstraint.createExplicitListConstraint(list); //绑定下拉框和作用区域 HSSFDataValidation data_validation = new HSSFDataValidation(regions,constraint); //对sheet页生效 sheet.addValidationData(data_validation); //写入文件 FileOutputStream fileOut; try { fileOut = new FileOutputStream("workbook.xls"); wb.write(fileOut); fileOut.close(); } catch (Exception e) { // TODO Auto-generated catch block e.printStackTrace(); } //结束e799bee5baa6e59b9ee7ad94364 System.out.println("Over"); } }责任编辑:linshi1