import java.io.File;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
public class ReadExcel {
public static void main(String args[]) {
try
{
Workbook book = Workbook.getWorkbook( new File( "d:/TestFile/02.xls" ));
// 获得第一个工作表对象
Sheet sheet = book.getSheet(0);
// 得到第一列第一行的单元格
for(int i=0;i<sheet.getRows();i++)
{
for(int j=0;j<sheet.getColumns();j++)
{
Cell cell1 = sheet.getCell(j, i);
String result = cell1.getContents();
System.out.print(result+" ");
}
System.out.println();
}
book.close();
}
catch (Exception e)
{
System.out.println(e);
}
}
}
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
public class ReadExcel {
public static void main(String args[]) {
try
{
Workbook book = Workbook.getWorkbook( new File( "d:/TestFile/02.xls" ));
// 获得第一个工作表对象
Sheet sheet = book.getSheet(0);
// 得到第一列第一行的单元格
for(int i=0;i<sheet.getRows();i++)
{
for(int j=0;j<sheet.getColumns();j++)
{
Cell cell1 = sheet.getCell(j, i);
String result = cell1.getContents();
System.out.print(result+" ");
}
System.out.println();
}
book.close();
}
catch (Exception e)
{
System.out.println(e);
}
}
}