com.platform.utils.excel

Class Excel2003Reader

java.lang.Object

com.platform.utils.excel.Excel2003Reader

All Implemented Interfaces:

org.apache.poi.hssf.eventusermodel.HSSFListener

public class Excel2003Reader
extends Object
implements org.apache.poi.hssf.eventusermodel.HSSFListener

Excel2003格式解析

Author:

lipengjun

Constructor Summary

Constructors

Constructor and Description
Excel2003Reader()

Method Summary

Modifier and Type	Method and Description
Map<Integer,List<String[]>>	getSheetData() 获取数据(多Sheet)
List<String[]>	getSheetData(Integer sheetIndex) 获取数据(单Sheet)
void	process(InputStream fileStream) 遍历excel下所有的sheet
void	processRecord(org.apache.poi.hssf.record.Record record) HSSFListener 监听方法，处理 Record

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

Excel2003Reader

public Excel2003Reader()

Method Detail

process

public void process(InputStream fileStream)
             throws IOException

遍历excel下所有的sheet

Parameters:

fileStream - 处理文件流

Throws:

IOException - 抛出IO异常

processRecord

public void processRecord(org.apache.poi.hssf.record.Record record)

HSSFListener 监听方法，处理 Record

Specified by:

processRecord in interface org.apache.poi.hssf.eventusermodel.HSSFListener

Parameters:

record - 行记录

getSheetData

public List<String[]> getSheetData(Integer sheetIndex)

获取数据(单Sheet)

Parameters:

sheetIndex - sheet下标

Returns:

List 数据

getSheetData

public Map<Integer,List<String[]>> getSheetData()

获取数据(多Sheet)

Returns:

Map> 多sheet的数据