有谁用过POI,请问POI能用于WEB吗 请用过POI的朋友指教。POI能用在WEB中吗?怎么用?最好有例子。EMAIL:[email protected] 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 Poi是java中用于excel处理的第三方包,当然可以用于web.如下:jsp 读EXCEL文件: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(); }} java基础,问题 新手请教! 请问,关于时间周期执行问题,谢谢各位! javaBean哦~~郁闷! 学习上遇到麻烦了,请大家给个建议啊 谁能把vc++的一段代码,转成java 关于JLabel的移动问题。 float數據類型的表示薪水范圍該怎麼樣理解? JAVA的GUI事件处理 JComoBox选择的元素无法连接数据库 十分困惑,请教java中函数的传参方式。 用eclipse编译Azureus源代码的问题
jsp 读EXCEL文件:
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();
}
}