excel 读取 java代码_java 读写excel 示例代码

最新推荐文章于 2022-09-19 17:32:44 发布

智芯融

最新推荐文章于 2022-09-19 17:32:44 发布

阅读量110

点赞数

文章标签： excel 读取 java代码

本文链接：https://blog.csdn.net/weixin_42522552/article/details/114496209

版权

【实例简介】

【实例截图】

【核心代码】

package com.nnu.yd.pink.util;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;

import org.apache.poi.hssf.usermodel.HSSFSheet;

import org.apache.poi.hssf.usermodel.HSSFRow;

import org.apache.poi.hssf.usermodel.HSSFCell;

import org.apache.poi.xssf.usermodel.XSSFRow;

import org.apache.poi.xssf.usermodel.XSSFSheet;

import org.apache.poi.xssf.usermodel.XSSFWorkbook;

import com.nnu.yd.pink.constant.PinkConstant;

import com.nnu.yd.pink.entity.ActivityReport;

import com.nnu.yd.pink.entity.DownLoad;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.FileOutputStream;

import java.io.IOException;

import java.io.InputStream;

import java.io.OutputStream;

import java.util.Iterator;

import java.util.List;

import java.util.ArrayList;

public class ExcelUtil {

public static List readExcel2007_Down(InputStream in,

int gid, int gradeid) {

InputStream fis = in;

List sheetData = new ArrayList();

try {

XSSFWorkbook xwb = new XSSFWorkbook(in);

// 读取第一章表格内容

XSSFSheet sheet = xwb.getSheetAt(0);

// 定义 row、cell

XSSFRow row;

String cell;

// 循环输出表格中的内容

for (int i = sheet.getFirstRowNum(); i < sheet

.getPhysicalNumberOfRows(); i ) {

DownLoad u = new DownLoad();

row = sheet.getRow(i);

if (i != 0) {

//u.setUsername(row.getCell(0).toString());

//u.setAge(Integer.parseInt(row.getCell(1)

//.getRichStringCellValue().getString()));

//if (row.getCell(2).toString().equals("男")) {

//u.setSex("0");

//} else {

//u.setSex("1");

//}

//List ls = new ArrayList();

//u.setLs(ls);

//u.setGid(gid);

//u.setGradeid(gradeid);

// u.setDegree(row.getCell(4).toString());

// u.setMobile(row.getCell(5).toString());

// u.setResume(row.getCell(6).toString());

// u.setGid(cid);

sheetData.add(u);

}

} catch (IOException e) {

e.printStackTrace();

} finally {

if (fis != null) {

try {

fis.close();

} catch (IOException e) {

e.printStackTrace();

}

return sheetData;

}

//public static List readExcel2007(InputStream in, int cid) {

//InputStream fis = in;

//List sheetData = new ArrayList();

//try {

//XSSFWorkbook xwb = new XSSFWorkbook(in);

读取第一章表格内容

//XSSFSheet sheet = xwb.getSheetAt(0);

定义 row、cell

//XSSFRow row;

//String cell;

循环输出表格中的内容

//for (int i = sheet.getFirstRowNum(); i < sheet

//.getPhysicalNumberOfRows(); i ) {

//ActivityReport u = new ActivityReport();

//row = sheet.getRow(i);

//if (i != 0) {

//u.setUsername(row.getCell(0).toString());

//u.setDuty(row.getCell(1).toString());

//if (row.getCell(2).toString().equals("男")) {

//u.setSex("0");

//} else {

//u.setSex("1");

//}

//u.setAge(Integer.parseInt(row.getCell(3).getRawValue()));

//u.setDegree(row.getCell(4).toString());

//u.setMobile(row.getCell(5).toString());

//u.setResume(row.getCell(6).toString());

//u.setGid(cid);

//sheetData.add(u);

//}

//} catch (IOException e) {

//e.printStackTrace();

//} finally {

//if (fis != null) {

//try {

//fis.close();

//} catch (IOException e) {

//e.printStackTrace();

//}

//return sheetData;

//}

//public static List readExcel2003(InputStream in, int cid) {

//InputStream fis = in;

//List sheetData = new ArrayList();

//try {

获得一个excel实例

//HSSFWorkbook workbook = new HSSFWorkbook(fis);

取得excel文件的第一个工作表

//HSSFSheet sheet = workbook.getSheetAt(0);

通过迭代器遍历获得行数据后遍历行数据获得单元格数据，并保存在列表sheetData中

//Iterator rows = sheet.rowIterator();

//int i = 0;

//while (rows.hasNext()) {

//if (i != 0) {

//HSSFRow row = (HSSFRow) rows.next();

//Iterator cells = row.cellIterator();

//WebTeacher u = new WebTeacher();

//HSSFCell cell = (HSSFCell) cells.next();

//u.setUsername(cell.getStringCellValue());