String[]?title?=?{"id","name","sex"};
????//創建文件
????File?file?=?new?File("e:/jxl_test.xls");
????try?{
????????file.createNewFile();
????????//創建工作簿
????????WritableWorkbook?writableWorkbook?=?Workbook.createWorkbook(file);
????????//創建Sheet
????????WritableSheet?writableSheet?=?writableWorkbook.createSheet("sheet1",0);
????????Label?label?=?null;
????????//第一行設置列名
????????for?(int?i?=?0;?i?<title.length?;?i++)?{
????????????label?=?new?Label(i,0,title[i]);
????????????writableSheet.addCell(label);
????????}
????????//追加數據
????????for?(int?i?=?0;?i?<?10;?i++)?{
????????????label?=?new?Label(0,i,"a"+1);
????????????writableSheet.addCell(label);
????????????label?=?new?Label(1,i,"user"+i);
????????????writableSheet.addCell(label);
????????????label?=?new?Label(2,i,"男");
????????????writableSheet.addCell(label);
????????}
????????writableWorkbook.write();
????????writableWorkbook.close();
????}?catch?(Exception?e)?{
????????e.printStackTrace();
????}
}
2019-07-03
后面的數據從1開始,,你的覆蓋了表頭了