jxl cell行列值获取

Question

jxl中如何获取cell的行列值？求方法

Answer 1

WorkbookSettings workbookSettings = new WorkbookSettings();
System.out.println(workbookSettings.getCharacterSet());
workbookSettings.setEncoding("iso-8859-1");
wb = Workbook.getWorkbook(new File(name), workbookSettings);
Sheet s = wb.getSheet(0);// 第1个sheet
System.out.println(s.getName());
Cell c;
int row = s.getRows();// 总行数
int col = s.getColumns();// 总列数
System.out.println(row + ":" + col);
for (int i = 0; i < row; i++) {
for (int j = 0; j < col; j++) {
c = s.getCell(j, i);
System.out.print(c.getContents() + " ");