用java写一个读取excel2007的方法类
时间: 2023-05-11 10:06:18 浏览: 55
可以使用Apache POI库来读取Excel 2007文件,以下是一个示例方法:
```java
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ExcelReader {
public static void readExcel(String filePath) throws IOException {
FileInputStream inputStream = new FileInputStream(new File(filePath));
XSSFWorkbook workbook = new XSSFWorkbook(inputStream);
int numberOfSheets = workbook.getNumberOfSheets();
for (int i = 0; i < numberOfSheets; i++) {
System.out.println("Sheet name: " + workbook.getSheetName(i));
for (Row row : workbook.getSheetAt(i)) {
for (Cell cell : row) {
System.out.print(cell.toString() + "\t");
}
System.out.println();
}
}
workbook.close();
inputStream.close();
}
}
```
你可以将Excel文件的路径作为参数传递给readExcel方法,它将打印出每个工作表的名称和单元格的内容。