选择多个文件 需要设置属性 setMultiSelectionEnabled(true); 默认是单选。
JFileChooser dialog = new JFileChooser(); dialog.setMultiSelectionEnabled(true);
单表导入
try {
JFileChooser dialog = new JFileChooser();
dialog.setDialogTitle("打开");
dialog.setMultiSelectionEnabled(true);
dialog.setFileSelectionMode(JFileChooser.FILES_ONLY);
dialog.setDialogType(JFileChooser.SAVE_DIALOG);
dialog.setFileFilter(new FileNameExtensionFilter("Excel文件", "xlsx"));
if(dialog.showSaveDialog(new JLabel()) == JFileChooser.APPROVE_OPTION){
File[] files = dialog.getSelectedFiles();
AggAssesVO[] aggvoList = new AggAssesVO[files.length];
for(int i = 0;i<files.length;i++){
//新建单表包装类
AggAssesVO aggvo = new AggAssesVO();
File file = files[i];
//得到文件全名
String filePath = file.getAbsolutePath();
//得到文件输入流
FileInputStream is = new FileInputStream(filePath);
//获得Excel
//HSSFWorkbook workbook = new HSSFWorkbook(is); 这个是针对 xls文件
XSSFWorkbook workbook = new XSSFWorkbook(is);
//获得第一个Excel表格,为注销核准主表
XSSFSheet sheet1 = workbook.getSheetAt(0);
if(null==sheet1 ){
ExceptionUtils.wrappBusinessException("请检查导入数据!");
}
//获取查询方法公共类
HYPubBO hyb = new HYPubBO();
int lastRow1 = sheet1.getLastRowNum();
//取第一个工作簿主表数据
XSSFRow row1 = sheet