package file;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
public class testExcelFile {
public static void main(String[] args) {
testExcelFile obj = new testExcelFile();
// 我创建Excel路径为:E:/JAVA学习
File file = new File("E:/JAVA学习/Book1.xls");
obj.readExcel(file);
}
//读取excel的方法 ,方法的参数为一个File对象
public void readExcel(File file) {
try {
// 创建输入流,读取Excel getAbsolutePath()文件的绝对路径
InputStream is = new FileInputStream(file.getAbsolutePath());
// jxl提供的Workbook类
Workbook wkb = Workbook.getWorkbook(is);
// Excel的页签数量
int size = wkb.getNumberOfSheets();
for (int i = 0; i < size; i++) {
// 每页签创建一个Sheet对象
Sheet sheet = wkb.getSheet(i);
// sheet.getRows()返回该页的总行数
for (int j = 0; j < sheet.getRows(); j++) {
// sheet.getColumns()返回该页的总列数
for (int k = 0; k < sheet.getColumns(); k++) {
String cellinfo = sheet.getCell(k, j).getContents();
//打印excel中的信息
System.out.println(cellinfo);
}
}
}
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (BiffException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
}
}