IT工程師數位筆記本

package com.test.util;

/** 
 * @author ocq
 * 
 */
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.OutputStream;

import jxl.Workbook;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;

public class SimpleExcelWrite {
    public static void createExcel(OutputStream os, String[] headField, String[] values) throws WriteException,
            IOException {
        // 創建工作薄
        WritableWorkbook workbook = Workbook.createWorkbook(os);
        // 創建新的一頁
        WritableSheet sheet = workbook.createSheet("First Sheet", 0);

        // 創建要顯示的內容,創建一個單元格，第一個參數為列坐標，第二個參數為行坐標，第三個參數為內容
        for (int y = 0; y < 100 * 100 + 1; y++) {
            int index = y % 100;
            if (index == 0) {
                for (int x = 0; x < headField.length; x++) {
                    Label xuexiao = new Label(x, index, headField[x]);
                    sheet.addCell(xuexiao);
                }
            } else {
                for (int x = 0; x < values.length; x++) {
                    String string = values[x];
                    if (x == 0 || x == 3) {
                        string += y;
                    }
                    Label xuexiao = new Label(x, index, string);
                    sheet.addCell(xuexiao);
                }
            }

        }
        // 把創建的內容寫入到輸出流中，并關閉輸出流
        workbook.write();
        workbook.close();
        os.close();
    }

    public static void main(String[] args) throws WriteException, IOException {
        // List<String> headField=new ArrayList<String>();
        String[] headField = new String[] { "表頭一", "表頭2", ..... };

        String[] values = new String[] { "內容一", "內容2", ... };

        for (int i = 1; i < 101; i++) {
            OutputStream os = new FileOutputStream("file name" + i + ".xls");
            createExcel(os, headField, values);
        }

    }
}