Java解析Excel文件、Csv文件、Txt文件汇总

Java解析Excel文件、Csv文件、Txt文件汇总

解析excel文件需要引入以下两个jar包

<!-- excel文件解析依赖 -->
  <!-- https://mvnrepository.com/artifact/org.apache.poi/poi -->
  <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi</artifactId>
      <version>4.1.0</version>
  </dependency>
  <!-- https://mvnrepository.com/artifact/org.apache.poi/poi-ooxml -->
  <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi-ooxml</artifactId>
      <version>4.1.0</version>
  </dependency>

下面是解析代码``

package com.smc.purchase.utils;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStreamReader;
import java.util.ArrayList;
import java.util.List;

import org.apache.commons.lang3.StringUtils;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

public class FileScannerUtil {
   

	private static final Logger log = LoggerFactory.getLogger(FileScannerUtil.class);

	/**
	 * 
	 * getxExcel:(解析Excel文件（包括xls格式和xlsx格式）). <br/>
	 * @author B82559
	 * @param file
	 * @return list
	 */
	public static List<String[]> getxExcel(String filePathName) {
   
		File file=new File(filePathName);
		List<String[