import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
public class AnalyticExcel2 {
public static void main(String[] args) throws BiffException, IOException {
InputStream is = new FileInputStream("D:\\Project6\\A\\src\\Analytic\\doc\\C.xls");
try {
Workbook wb = Workbook.getWorkbook(is);
int wbNum = wb.getNumberOfSheets();
for(int i = 0;i
String sheetName = sheet.getName();
System.out.println("sheetName="+sheetName);
// 获取表格总列数
int rsColumns = sheet.getColumns();
// 获取表格总行数
int rsRows = sheet.getRows();
//循环文件里的数据
for(int j=0;j
for(int k=0;k
}
System.out.println();
}
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
作者：Heng_Ji