在实际开发过程中,我们经常需要导出数据,导入数据,无可避免的就要使用到excel,知道它的使用场景就开始我们的第一个Demo
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.9</version>
</dependency>
ps:本操作实在.xls格式下进行的,请注意
//创建工作簿
HSSFWorkbook workbook = new HSSFWorkbook() ;
//设置保存入径
String filePath= "D:\\TEST.xls";
//工作类
HSSFSheet sheet = workbook.createSheet("tanoak");
HSSFRow rows = sheet.createRow(0) ;
HSSFCell cell = rows.createCell(0);
cell.setCellValue("张三");
rows.createCell(1).setCellValue("男");
rows.createCell(2).setCellValue(28);
FileOutputStream fileOutputSteam = new FileOutputStream(filePath);
workbook.write(fileOutputSteam);
System.out.println("保存成功");
fileOutputSteam.close();
String filePath= "D:\\TEST.xls";
String text="";
FileInputStream is = new FileInputStream(filePath);
HSSFWorkbook excel=new HSSFWorkbook(is);
//获取第一个sheet
HSSFSheet sheet0=excel.getSheetAt(0);
for (Iterator rowIterator = sheet0.iterator(); rowIterator.hasNext();) {
HSSFRow row=(HSSFRow) rowIterator.next();
for (Iterator iterator=row.cellIterator();iterator.hasNext();) {
HSSFCell cell=(HSSFCell) iterator.next();
//根据单元的的类型 读取相应的结果
if(cell.getCellType()==HSSFCell.CELL_TYPE_STRING) text+=cell.getStringCellValue()+"\t";
else if(cell.getCellType()==HSSFCell.CELL_TYPE_NUMERIC) text+=cell.getNumericCellValue()+"\t";
else if(cell.getCellType()==HSSFCell.CELL_TYPE_FORMULA) text+=cell.getCellFormula()+"\t";
}
}
System.out.println(text);
下一篇文章将使用EasyPoi 来操作,带你体验操作之美