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

男娘i 2022-12-01 14:21 201阅读 0赞

**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.println("文件以XLSX结尾！");
    			workbook = new XSSFWorkbook(fileInputStream);
    		} else { 
    			JOptionPane.showMessageDialog(null, "文件格式错误！");
    			System.exit(0);
    		}
    		fileInputStream.close();
    
    		return workbook;
    	}
    
    	/** * 通过文件选择器获取文件 * * @date 2020-8-27 */
    	public static File getFile() { 
    		JFileChooser jFileChooser = new JFileChooser();
    		jFileChooser.setDialogTitle("请选择excel文件");
    		FileSystemView fileSystemView = FileSystemView.getFileSystemView();
    		String homePath = fileSystemView.getHomeDirectory().getPath();
    		jFileChooser.setCurrentDirectory(new File(homePath));
    		// 文件选择器显示文件和目录
    		jFileChooser.setFileSelectionMode(JFileChooser.FILES_AND_DIRECTORIES);
    		int showOpenDialog = jFileChooser.showDialog(null,"下一步");
    		if (showOpenDialog == jFileChooser.APPROVE_OPTION) { 
    			return jFileChooser.getSelectedFile();
    		}else { 
    			System.exit(0);
    		}
    		return null;
    	}
    
    	/** * 通过文件选择器获取输出路径 * * @date 2020-8-27 */
    	public static String getFilePath() { 
    		JFileChooser jFileChooser = new JFileChooser();
    		jFileChooser.setDialogTitle("请选择文件输出路径");
    		FileSystemView fileSystemView = FileSystemView.getFileSystemView();
    		String homePath = fileSystemView.getHomeDirectory().getPath();
    		jFileChooser.setCurrentDirectory(new File(homePath));
    		// 文件选择器显示文件和目录
    		jFileChooser.setFileSelectionMode(JFileChooser.DIRECTORIES_ONLY);
    
    		int showOpenDialog = jFileChooser.showOpenDialog(null);
    		if (showOpenDialog == jFileChooser.APPROVE_OPTION) { 
    			return jFileChooser.getSelectedFile().getAbsolutePath();
    		}else { 
    			System.exit(0);
    		}
    		return null;
    	}
    
    	public static void main(String[] args) throws IOException { 
    		Workbook workbook = getWorkbook(getFile());
    		Sheet sheet = workbook.getSheetAt(0);
    		Row row0 = sheet.createRow(0);
    		Cell cell00 = row0.createCell(0);
    		cell00.setCellValue("我是表头");
    		// 合并单元格，参数依次为起始行，结束行，起始列，结束列 （索引0开始）
    		sheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 5));// 标题合并单元格操作，6为总列数
    		FileOutputStream fileOutputStream = new FileOutputStream(new File(getFilePath() + "/" + "导出的excel.xlsx"));
    		workbook.write(fileOutputStream);
    		fileOutputStream.close();
    	}
    }