读取 Excel 不同于一般文件:
(在你有 Jxl 包的前提下)
try {
Workbook workbook = Workbook.getWorkbook(new File(C:\\Book1.xls)); Sheet sheet = workbook.getSheet(0); Cell cell;
StringBuffer buffer = new StringBuffer(); for (int i = 0; i < sheet.getRows(); i++) { buffer.delete(0, buffer.length()); for (int j = 0; j < sheet.getColumns(); j++) {
cell = sheet.getCell(j, i);
buffer.append(cell.getContents().trim()+"-");
} System.out.println (buffer.toString());
} workbook.close(); } catch (Exception e) {
e.printStackTrace();
}
(在你有 Jxl 包的前提下)
try {
Workbook workbook = Workbook.getWorkbook(new File(C:\\Book1.xls)); Sheet sheet = workbook.getSheet(0); Cell cell;
StringBuffer buffer = new StringBuffer(); for (int i = 0; i < sheet.getRows(); i++) { buffer.delete(0, buffer.length()); for (int j = 0; j < sheet.getColumns(); j++) {
cell = sheet.getCell(j, i);
buffer.append(cell.getContents().trim()+"-");
} System.out.println (buffer.toString());
} workbook.close(); } catch (Exception e) {
e.printStackTrace();
}
这一步就报异常:
java.lang.NoClassDefFoundError: common/Logger
at jxl.WorkbookSettings.<clinit>(WorkbookSettings.java:40)
at jxl.Workbook.getWorkbook(Workbook.java:187)
at jxl.TestExcel.main(TestExcel.java:29)
Exception in thread "main"
很奇怪程序没有报关于找不到jxl的错,我想jxl的设置应该不会有什么问题吧。
import java.io.*; // 必须的
import jxl.*; // 打开一个xls文件
import jxl.write.*; //写新的xls文件的话public ExcelOperate(String s) {
try {
workbook = Workbook.getWorkbook(new File(s)); // 打开一个xls文件
} catch (Exception e) {
System.out.println(e);
}
sheetName = new String[workbook.getNumberOfSheets()]; // 返回所有表的名称,保存在sheetName 数组中
sheet = workbook.getSheets();
for (int i = 0; i < sheet.length; i++)
sheetName[i] = sheet[i].getName(); }