java将excel转换成txt_java将excel文件转换成txt格式文件

();

row = sheet.getRow(i);

if (row != null) {

for (int j = 0; j < colnum; j++) {

cellData = (String) getCellFormatValue(row.getCell(j));

map.put(columns[j], cellData);

}

} else {

break;

}

list.add(map);

}

}

// 遍历解析出来的list

StringBuffer sb = new StringBuffer();

for (int i = 0; i < list.size(); i++) {

for (Entryentry : list.get(i).entrySet()) {

String value = entry.getValue();

sb.append(value + ",");

}

sb.append("\r\n");

}

WriteToFile(sb.toString(), textPath);

System.out.println("*************EXCEL转成TXT格式成功*************");

}

// 读取excel

public static Workbook readExcel(String filePath) {

Workbook wb = null;

if (filePath == null) {

return null;

}

String extString = filePath.substring(filePath.lastIndexOf("."));

InputStream is = null;

try {

is = new FileInputStream(filePath);

if (".xls".equals(extString)) {

return wb = new HSSFWorkbook(is);

} else if (".xlsx".equals(extString)) {

return wb = new XSSFWorkbook(is);

} else {

return wb = null;

}

} catch (FileNotFoundException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

}

return wb;

}

public static Object getCellFormatValue(Cell cell) {

Object cellValue = null;

if (cell != null) {

// 判断cell类型

switch (cell.getCellType()) {

case Cell.CELL_TYPE_NUMERIC: {

cellValue = String.valueOf(cell.getNumericCellValue());

break;

}

case Cell.CELL_TYPE_FORMULA: {

// 判断cell是否为日期格式

if (DateUtil.isCellDateFormatted(cell)) {

// 转换为日期格式YYYY-mm-dd

cellValue = cell.getDateCellValue();

} else {

// 数字

cellValue = String.valueOf(cell.getNumericCellValue());

}

break;

}

case Cell.CELL_TYPE_STRING: {

cellValue = cell.getRichStringCellValue().getString();

break;

}

default:

cellValue = "";

}

} else {

cellValue = "";

}

return cellValue;

}

/**

* 生成文件

* @param str

* @param filePath

* @throws IOException

*/

public static void WriteToFile(String str, String filePath) throws IOException {

BufferedWriter bw = null;

try {

FileOutputStream out = new FileOutputStream(filePath, true);// true,表示:文件追加内容，不重新生成,默认为false

bw = new BufferedWriter(new OutputStreamWriter(out, "GBK"));

bw.write(str += "\r\n");// 换行

bw.flush();

} catch (Exception e) {

e.printStackTrace();

} finally {

bw.close();

}

}

}