XLS读取
public List getXlsFile(String fileName) throws IOException, BiffException{
List result = new ArrayList();
File inputFile = new File(fileName);
FileInputStream fileInputStream = new FileInputStream(inputFile);
Workbook workbook = Workbook.getWorkbook(fileInputStream);
Sheet sheet = workbook.getSheet(0);//获取第一张表（下标从零开始）
int rows = sheet.getRows();//获取行数
for(int i =0;i
Cell cell = sheet.getCell(0, i);//获取第i行的第0列的数据，默认是string类型
result.add(cell.getContents());
}
return result;
}
TXT读取
public List getTxtFile(String fileName) throws IOException {
InputStreamReader read = new InputStreamReader(new FileInputStream(fileName),"utf-8");//编码格式
BufferedReader bufferedReader = new BufferedReader(read);
String lineTxt;
List result = new ArrayList();
while((lineTxt = bufferedReader.readLine()) != null){//按行读入到最后一行
result.add(lineTxt);
}
return result;
}
csv的写入
public static void printCsv(String line,String outPutPath) throws IOException {
File outPutFile = new File(outPutPath);
OutputStreamWriter outputStreamWriter = new OutputStreamWriter(new FileOutputStream(outPutFile), "utf-8");
outputStreamWriter.write(line + "rn");
outputStreamWriter.flush();
outputStreamWriter.close();
}
