[TIKA-2205] IllegalArgumentException on a valid Excel file

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.14
• Component/s: parser

Environment

Windows 7 x64, JVM 1.8.0_101

• Assignee: Unassigned
• Reporter: Seva Alekseyev
• Created: 13/Dec/16 21:22
• Updated: 13/Jan/17 13:20
• Resolved: 13/Jan/17 13:20

Description

The attached file, which opens in Excel, errors out in Tika:

java.lang.IllegalArgumentException: Cannot format given Object as a Number
at java.text.DecimalFormat.format:-1
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:432
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
at gov.nih.niaid.fscanner.Extract.ExtractContents:69

Issue Links

• duplicates: TIKA-2196 IllegalArgumentException on a valid Excel file