我正在讀取一個文本文件，然后對該文件執行一些驗證，然后我試圖將該文件放入一個 excel 文件中。但是我只能將最后一行添加到 excel 文檔中，而不是每一行。任何幫助表示贊賞。謝謝你。這是我到目前為止所擁有的：LinkedList<String[]> llist = new LinkedList<>();String[] data;File temp = new File("file.txt");BufferedWriter bw = new BufferedWriter(new FileWriter(temp));for (int i = 0; i < llist.size(); i++) { if(i==0){ bw.newLine(); } else{ data = llist.get(i); String empid1 = data[0]; String fname = data[1]; String ccode1 = data[2]; if(data[2].equals("IND")) { replace = data[2].replaceAll("IND", "IN"); ccode1 = replace; } else if(data[2].equals("USA")) { replace = data[2].replaceAll("USA", "US"); ccode1 = replace; } else { ccode1 = data[2]; } String newData=empid1+","+fname+","+ccode1; XSSFWorkbook workBook = new XSSFWorkbook(); FileOutputStream outstream=new FileOutputStream("data.xls"); XSSFSheet spreadSheet = workBook.createSheet("Clean"); int row_num = 0; for(String[] str : llist) { XSSFRow row = spreadSheet.createRow(row_num++); int cell_num = 0; for(String value : str) { XSSFCell cell = row.createCell(cell_num++); cell.setCellValue(value); } } workBook.write(outstream);}}bw.close();}}
1 回答
元芳怎么了
TA貢獻1798條經驗 獲得超7個贊
像這樣重寫你的代碼：
LinkedList < String[] > llist = new LinkedList < > ();
String[] data;
File temp = new File("file.txt");
BufferedWriter bw = new BufferedWriter(new FileWriter(temp));
XSSFWorkbook workBook = new XSSFWorkbook();
FileOutputStream outstream = new FileOutputStream("data.xls");
XSSFSheet spreadSheet = workBook.createSheet("Clean");
for (int i = 0; i < llist.size(); i++) {
if (i == 0) {
bw.newLine();
} else {
data = llist.get(i);
String empid1 = data[0];
String fname = data[1];
String ccode1 = data[2];
if (data[2].equals("IND")) {
replace = data[2].replaceAll("IND", "IN");
ccode1 = replace;
} else if (data[2].equals("USA")) {
replace = data[2].replaceAll("USA", "US");
ccode1 = replace;
} else {
ccode1 = data[2];
}
//String newData=empid1+","+fname+","+ccode1;
XSSFRow row = spreadSheet.createRow(i);
XSSFCell cell = row.createCell(0);
cell.setCellValue(empid1);
cell = row.createCell(1);
cell.setCellValue(fname);
cell = row.createCell(2);
cell.setCellValue(ccode1);
}
}
workBook.write(outstream);
bw.close();
添加回答
舉報
0/150
提交
取消