阅读背景:

使用Apache POI编写Excel工作表

来源:互联网 
package com.testCases;

import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.Date;

import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFCellStyle;
import org.apache.poi.hssf.usermodel.HSSFDataFormat;
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.HSSFColor;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class PoiWriteExcelFile {

    public static void main(String[] args) throws IOException {
            FileOutputStream fileOut = new FileOutputStream(
                    "D:\User\ExecutionResults.xlsx");
            XSSFWorkbook workbook = new XSSFWorkbook();
            XSSFSheet worksheet = workbook.getSheet("Sheet1"); 
            for (int i = 0; i <= 5; i++) {
                Cell cell=null;
                cell=worksheet.getRow(i).getCell(0);
                cell.setCellValue("Keyword" +i);
                cell=worksheet.getRow(i).getCell(1);
                cell.setCellValue("PASS" +i);
                workbook.write(fileOut);
            }
        } 

}
package com.testCases;

import java.io.FileNotF



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: