poi读取excel
package ;import ;
import ;
import ;
import ;
import ;
import ;
import ;
import ;import ;
import ;
import ;
import ;
import ;
import ;public class ReadExcel {
private POIFSFileSystem fs;
private HSSFWorkbook wb;
private HSSFSheet sheet;
private HSSFRow row;
//private int hssfrow = 0; /**
* 读取Excel表格表头的内容
* ***@ps 1. 首行不能为空、 2. 当有单元合并的时候,计算有问题
* ***@param InputStream
* ***@return String 表头内容的数组
*/
***@SuppressWarnings("deprecation")
public String[] readExcelTitle(InputStream is) {
try {
fs = new POIFSFileSystem(is);
wb = new HSSFWorkbook(fs);
} catch (IOException e) {
();
}
sheet = (0);
row = (0);
// 标题总列数
int colNum = ();
("colNum:" + colNum);
String[] title = new String[colNum];
for (int i = 0; i colNum; i++) {
title[i] = getCellFormatValue(((short) i));
}
return title;
} /**
* 读取Excel数据内容
*
* ***@param InputStream
* ***@return Map 包含单元格数据内容的Map对象
*/
***@SuppressWarnings("deprecation")
public Map readExcelContent(InputStream is) {
Map content = new HashMap();
String str = "";
try {
fs = new POIFSFileSystem(is);
wb = new HSSFWorkbook(fs);
} catch (IOException e) {
();
}
sheet = (0);
// 得到总行数
int rowNum = ();
row = (0);
int colNum = ();
// 正文内容应该从第二行开始,第一行为表头的标题
for (int i = 1; i rowNum; i++) {
ro
poi读取excel 来自淘豆网www.taodocs.com转载请标明出处.