与写对应的是读.
package
net.blogjava.chenlb;
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
/**
* jxl 的Excel阅读器.
* @author chenlb 2007-10-20 下午01:36:01
*/
public class JxlExcelReader {
/**
* @return 返回String[] 的列表
*/
public List readExcel(InputStream in) {
List lt = new ArrayList();
Workbook wb = null ;
try {
wb = Workbook.getWorkbook(in);
Sheet[] sheets = wb.getSheets(); // 获取工作
for ( int i = 0 ; i < sheets.length; i ++ ) {
Sheet sheet = sheets[i];
for ( int j = 0 ; j < sheet.getRows(); j ++ ) {
Cell[] cells = sheet.getRow(j); // 读取一行
if (cells != null && cells.length > 0 ) { // 这一行有内容才添加
String[] dataCells = new String[cells.length];
for ( int k = 0 ; k < cells.length; k ++ ) {
dataCells[k] = "" + cells[k].getContents(); // 读内容
} // column
lt.add(dataCells);
}
} // one sheet
} // xls file
} catch (BiffException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} finally {
if (wb != null ) {
wb.close();
}
}
return lt;
}
}
import java.io.IOException;
import java.io.InputStream;
import java.util.ArrayList;
import java.util.List;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
/**
* jxl 的Excel阅读器.
* @author chenlb 2007-10-20 下午01:36:01
*/
public class JxlExcelReader {
/**
* @return 返回String[] 的列表
*/
public List readExcel(InputStream in) {
List lt = new ArrayList();
Workbook wb = null ;
try {
wb = Workbook.getWorkbook(in);
Sheet[] sheets = wb.getSheets(); // 获取工作
for ( int i = 0 ; i < sheets.length; i ++ ) {
Sheet sheet = sheets[i];
for ( int j = 0 ; j < sheet.getRows(); j ++ ) {
Cell[] cells = sheet.getRow(j); // 读取一行
if (cells != null && cells.length > 0 ) { // 这一行有内容才添加
String[] dataCells = new String[cells.length];
for ( int k = 0 ; k < cells.length; k ++ ) {
dataCells[k] = "" + cells[k].getContents(); // 读内容
} // column
lt.add(dataCells);
}
} // one sheet
} // xls file
} catch (BiffException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
} finally {
if (wb != null ) {
wb.close();
}
}
return lt;
}
}