- import java.io.File;
- import java.io.FileInputStream;
- import org.apache.poi.hssf.usermodel.HSSFRow;
- import org.apache.poi.hssf.usermodel.HSSFSheet;
- import org.apache.poi.hssf.usermodel.HSSFWorkbook;
- public class poiDemo {
- public static void main(String[] args) {
- try {
- showExcel();
- } catch (Exception e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- public static void showExcel() throws Exception {
- HSSFWorkbook workbook=new HSSFWorkbook(new FileInputStream(new File("c:/新建 Microsoft Excel 工作表.xls")));
- HSSFSheet sheet=null;
- for (int i = 0; i < workbook.getNumberOfSheets(); i++) {
- sheet=workbook.getSheetAt(i);
- for (int j = 0; j < sheet.getPhysicalNumberOfRows(); j++) {
- HSSFRow row=sheet.getRow(j);
- for (int k = 0; k < row.getPhysicalNumberOfCells(); k++) {
- System.out.print(row.getCell(k)+"\\t");
- }
- System.out.println();
- }
- }
- }
- }
- //该片段来自于http://www.codesnippet.cn/detail/050820134957.html
来源: http://www.codesnippet.cn/detail/050820134957.html