package com.iss.ecommerce.card.util;
import java.io.FileInputStream;
import java.io.InputStream;
import jxl.Sheet;
import jxl.Workbook;
public class ExcelUtil {
/**
* 得到Workbook对象
* @param filePath
*/
public Workbook parseExeclFile(String filePath) {
Workbook work = null;
try {
InputStream is = new FileInputStream(filePath);
work = Workbook.getWorkbook(is);
} catch (Exception e) {
e.printStackTrace();
}
return work;
}
/**
* 得到Sheet,下标从0开始
* @param number
* @return
*/
public Sheet getSheet(Workbook work, int number){
Sheet sheet = null;
try {
sheet = work.getSheet(number);
} catch (IndexOutOfBoundsException e) {
e.printStackTrace();
}
return sheet;
}
/**
* 得到总行数
* @param sheet
* @return
*/
public int getRows(Sheet sheet){
int rows = sheet.getRows();
return rows;
}
/**
* 得到总列数
* @param sheet
* @return
*/
public int getColumns(Sheet sheet){
int columns = sheet.getColumns();
return columns;
}
/**
* 得到某行某列数据
* @param sheet
* @param row
* @param column
* @return
*/
public String getData(Sheet sheet, int row, int column){
String data = sheet.getCell(column, row).getContents();
return data;
}
}