package my.pack;
import java.io.File;
import java.io.IOException;
import java.util.Locale;
import jxl.Sheet;
import jxl.Workbook;
import jxl.WorkbookSettings;
import jxl.read.biff.BiffException;
public class JExcelTest {
public static void main(String[] args) {
try {
WorkbookSettings ws = new WorkbookSettings();
ws.setEncoding("UTF-8");
ws.setLocale(Locale.FRANCE);
File file = new File("data.xls");
Workbook wb = Workbook.getWorkbook(file, ws);
Sheet s = wb.getSheet(0);
for(int i=0; i< s.getRows(); i++) {
for(int j=0; j< s.getColumns(); j++) {
System.out.println("[lig="+i+"/col="+j+"] "+ s.getCell(j, i).getContents());
}
}
} catch (BiffException e) {
System.err.println(e.toString());
} catch (IOException e) {
System.err.println(e.toString());
}
}
}
Partager