【现象】
代码如下:
public static void main(String[] args) throws IOException {Date now=new Date();SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMddHHmmss");String localname=dateFormat.format(now);String xlsxPath = "d:\\"+ localname + ".xlsx";HSSFWorkbook workBook = new HSSFWorkbook();OutputStream fos = null;try {//增加一个Sheet的对象HSSFSheet sheet = workBook.createSheet("sheet1");HSSFRow row = sheet.createRow(0);row.createCell(0).setCellValue("aaaaaaaa");fos = new FileOutputStream(xlsxPath);} catch (FileNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}workBook.write(fos);fos.close();}
【解决方法】
public static void main(String[] args) throws IOException {Date now=new Date();SimpleDateFormat dateFormat = new SimpleDateFormat("yyyyMMddHHmmss");String localname=dateFormat.format(now);String xlsxPath = "d:\\"+ localname + ".xlsx";XSSFWorkbook workBook = new XSSFWorkbook();OutputStream fos = null;try {//增加一个Sheet的对象XSSFSheet sheet = workBook.createSheet("sheet1");XSSFRow row = sheet.createRow(0);row.createCell(0).setCellValue("aaaaaaaa");fos = new FileOutputStream(xlsxPath);} catch (FileNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();}workBook.write(fos);fos.close();}
poi导出xlsx文件后 打开报“因为文件格式或文件扩展名无效。请确定文件未损坏 并且文件扩展名与文件的格式匹配。”的解决方法