import org.jxls.reader.ReaderBuilder;
import org.jxls.reader.XLSReadStatus;
import org.jxls.reader.XLSReader;
import java.io.*;
import java.util.HashMap;
import java.util.Map;
public class JXLSExample {
public static void main(String[] args) {
try {
InputStream inputXML = new BufferedInputStream(new FileInputStream("template.xls"));
InputStream inputXLS = new BufferedInputStream(new FileInputStream("data.xlsx"));
XLSReader reader = ReaderBuilder.buildFromXML(inputXML);
Map<String, Object> beans = new HashMap<>();
XLSReadStatus readStatus = reader.read(inputXLS, beans);
if (readStatus.isStatusOK()) {
OutputStream outputXLS = new BufferedOutputStream(new FileOutputStream("output.xls"));
reader.getEngine().getWorkbook().write(outputXLS);
outputXLS.flush();
outputXLS.close();
}
} catch (Exception e) {
e.printStackTrace();
}
}
private static List<Map<String, Object>> getData() {
List<Map<String, Object>> data = new ArrayList<>();
Map<String, Object> row1 = new HashMap<>();
row1.put("age", 25);
data.add(row1);
Map<String, Object> row2 = new HashMap<>();
row2.put("age", 30);
data.add(row2);
return data;
}
}
