jsp 读EXCEL文件?

yuan_water 2005-05-23 11:31:07

请问各位仁兄,有什么样简单而实用的的方法能够实现JSP从EXCEL文档读数据到ACCESS DB中.

...全文

248 14 打赏收藏转发到动态举报

写回复

用AI写文章

14 条回复

切换为时间正序

请发表友善的回复…

发表回复

NBLee 2005-05-24

打赏
举报

http://www-128.ibm.com/developerworks/cn/java/l-javaExcel/index.html

xuliduo 2005-05-24

打赏
举报

直接用IO流，把Excel作成用“,”分割的文件就好了

yuan_water 2005-05-24

打赏
举报

jxl 的代码有吗?

poi 对我来说更陌生了?

wzy19514 2005-05-24

打赏
举报

laughsmile 2005-05-24

打赏
举报

这是用poi

laughsmile 2005-05-24

打赏
举报

package cn.founder.tokubai.business.pdu;
import java.io.*;
import java.util.*;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.poifs.filesystem.*;
public class test {
private HSSFWorkbook poiWorkbook = null;
private HSSFSheet poiSheet = null;
private int curLine = 0;
private Vector vContent = null;
void importExcel(){
vContent= new Vector();
String strFileName = "";
POIFSFileSystem fs = null;
try{
fs = new POIFSFileSystem(new FileInputStream(strFileName));
poiWorkbook = new HSSFWorkbook(fs);
//默认读取第一个 sheet
poiSheet = poiWorkbook.getSheetAt(0);
if (poiSheet == null){
return ;
}
} catch (IOException e){
poiWorkbook = null;
}
while (readNextRecord()){
//.....
}

}

boolean readNextRecord(){
int lineIndex = poiSheet.getFirstRowNum() + curLine;
curLine ++;
if (lineIndex > poiSheet.getLastRowNum()){
return false;
}
HSSFRow row = poiSheet.getRow(lineIndex);
//此行为空行
if (row == null){
return true;
}
HSSFCell cell = null;
for (short iCell = row.getFirstCellNum(); iCell <= row.getLastCellNum(); iCell ++){
cell = row.getCell(iCell);
if (cell == null){
vContent.add("");
continue;
}
vContent.add(formatCellToString(cell));
}
return true;
}
String formatCellToString(HSSFCell cell){
String strCell = "";
switch (cell.getCellType()) {
case HSSFCell.CELL_TYPE_NUMERIC:strCell = String.valueOf(cell.getNumericCellValue());
break;
case HSSFCell.CELL_TYPE_STRING:strCell = cell.getStringCellValue();
break;
case HSSFCell.CELL_TYPE_BOOLEAN:strCell = String.valueOf(cell.getBooleanCellValue());
break;
default:strCell = ""; break;
}
return strCell.trim();
}
}

yuan_water 2005-05-24