/**获得数据*/
public static String getDataOfFile(){
StringBuffer sbf = new StringBuffer();
/*得到EXCEL文件的物理路径*/
String filepath = "F:/job/Z_Applet/bin/applet.xls";
try {
InputStream inStrm = new FileInputStream(filepath);
Workbook rwb = Workbook.getWorkbook(inStrm);
Sheet sheet = rwb.getSheet("基金折溢价率");
Cell cell = null;
for(int i=0;i<sheet.getRows();i++){
String[] data = new String [2];
for(int j=0;j<sheet.getColumns();j++){
//得到一个单元格
cell = sheet.getCell(j,i);
switch(j){
case 0:
data[0]=cell.getContents();
sbf.append(data[0]+" ' ");
break;
case 1:
data[1] = cell.getContents();
sbf.append(data[1]+"/r/n");
break;
}
}//end for
}//end for
} catch (Exception e) {
e.printStackTrace();
}
return sbf.toString();
}
public static String getDataOfFile(){
StringBuffer sbf = new StringBuffer();
/*得到EXCEL文件的物理路径*/
String filepath = "F:/job/Z_Applet/bin/applet.xls";
try {
InputStream inStrm = new FileInputStream(filepath);
Workbook rwb = Workbook.getWorkbook(inStrm);
Sheet sheet = rwb.getSheet("基金折溢价率");
Cell cell = null;
for(int i=0;i<sheet.getRows();i++){
String[] data = new String [2];
for(int j=0;j<sheet.getColumns();j++){
//得到一个单元格
cell = sheet.getCell(j,i);
switch(j){
case 0:
data[0]=cell.getContents();
sbf.append(data[0]+" ' ");
break;
case 1:
data[1] = cell.getContents();
sbf.append(data[1]+"/r/n");
break;
}
}//end for
}//end for
} catch (Exception e) {
e.printStackTrace();
}
return sbf.toString();
}