FileInputStream excelFile = new FileInputStream(excelPath);

Workbook workbook = Workbook.getWorkbook(excelFile);

Sheet excelSheet = workbook.getSheet(sheetName);

int rows = excelSheet.getRows();//行数

Cell[] cell = excelSheet.getRow(0);// 获得第一行的所有单元格

int columnNum = cell.length; // 单元格的个数 值 赋给 列数

public static String ReadData(Sheet excelSheet, int row, int col){

        try{

            String CellData= "";

            Cell cell = excelSheet.getRow(row)[col];

            CellData = cell.getContents().toString();

            return CellData;

        }catch(Exception e){

            return "";

        }

    }

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.IOException;

import jxl.Cell;

import jxl.Sheet;

import jxl.Workbook;

import jxl.read.biff.BiffException;

public class jxlExcel {

    public static void main(String[] args) throws IOException {

        String excelPath = "F:\\login.xls";

        String sheetName = "001";

        try{

            FileInputStream excelFile = new FileInputStream(excelPath);

            Workbook workbook = Workbook.getWorkbook(excelFile);

            Sheet excelSheet = workbook.getSheet(sheetName);

            int rows = excelSheet.getRows();//行数

            Cell[] cell = excelSheet.getRow(0);// 获得第一行的所有单元格

            int columnNum = cell.length; // 单元格的个数 值 赋给 列数

            for(int row = 0;row< rows; ++row){

                for (int col =0; col < columnNum; ++col){

                    System.out.print(ReadData(excelSheet, row, col) + ' ');

                    if(col ==1)

                        System.out.println();

                }

            }

            workbook.close();

        }catch (FileNotFoundException e ){

            System.out.println("找不到该文件");

        } catch (BiffException e) {

            e.printStackTrace();

        }

    }

    public static String ReadData(Sheet excelSheet, int row, int col){

        try{

            String CellData= "";

            Cell cell = excelSheet.getRow(row)[col];

            CellData = cell.getContents().toString();

            return CellData;

        }catch(Exception e){

            return "";

        }

    }

}