Uploaded image for project: 'Tika'
  1. Tika
  2. TIKA-2196

IllegalArgumentException on a valid Excel file

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.14
    • Fix Version/s: None
    • Component/s: parser
    • Labels:
      None
    • Environment:

      Windows 7 x64, JVM 1.8.0_101

      Description

      On the attached Excel file, which opens fine in Excel, Tika throws the following error:

      java.lang.IllegalArgumentException: Cannot format given Object as a Number
      at java.text.DecimalFormat.format:-1
      at org.apache.poi.ss.usermodel.ExcelGeneralNumberFormat.format:67
      at java.text.Format.format:-1
      at org.apache.poi.ss.usermodel.DataFormatter.performDateFormatting:736
      at org.apache.poi.ss.usermodel.DataFormatter.formatRawCellContents:804
      at org.apache.poi.ss.usermodel.DataFormatter.formatRawCellContents:785
      at org.apache.poi.hssf.eventusermodel.FormatTrackingHSSFListener.formatNumberDateCell:143
      at org.apache.tika.parser.microsoft.ExcelExtractor$TikaHSSFListener$TikaFormatTrackingHSSFListener.formatNumberDateCell:633
      at org.apache.tika.parser.microsoft.ExcelExtractor$TikaHSSFListener.internalProcessRecord:405
      at org.apache.tika.parser.microsoft.ExcelExtractor$TikaHSSFListener.processRecord:336
      at org.apache.poi.hssf.eventusermodel.FormatTrackingHSSFListener.processRecord:92
      at org.apache.poi.hssf.eventusermodel.HSSFRequest.processRecord:109
      at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.genericProcessEvents:179
      at org.apache.poi.hssf.eventusermodel.HSSFEventFactory.processEvents:136
      at org.apache.tika.parser.microsoft.ExcelExtractor$TikaHSSFListener.processFile:312
      at org.apache.tika.parser.microsoft.ExcelExtractor.parse:169
      at org.apache.tika.parser.microsoft.OfficeParser.parse:177
      at org.apache.tika.parser.microsoft.OfficeParser.parse:130

        Attachments

        1. 2007 Experiment watch.xls
          44 kB
          Seva Alekseyev
        2. 1.xls
          26 kB
          Vinay Kawade

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                sevaa Seva Alekseyev
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: