Java导入excel文件进行编辑然后导出

1. 使用poi操作excel，直接官网下载相应jar包导入项目
2. 完整实例

public class test {
   
	private static final String XLS = "xls";
	private static final String XLSX = "xlsx";

	/**
	 * 根据文件返回对应workbook对象
	 * 
	 * @date 2020-8-27
	 */
	public static Workbook getWorkbook(File file) throws IOException {
   
		Workbook workbook = null;
		FileInputStream fileInputStream = new FileInputStream(file);
		if (file.getName().endsWith(XLS)) {
   
			System.out.println("文件以XLS结尾！");
			workbook = new HSSFWorkbook(fileInputStream);
		} else if (file.getName().endsWith(XLSX)) {
   
			System.out