import java.io.FileOutputStream;
import java.text.SimpleDateFormat;
import java.util.Date;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
public class PoiCreate {
/**
* @param args
*/
public static void main(String[] args) throws Exception {
// 创建一个EXCEL
Workbook wb = new HSSFWorkbook();
// 创建一个SHEET
Sheet sheet1 = wb.createSheet("产品清单");
String[] title = { "编号", "产品名称", "产品价格", "产品数量", "生产日期", "产地", "是否出口" };
// 创建一行
Row row = sheet1.createRow(0);
// 填充标题
for (int i = 0 ; i<title.length ;i++) {
Cell cell = row.createCell(i);
cell.setCellValue(title[i]);
}
Row row1 = sheet1.createRow(1);
// 下面是填充数据
row1.createCell(0).setCellValue(20071001);
row1.createCell(1).setCellValue("金鸽瓜子");
row1.createCell(2).setCellValue("201");
row1.createCell(3).setCellValue(200);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
String newdate = sdf.format(new Date());
row1.createCell(4).setCellValue(newdate);
row1.createCell(5).setCellValue("陕西西安");
row1.createCell(6).setCellValue(true);
FileOutputStream fileOut = new FileOutputStream("d:\\test.xls");
wb.write(fileOut);
fileOut.close();
}
}
import java.text.SimpleDateFormat;
import java.util.Date;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
public class PoiCreate {
/**
* @param args
*/
public static void main(String[] args) throws Exception {
// 创建一个EXCEL
Workbook wb = new HSSFWorkbook();
// 创建一个SHEET
Sheet sheet1 = wb.createSheet("产品清单");
String[] title = { "编号", "产品名称", "产品价格", "产品数量", "生产日期", "产地", "是否出口" };
// 创建一行
Row row = sheet1.createRow(0);
// 填充标题
for (int i = 0 ; i<title.length ;i++) {
Cell cell = row.createCell(i);
cell.setCellValue(title[i]);
}
Row row1 = sheet1.createRow(1);
// 下面是填充数据
row1.createCell(0).setCellValue(20071001);
row1.createCell(1).setCellValue("金鸽瓜子");
row1.createCell(2).setCellValue("201");
row1.createCell(3).setCellValue(200);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
String newdate = sdf.format(new Date());
row1.createCell(4).setCellValue(newdate);
row1.createCell(5).setCellValue("陕西西安");
row1.createCell(6).setCellValue(true);
FileOutputStream fileOut = new FileOutputStream("d:\\test.xls");
wb.write(fileOut);
fileOut.close();
}
}