計科前沿 || 用JAVA創建EXCEL表

材料：Java編譯器，poi jar包

 

代碼：

import java.io.FileOutputStream;

import java.io.IOException;

 

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.hssf.usermodel.HSSFCellStyle;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

 

public class SimpleExcelWrite{

    

    public static void main(String[] args) {

        

         //第一步創建workbook  

        HSSFWorkbook wb = new HSSFWorkbook();  

          

        //第二步創建sheet  

        HSSFSheet sheet = wb.createSheet("測試");  

          

        //第三步創建行row:添加表頭0行  

        HSSFRow row = sheet.createRow(0);  

        HSSFCellStyle  style = wb.createCellStyle();      

        //style.setAlignment(HSSFCellStyle.ALIGN_CENTER);  //居中  

          

          

        //第四步創建單元格  

        HSSFCell cell = row.createCell(0); //第一個單元格  

        cell.setCellValue("姓名");  

        cell.setCellStyle(style);  

        

        

        

        cell = row.createCell(1);         //第二個單元格     

        cell.setCellValue("年齡");  

        cell.setCellStyle(style);  

          

       

        //第五步插入數據  

       

        for (int i = 0; i < 5; i++) {  

            //創建行  

            row = sheet.createRow(i+1);  

            //創建單元格並且添加數據  

            row.createCell(0).setCellValue("aa"+i);  

            row.createCell(1).setCellValue(i);   

        }  

          

        //第六步將生成excel文件保存到指定路徑下  

        try {  

            FileOutputStream fout = new FileOutputStream("D:/a.xls");  

            wb.write(fout);  

            fout.close();  

            wb.close();

        } catch (IOException e) {  

            e.printStackTrace();  

        }  

          

        System.out.println("Excel文件生成成功...");

    }  

}

 

運行結果：