workbook加载文件路径_java poi 读取本地文件和导出到本地

闲来无事简单写了一个poi读取本地文件然后导出 excel的单元测试。没有设置excel的格式和设置合并单元格，如果有需要的可以去网上找下，并不难。

好的一步一步的放代码。

首先是单元测试方法也是程序的入口 。

@Test

public void downloadTest(){

//读取文件

String path = "C:\\Users\\Administrator\\Desktop\\counterTemplate.xlsx";

List list = readFile(path);

if (list != null) {

//列名

String[] fields = new String[]{"journal","publisher","platform","printISSN","onlineISSN","reportingPeriodTotal",

"reportingPeriodHTML","reportingPeriodPDF","jan","feb",

"mar","apr","may","jun","jul","aug","sep","oct","nov","dec"};

//写出文件

String outPath ="E:\\demo\\counterTemplate导出模板.xlsx";

writerExcel(list, fields, outPath);