poi读取excel文件

最新推荐文章于 2024-07-05 14:30:10 发布

妙手无bug

最新推荐文章于 2024-07-05 14:30:10 发布

阅读量143

点赞数

文章标签： Apache POI Excel读取 SQL插入 Java编程数据处理

本文链接：https://blog.csdn.net/qq_44124547/article/details/118902535

版权

private XSSFSheet sheet;

/**
 * 构造函数，初始化excel数据
 * @param filePath  excel路径
 * @param sheetName sheet表名
 */
Test(String filePath,String sheetName){
	FileInputStream fileInputStream = null;
	try {
		fileInputStream = new FileInputStream(filePath);
		XSSFWorkbook sheets = new XSSFWorkbook(fileInputStream);
		//获取sheet
		sheet = sheets.getSheet(sheetName);
	} catch (Exception e) {
		e.printStackTrace();
	}
}

//打印excel数据
public void readTest(){
	//获取行数
	int rows = sheet.getPhysicalNumberOfRows();
	for(int i=0;i<rows;i++){
		//获取列数
		XSSFRow row = sheet.getRow(i);
		String xx = row.getCell(0).toString().replace(".0", "");
		String name = row.getCell(1).toString();
		String cx = row.getCell(2).toString().replace(".0", "");


		String sql = "INSERT INTO `t_bsedu_subunits`( `unitname`,  `bsfid`, `cxfid`) VALUES ('"+name+"',"+xx+","+cx+");";
		System.out.println(sql);
	}
}

//测试方法
public static void main(String[] args){
	Test sheet1 = new Test("D:\\浏览器\\.xlsx", "sheet1");
	sheet1.readTest();

}