import com.spire.xls.ExcelVersion;

import com.spire.xls.Workbook;

import com.spire.xls.Worksheet;

public class InsertArray {

public static void main(String[] args) {

//創建Workbook對象

Workbook wb = new Workbook();

//獲取第一張62616964757a686964616fe4b893e5b19e31333433656661工作表

Worksheet sheet = wb.getWorksheets().get(0);

//定義一維數據

String[] oneDimensionalArray = new String[]{"蘋果", "梨子", "葡萄", "香蕉"};

//將數組從指定單個格開始寫入工作表，true表示縱向寫入，設置為false為橫向寫入

sheet.insertArray(oneDimensionalArray, 1, 1, true);

//定義二維數組

String[][] twoDimensionalArray = new String[][]{

{"姓名", "年齡", "性別", "學歷"},

{"小張", "25", "男", "本科"},

{"小王", "24", "男", "本科"},

{"小李", "26", "女", "本科"}

};

//從指定單元格開始寫入二維數組到工作表

sheet.insertArray(twoDimensionalArray, 1, 3);

//保存文檔

wb.saveToFile("InsertArrays.xlsx", ExcelVersion.Version2016);

}

}