用java语言写一段excel导入导出代码
时间: 2023-03-13 19:00:20 浏览: 60
答:下面是示例代码,请参考:String fileName = "data.xlsx";FileInputStream fis = new FileInputStream(new File(fileName));XSSFWorkbook workbook = new XSSFWorkbook(fis);XSSFSheet sheet = workbook.getSheetAt(0);Iterator rows = sheet.rowIterator();while (rows.hasNext()) {
XSSFRow row = (XSSFRow) rows.next();
Iterator cells = row.cellIterator();
while (cells.hasNext()) {
XSSFCell cell = (XSSFCell) cells.next();
if(cell.getCellType() == XSSFCell.CELL_TYPE_STRING){
System.out.print(cell.getStringCellValue()+" ");
}
else if(cell.getCellType() == XSSFCell.CELL_TYPE_NUMERIC){
System.out.print(cell.getNumericCellValue()+" ");
}
else{
//U Can Handel Boolean, Formula, Errors
}
}
System.out.println();
}FileOutputStream fos =new FileOutputStream(new File("data.xlsx"));
workbook.write(fos);
fos.close();