Package com.github.tonyluo.excel

Class ExcelUtil

java.lang.Object
com.github.tonyluo.excel.ExcelUtil
public class ExcelUtil
extends java.lang.Object

  • Constructor Summary

    Constructors 
    Constructor Description
    ExcelUtil()  

  • Method Summary

    Modifier and Type Method Description
    static <T> byte[] exportToBytes​(java.util.List<T> entityList)
    导出Excel字节数据
    static <T> java.lang.String exportToFile​(java.lang.String filePath, java.util.List<T> entityList)
    导出Excel文件到磁盘
    static <T> java.util.List<T> importExcel​(org.apache.poi.ss.usermodel.Workbook book, java.lang.Class<T> clazz, int sheetIndex, int startRow, int endRow)  
    static <T> java.util.List<T> importFromFile​(java.io.File file, java.lang.Class<T> clazz)  
    static <T> java.util.List<T> importFromFile​(java.io.File file, java.lang.Class<T> clazz, int startRow)  
    static <T> java.util.List<T> importFromInputStream​(java.io.InputStream stream, java.lang.Class<T> clazz)  
    static <T> java.util.List<T> importFromInputStream​(java.io.InputStream stream, java.lang.Class<T> clazz, int startRow)  
    static <T> java.util.List<T> importFromPath​(java.lang.String path, java.lang.Class<T> clazz)  
    static <T> java.util.List<T> importFromPath​(java.lang.String path, java.lang.Class<T> clazz, int startRow)  

    Methods inherited from class java.lang.Object

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

  • Constructor Details

  • Method Details

    • exportToFile

      public static <T> java.lang.String exportToFile​(java.lang.String filePath, java.util.List<T> entityList) throws java.lang.IllegalAccessException, java.lang.InstantiationException, java.io.IOException, java.lang.ClassNotFoundException

      导出Excel文件到磁盘

      Type Parameters:
      T - class
      Parameters:
      filePath - file path
      entityList - data list
      Returns:
      file path
      Throws:
      java.io.IOException - IOException
      java.lang.InstantiationException - InstantiationException
      java.lang.IllegalAccessException - IllegalAccessException
      java.lang.ClassNotFoundException

    • exportToBytes

      public static <T> byte[] exportToBytes​(java.util.List<T> entityList) throws java.lang.IllegalAccessException, java.lang.InstantiationException, java.io.IOException, java.lang.ClassNotFoundException
      导出Excel字节数据
      Type Parameters:
      T - class
      Parameters:
      entityList - data list
      Returns:
      byte
      Throws:
      java.io.IOException - IOException
      java.lang.InstantiationException - InstantiationException
      java.lang.IllegalAccessException - IllegalAccessException
      java.lang.ClassNotFoundException

    • importFromPath

      public static <T> java.util.List<T> importFromPath​(java.lang.String path, java.lang.Class<T> clazz, int startRow) throws java.io.IOException, java.lang.IllegalAccessException, java.lang.InstantiationException, java.lang.ClassNotFoundException
      Type Parameters:
      T - class
      Parameters:
      path - excel file path
      clazz - class
      startRow - start row
      Returns:
      java bean list
      Throws:
      java.io.IOException - IOException
      java.lang.InstantiationException - InstantiationException
      java.lang.IllegalAccessException - IllegalAccessException
      java.lang.ClassNotFoundException

    • importFromPath

      public static <T> java.util.List<T> importFromPath​(java.lang.String path, java.lang.Class<T> clazz) throws java.io.IOException, java.lang.IllegalAccessException, java.lang.InstantiationException, java.lang.ClassNotFoundException
      Type Parameters:
      T - class
      Parameters:
      path - excel file path
      clazz - class
      Returns:
      java bean list
      Throws:
      java.io.IOException - IOException
      java.lang.InstantiationException - InstantiationException
      java.lang.IllegalAccessException - IllegalAccessException
      java.lang.ClassNotFoundException

    • importFromFile

      public static <T> java.util.List<T> importFromFile​(java.io.File file, java.lang.Class<T> clazz, int startRow) throws java.io.IOException, java.lang.InstantiationException, java.lang.IllegalAccessException, java.lang.ClassNotFoundException
      Type Parameters:
      T - class
      Parameters:
      file - excel file path
      clazz - class
      startRow - start row
      Returns:
      java bean list
      Throws:
      java.io.IOException - IOException
      java.lang.InstantiationException - InstantiationException
      java.lang.IllegalAccessException - IllegalAccessException
      java.lang.ClassNotFoundException

    • importFromFile

      public static <T> java.util.List<T> importFromFile​(java.io.File file, java.lang.Class<T> clazz) throws java.io.IOException, java.lang.InstantiationException, java.lang.IllegalAccessException, java.lang.ClassNotFoundException
      Type Parameters:
      T - class
      Parameters:
      file - excel file path
      clazz - class
      Returns:
      java bean list
      Throws:
      java.io.IOException - IOException
      java.lang.InstantiationException - InstantiationException
      java.lang.IllegalAccessException - IllegalAccessException
      java.lang.ClassNotFoundException

    • importFromInputStream

      public static <T> java.util.List<T> importFromInputStream​(java.io.InputStream stream, java.lang.Class<T> clazz, int startRow) throws java.io.IOException, java.lang.InstantiationException, java.lang.IllegalAccessException, java.lang.ClassNotFoundException
      Type Parameters:
      T - class
      Parameters:
      stream - input stream
      clazz - class
      startRow - start row
      Returns:
      java bean list
      Throws:
      java.io.IOException - IOException
      java.lang.InstantiationException - InstantiationException
      java.lang.IllegalAccessException - IllegalAccessException
      java.lang.ClassNotFoundException

    • importFromInputStream

      public static <T> java.util.List<T> importFromInputStream​(java.io.InputStream stream, java.lang.Class<T> clazz) throws java.io.IOException, java.lang.InstantiationException, java.lang.IllegalAccessException, java.lang.ClassNotFoundException
      Type Parameters:
      T - class
      Parameters:
      stream - input stream
      clazz - class
      Returns:
      java bean list
      Throws:
      java.io.IOException - IOException
      java.lang.InstantiationException - InstantiationException
      java.lang.IllegalAccessException - IllegalAccessException
      java.lang.ClassNotFoundException

    • importExcel

      public static <T> java.util.List<T> importExcel​(org.apache.poi.ss.usermodel.Workbook book, java.lang.Class<T> clazz, int sheetIndex, int startRow, int endRow) throws java.lang.InstantiationException, java.lang.IllegalAccessException, java.lang.ClassNotFoundException
      Type Parameters:
      T - class
      Parameters:
      book - workbook
      clazz - class
      sheetIndex - sheet Index
      startRow - start row
      endRow - end row
      Returns:
      java bean list
      Throws:
      java.lang.InstantiationException - InstantiationException
      java.lang.IllegalAccessException - IllegalAccessException
      java.lang.ClassNotFoundException