原文链接:Java实现Excel操作(PoiExcel导出导入)
PoiExcel数据的导入导出,实现方法。引入对应maven依赖文件如下:
##<!–依赖包–>
##<!–依赖包–><!--导入poi解析-->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.9</version>
</dependency>
<!--apache的io处理-->
<dependency>
<groupId>org.apache.directory.studio</groupId>
<artifactId>org.apache.commons.io</artifactId>
<version>2.4</version>
</dependency>
##<!–数据导出–>
/**
* 类描述:poi生成excel文件
* Created by 李泽阳 on 2019/4/25
*/
public class PoiExpExcel {
public static void poiExp() throws Exception {
String[] title = {"poi", "name", "sex"};
HSSFWorkbook workbook = new HSSFWorkbook();//创建Excel工作簿
HSSFSheet sheet = workbook.createSheet();//创建一个工作表sheet
HSSFRow row = sheet.createRow(0);//创建第一行
HSSFCell cell = null;//创建单元格
//插入第一行数据、id、name、sex
for (int i = 0; i < title.length; i++) {
cell = row.createCell(i);
cell.setCellValue(title[i]);
}
//追加数据
for (int i = 1; i < 10; i++) {
HSSFRow nextRow = sheet.createRow(i);//创建第二行单元格
HSSFCell cell2 = nextRow.createCell(0);
cell2.setCellValue("a" + i);
cell2 = nextRow.createCell(1);
cell2.setCellValue("user" + i);
cell2 = nextRow.createCell(2);
cell2.setCellValue("男" + i);
}
String i = "m";
//创建一个文件:文件路径名称可更新
File file = new File("c:/JavaExcel/" + i + "poi.xls");
FileOutputStream stream = FileUtils.openOutputStream(file);//文件流
workbook.write(stream);//写入流
stream.close();//关闭流
}
##<!–数据导入–>
/**
* 类描述:poi解析excel文件
* Created by 李泽阳 on 2019/4/25
*/
public class PoiReadExcel {
public static void readPoi() throws Exception {
File file = new File("c:/JavaExcel/poi.xls");//需要解析的Excel
HSSFWorkbook workbook = new HSSFWorkbook(FileUtils.openInputStream(file));//创建Excel,读取文件内容
//读取文件第一个sheet文件
//HSSFSheet sheet=workbook.getSheet("Sheet0");//通过文件名称获取
HSSFSheet sheet = workbook.getSheetAt(0);//通过下标获取文件,第一页
int firstRowNum = 0;
//获取sheet中最后一行行号
int lastRowNum = sheet.getLastRowNum();
for (int i = firstRowNum; i < lastRowNum; i++) {
HSSFRow row = sheet.getRow(i);
//获取行内单元格号
int lastCellNum = row.getLastCellNum();
for (int j = 0; j < lastCellNum; j++) {
HSSFCell cell = row.getCell(j);
String value = cell.getStringCellValue();
System.out.print(value);
}
}
}
}
相关文章:
文章链接:Java实现Excel操作(POI,JXL,FASTEXCEL)
文章链接:Java实现Excel操作(JxlExcel导出导入)
面向开发过程,记录学习之路。