kd.bos.servicehelper.util

## 类 ExcelHelper

- java.lang.Object
- - kd.bos.servicehelper.util.ExcelHelper

-     public class ExcelHelper
      extends java.lang.Object

  版本:
    1.0

- - ### 字段概要

    字段
    限定符和类型 | 字段和说明
    --- | ---
    `static java.lang.String` | `EXCEL_XLS` Excel 2003
    `static java.lang.String` | `EXCEL_XLSX` Excel 2007/2010
    `static java.lang.String` | `KEY_ENTRYENTITY` 分录键名
    `static java.lang.String` | `KEY_ROW_INDEX` 行索引键名

  - ### 构造器概要

    构造器
    构造器和说明
    `ExcelHelper()`

  - ### 方法概要

    所有方法 静态方法 具体方法
    限定符和类型 | 方法和说明
    --- | ---
    `static org.apache.poi.ss.usermodel.Row` | `addCellAtStart(org.apache.poi.ss.usermodel.Sheet sheet, int rowIndex)`
    `static java.util.List<java.util.Map<java.lang.Integer,java.lang.Object>>` | `getCellValue(org.apache.poi.ss.usermodel.Workbook workbook, int sheetIndex, int startRowIndex)`
    `static java.util.List<java.util.Map<java.lang.String,java.lang.Object>>` | `getCellValue(org.apache.poi.ss.usermodel.Workbook workbook, int sheetIndex, int startRowIndex, java.util.Map<java.lang.Integer,java.lang.String> propertyMap)`
    `static java.util.List<java.util.Map<java.lang.String,java.lang.Object>>` | `getImportData(java.lang.String fileUrl, java.lang.String fileName, int sheetIndex, int titleRowIndex)`
    `static java.util.Map<java.lang.String,java.util.List<java.util.Map<java.lang.String,java.lang.Object>>>` | `getImportDataMultiEntity(java.lang.String fileUrl, java.lang.String fileName, int sheetIndex, int titleRowIndex)`
    `static org.apache.poi.ss.usermodel.Workbook` | `getImportWorkbook(java.lang.String fileUrl, java.lang.String fileName)`
    `static java.util.Map<java.lang.Integer,java.lang.String>` | `getTitle(org.apache.poi.ss.usermodel.Workbook workbook, int sheetIndex, int rowIndex)`
    `static java.util.Map<java.lang.Integer,java.lang.String>` | `getTitlePropertyName(org.apache.poi.ss.usermodel.Workbook workbook, int sheetIndex, int rowIndex)`
    `static org.apache.poi.ss.usermodel.Workbook` | `getWorkbook(java.io.File file)`
    `static org.apache.poi.ss.usermodel.Workbook` | `getWorkbook(java.io.InputStream in, java.lang.String fileName)`
    `static org.apache.poi.ss.usermodel.Workbook` | `getWorkbook(java.lang.String filePath)`

    - ### 从类继承的方法 java.lang.Object

      `equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait`

- - ### 字段详细资料

    - #### EXCEL_XLS

          public static final java.lang.String EXCEL_XLS

      Excel 2003
      另请参阅:
        常量字段值

    - #### EXCEL_XLSX

          public static final java.lang.String EXCEL_XLSX

      Excel 2007/2010
      另请参阅:
        常量字段值

    - #### KEY_ROW_INDEX

          public static final java.lang.String KEY_ROW_INDEX

      行索引键名
      另请参阅:
        常量字段值

    - #### KEY_ENTRYENTITY

          public static final java.lang.String KEY_ENTRYENTITY

      分录键名
      另请参阅:
        常量字段值

  - ### 构造器详细资料

    - #### ExcelHelper

          public ExcelHelper()

  - ### 方法详细资料

    - #### getImportWorkbook

          public static org.apache.poi.ss.usermodel.Workbook getImportWorkbook(java.lang.String fileUrl,
                                                                               java.lang.String fileName)
                                                                        throws java.io.IOException

      参数:
        `fileUrl` -
        `fileName` -
      返回:
      抛出:
        `java.io.IOException`

    - #### getWorkbook

          public static org.apache.poi.ss.usermodel.Workbook getWorkbook(java.lang.String filePath)
                                                                  throws java.io.IOException

      参数:
        `file` -
      返回:
      抛出:
        `java.io.IOException`

    - #### getWorkbook

          public static org.apache.poi.ss.usermodel.Workbook getWorkbook(java.io.File file)
                                                                  throws java.io.IOException

      参数:
        `file` -
      返回:
      抛出:
        `java.io.IOException`

    - #### getWorkbook

          public static org.apache.poi.ss.usermodel.Workbook getWorkbook(java.io.InputStream in,
                                                                         java.lang.String fileName)
                                                                  throws java.io.IOException

      参数:
        `in` -
        `fileName` -
      返回:
      抛出:
        `java.io.IOException`

    - #### getTitle

          public static java.util.Map<java.lang.Integer,java.lang.String> getTitle(org.apache.poi.ss.usermodel.Workbook workbook,
                                                                                   int sheetIndex,
                                                                                   int rowIndex)

      参数:
        `workbook` -
        `sheetIndex` -
        `rowIndex` -
      返回:

    - #### getTitlePropertyName

          public static java.util.Map<java.lang.Integer,java.lang.String> getTitlePropertyName(org.apache.poi.ss.usermodel.Workbook workbook,
                                                                                               int sheetIndex,
                                                                                               int rowIndex)

      参数:
        `workbook` -
        `sheetIndex` -
        `rowIndex` -
      返回:

    - #### getCellValue

          public static java.util.List<java.util.Map<java.lang.Integer,java.lang.Object>> getCellValue(org.apache.poi.ss.usermodel.Workbook workbook,
                                                                                                       int sheetIndex,
                                                                                                       int startRowIndex)

      参数:
        `workbook` -
        `sheetIndex` -
        `startRowIndex` -
      返回:

    - #### getCellValue

          public static java.util.List<java.util.Map<java.lang.String,java.lang.Object>> getCellValue(org.apache.poi.ss.usermodel.Workbook workbook,
                                                                                                      int sheetIndex,
                                                                                                      int startRowIndex,
                                                                                                      java.util.Map<java.lang.Integer,java.lang.String> propertyMap)

      参数:
        `workbook` -
        `sheetIndex` -
        `startRowIndex` -
        `propertyMap` -
      返回:

    - #### getImportData

          public static java.util.List<java.util.Map<java.lang.String,java.lang.Object>> getImportData(java.lang.String fileUrl,
                                                                                                       java.lang.String fileName,
                                                                                                       int sheetIndex,
                                                                                                       int titleRowIndex)
                                                                                                throws java.io.IOException

      参数:
        `fileUrl` -
        `fileName` -
        `sheetIndex` -
        `titleRowIndex` -
      返回:
      抛出:
        `java.io.IOException`

    - #### getImportDataMultiEntity

          public static java.util.Map<java.lang.String,java.util.List<java.util.Map<java.lang.String,java.lang.Object>>> getImportDataMultiEntity(java.lang.String fileUrl,
                                                                                                                                                  java.lang.String fileName,
                                                                                                                                                  int sheetIndex,
                                                                                                                                                  int titleRowIndex)
                                                                                                                                           throws java.io.IOException

      参数:
        `fileUrl` -
        `fileName` -
        `sheetIndex` -
        `titleRowIndex` -
      返回:
      抛出:
        `java.io.IOException`

    - #### addCellAtStart

          public static org.apache.poi.ss.usermodel.Row addCellAtStart(org.apache.poi.ss.usermodel.Sheet sheet,
                                                                       int rowIndex)

      参数:
        `sheet` -
        `rowIndex` -
      返回: