package pio;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;
import java.util.Date;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.CreationHelper;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
public class Demo1 {
public static void main(String [] args) throws IOException {
HSSFWorkbook wb = new HSSFWorkbook();//创建工作簿
Sheet sheet = wb.createSheet("sheet1");//创建sheet1
Row row = sheet.createRow(0); //创建第一行
Cell cell = row.createCell(0); //创建第一列
cell.setCellValue(1.2);//设置值
row.createCell(1).setCellValue(true);//设置值
row.createCell(2).setCellValue("test");//设置值
CreationHelper createHelper = wb.getCreationHelper();
CellStyle cstyle = wb.createCellStyle();//单元格子样式
cstyle.setDataFormat(createHelper.createDataFormat().getFormat("yyyy-mm-dd hh:mm:ss"));
cell = row.createCell(3);
cell.setCellValue(new Date());
cell.setCellStyle(cstyle);
FileOutputStream fileOut = new FileOutputStream ("D:\\1.xls");
wb.write(fileOut);
System.out.print("execute sucessful");
fileOut.close();
}
}