jxl.jar
链接:https://pan.baidu.com/s/1ypnjpBr7JsiGPwgKwqZXxg?pwd=rk6q
提取码:rk6q
poi.jar
链接:https://pan.baidu.com/s/1gKMnI9trBU_BNEwXM9x5BA?pwd=2igg
提取码:2igg
jxl读取Excel
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
public class Test_Jxl {
public static void readColumn(File file, int index) throws Exception {
InputStream inputStream = new FileInputStream(file.getAbsoluteFile());
// 新建并获取工作薄
Workbook workbook = Workbook.getWorkbook(inputStream);
// 读取工作表:index从0开始,0对应Sheet1
Sheet sheet = workbook.getSheet(0);
// 获取Excel行数
int rows = sheet.getRows();
// 获取Excel列数
int columns = sheet.getColumns();
for (int i = 0; i < rows; i++) {
// 获取单元格
Cell cell = sheet.getCell(index, i);
// 读取单元格内容
System.out.println(cell.getContents());
}
}
public static void main(String[] argS) {
File file = new File("C:\\Users\\Administrator\\Desktop\\test_jxl.xls");
try {
readColumn(file, 0);
} catch (Exception e) {
e.printStackTrace();
}
}
}
poi读取Excel
实例为.xls,若想读取.xlsx将所有HSSF换位XSSF
import java.io.FileInputStream;
import java.io.InputStream;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.CellType;
public class Test_Poi {
public static void main(String[] args) throws Exception {
String fileName = "C:\\Users\\Administrator\\Desktop\\test_jxl.xls";
String sheetName = "Sheet1";
readExcelData(fileName, sheetName, 0);
}
public static void readExcelData(String fileName, String sheetName,
int cellnum) throws Exception {
InputStream inputStream = new FileInputStream(fileName);
HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
HSSFSheet sheet = workbook.getSheet(sheetName);
// 获取总行数
int physicalNumberOfRows = sheet.getPhysicalNumberOfRows();
// 获取总列数
// int physicalNumberOfCells = row.getPhysicalNumberOfCells();
for (int i = 0; i < physicalNumberOfRows; i++) {
// 定位到i行
HSSFRow row = sheet.getRow(i);
// 定位到i行cellnum列
HSSFCell cell = row.getCell(cellnum);
// 设置单元格格式
cell.setCellType(CellType.STRING);
System.out.println(cell.getStringCellValue());
}
}
}