编码
初始化SparkSession
static{
System.setProperty("hadoop.home.dir", HADOOP_HOME);
spark = SparkSession.builder()
.appName("test")
.master("local[*]")
.config("spark.sql.warehouse.dir",SPARK_HOME)
.config("spark.sql.parquet.binaryAsString", "true")
.getOrCreate();
}
读取excel
public static void readExcel(String filePath,String tableName) throws IOException{
DecimalFormat format = new DecimalFormat();
format.applyPattern("#");
//创建文件(可以接收上传的文件,springmvc使用CommonsMultipartFile,jersey可以使用org.glassfish.jersey.media.multipart.FormDataParam(参照本人文件上传博客))
File file = new File(filePath);
//创建文件流
InputStream inputStream = new FileInputStream(file);
//创建流的缓冲区
BufferedInputStream bufferedInputStream = new BufferedInputStream(inputStream);
//定义Excel workbook引用
Workbook workbook =null;
//.xlsx格式的文件使用XSSFWorkbook子类,xls格式的文件使用HSSFWorkbook
if(file.getName().contains("xlsx")) workbook = new XSSFWorkbook(bufferedInputStream);
if(file.getName().contains("xls")&&!file.getName().contains("xlsx")) workbook = new HSSFWorkbook(bufferedInputStream);
System.out.println(file.getName())