java 读取 excel 2003 或 excel 2007
<div style="border-right: #cccccc 1px solid; padding-right: 5px; border-top: #cccccc 1px solid; padding-left: 4px; font-size: 13px; padding-bottom: 4px; border-left: #cccccc 1px solid; width: 98%; padding-top: 4px; border-bottom: #cccccc 1px solid; background-color: #eeeeee;">http://www.blogjava.net/Images/OutliningIndicators/None.gifpackage com.common.website.util;
http://www.blogjava.net/Images/OutliningIndicators/None.gif
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport java.io.File;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport java.io.FileInputStream;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport java.io.IOException;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport java.io.InputStream;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport java.text.DecimalFormat;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport java.util.ArrayList;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport java.util.List;
http://www.blogjava.net/Images/OutliningIndicators/None.gif
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport org.apache.poi.hssf.usermodel.HSSFDateUtil;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport org.apache.poi.hssf.usermodel.HSSFWorkbook;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport org.apache.poi.ss.usermodel.Cell;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport org.apache.poi.ss.usermodel.Row;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport org.apache.poi.ss.usermodel.Sheet;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport org.apache.poi.ss.usermodel.Workbook;
http://www.blogjava.net/Images/OutliningIndicators/None.gifimport org.apache.poi.xssf.usermodel.XSSFWorkbook;
http://www.blogjava.net/Images/OutliningIndicators/None.gif
http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedBlock.gif/** *//**
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <ul>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Title:</li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Description: [支持Excell2003,Excell2007,自动格式化数值型数据,自动格式化日期型数据]</li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Copyright 2009 RoadWay Co., Ltd.</li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>All right reserved.</li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Created by [惠万鹏] </li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Midified by </li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif *
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>所需Jar包列表</li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>poi-3.6-20091214.jar</li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>poi-contrib-3.6-20091214.jar</li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>poi-examples-3.6-20091214.jar</li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>poi-ooxml-3.6-20091214.jar</li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>poi-ooxml-schemas-3.6-20091214.jar</li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>poi-scratchpad-3.6-20091214.jar</li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>xmlbeans-2.3.0.jar</li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <ul>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif *
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * @version 1.0
http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockEnd.gif */
http://www.blogjava.net/Images/OutliningIndicators/None.gifpublic class POIExcelUtil
http://www.blogjava.net/Images/OutliningIndicators/ExpandedBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedBlock.gifhttp://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//** 总行数 */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif private int totalRows = 0;
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//** 总列数 */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif private int totalCells = 0;
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//** 构造方法 */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif public POIExcelUtil()
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{}
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//**
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <ul>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Description:[根据文件名读取excel文件]</li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Created by </li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Midified by </li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <ul>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif *
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * @param fileName
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * @return
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * @throws Exception
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif public List<ArrayList<String>> read(String fileName)
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif List<ArrayList<String>> dataLst = new ArrayList<ArrayList<String>>();
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//** 检查文件名是否为空或者是否是Excel格式的文件 */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif if (fileName == null || !fileName.matches("^.+\\.(?i)((xls)|(xlsx))$"))
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif return dataLst;
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif boolean isExcel2003 = true;
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//** 对文件的合法性进行验证 */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif if (fileName.matches("^.+\\.(?i)(xlsx)$"))
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif isExcel2003 = false;
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//** 检查文件是否存在 */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif File file = new File(fileName);
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif if (file == null || !file.exists())
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif return dataLst;
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif try
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//** 调用本类提供的根据流读取的方法 */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif dataLst = read(new FileInputStream(file), isExcel2003);
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif catch (Exception ex)
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif ex.printStackTrace();
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//** 返回最后读取的结果 */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif return dataLst;
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//**
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <ul>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Description:[根据流读取Excel文件]</li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Created by </li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Midified by </li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <ul>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif *
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * @param inputStream
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * @param isExcel2003
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * @return
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif public List<ArrayList<String>> read(InputStream inputStream,
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif boolean isExcel2003)
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif List<ArrayList<String>> dataLst = null;
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif try
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//** 根据版本选择创建Workbook的方式 */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif Workbook wb = isExcel2003 ? new HSSFWorkbook(inputStream)
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif : new XSSFWorkbook(inputStream);
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif dataLst = read(wb);
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif catch (IOException e)
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif e.printStackTrace();
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif return dataLst;
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//**
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <ul>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Description:[得到总行数]</li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Created by </li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Midified by </li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <ul>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif *
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * @return
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif public int getTotalRows()
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif return totalRows;
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//**
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <ul>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Description:[得到总列数]</li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Created by </li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Midified by </li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <ul>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif *
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * @return
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif public int getTotalCells()
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif return totalCells;
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//**
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <ul>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Description:[读取数据]</li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Created by </li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <li>Midified by </li>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * <ul>
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif *
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * @param wb
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif * @return
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif private List<ArrayList<String>> read(Workbook wb)
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif List<ArrayList<String>> dataLst = new ArrayList<ArrayList<String>>();
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//** 得到第一个shell */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif Sheet sheet = wb.getSheetAt(0);
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif this.totalRows = sheet.getPhysicalNumberOfRows();
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif if (this.totalRows >= 1 && sheet.getRow(0) != null)
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif this.totalCells = sheet.getRow(0).getPhysicalNumberOfCells();
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//** 循环Excel的行 */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif for (int r = 0; r < this.totalRows; r++)
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif Row row = sheet.getRow(r);
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif if (row == null)
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif continue;
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif ArrayList<String> rowLst = new ArrayList<String>();
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//** 循环Excel的列 */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif for (short c = 0; c < this.getTotalCells(); c++)
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif Cell cell = row.getCell(c);
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif String cellValue = "";
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif if (cell == null)
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif{
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif rowLst.add(cellValue);
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif continue;
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockEnd.gif }
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif /** *//** 处理数字型的,自动去零 */
http://www.blogjava.net/Images/OutliningIndicators/InBlock.gif if (Cell.CELL_TYPE_NUMERIC == cell.getCellType())
http://www.blogjava.net/Images/OutliningIndicators/ExpandedSubBlockStart.gifhttp://www.blogjava.net/Images/OutliningIndicators/ContractedSubBlock.gif http://www.blogjava.net/Images/dot.gif<span style="color: #000000;">{
http://www.agoit.com/bbs/http://www.blogjava.net/Images/OutliningIndicators/Expa
页:
[1]