0

I have gone through POI documentation and did not find any list of all the supported file formats. The test data directory on github also does not contain all file formats that are supported by POI.

I have tried out most of the format myself using the API but some of the old formats like .xlc and xlw I am not able to try out. Any help regarding this is appreciated.

kamalkishor1991
  • 876
  • 9
  • 14
  • 1
    I would say the officially supported format are xls and xlsx, see https://poi.apache.org/spreadsheet/index.html –  Dec 14 '16 at 06:36
  • Okay but I tried .xlsx, .xls, .xlam, .xlsb, .xlsm, .xltm and.xltx and all of them work except xlsb (.XLSB Binary Workbooks are not supported. – kamalkishor1991 Dec 14 '16 at 06:39
  • 1
    Apache POI doesn't support the .xlsb file format. you can convert it into .xls or xlsx. [Exception reading XLSB File Apache POI java.io.CharConversionException](http://stackoverflow.com/questions/14282164/exception-reading-xlsb-file-apache-poi-java-io-charconversionexception) – nail fei Dec 14 '16 at 06:47

0 Answers0