2. 二进制格式的csv或xls文件 Java代码
import jxl.Sheet;
import jxl.Workbook;
import jxl.Sheet;
import jxl.Workbook;
Java代码
public void importXlsFile() {
Workbook book = null;
try { book = Workbook.getWorkbook(importFile);//importFile为要导入的xls文件,或二进制的csv文件,提供getXX/setXX方法
} catch (Exception e) {
e.printStackTrace();
}
if(book != null){
int sheetNo = book.getNumberOfSheets();
for(int i = 0; i < sheetNo; i++){
Sheet sheet=book.getSheet(i);
int rowNum = sheet.getRows();
int colNum = sheet.getColumns(); //first row is title, so past
for(int r = 1; r < rowNum; r++){//行
for(int c = 0; c < colNum;c++){//列
String temp = sheet.getCell(c,r).getContents();
switch (c) {
case 0: if(StringUtils.isNotEmpty(temp)){
linkman.setLinkmanName(temp);
} break;
case 1: if(StringUtils.isNotEmpty(temp)){
linkman.setLinkmanEmail(temp);
} break; default: break; } } //保存linkman到数据库
if(linkman.getLinkmanName() != null && linkman.getLinkmanEmail() != null){
EmailLinkmanAPI.insertLinkman(linkman);