Failed to open excel(.xls) with NPOI(2.6.2) with some object not identified about npoi HOT 10 CLOSED

Why do you use HSSF to open xlsx? It should be XSSF. XSSF namespace is for xlsx and HSSF namespace is for xls.

from npoi.

Sorry, this file is XLS not XLSX.

from npoi.

Can you provide the Excel file to reproduce this issue?

A xls file may have a few possible cases. For example, the file is somewhat broken, or the file is too old (generated by Excel 97 and it's old BIFF format). The easiest way to check what's going on is to resave the file with Microsoft Excel and open it again with NPOI. If NPOI can open it after resaving the file, it means there is something fixed (internal record broken) by Microsoft Excel.

from npoi.

I'm trying to attach it but it's not loading. Is there any other way to send it?

from npoi.

You can send it to my email: [email protected]

from npoi.

I just sent the file by email.

from npoi.

I checked the file. The size of FtCfSubRecord is 0, which is incorrect.

Unhandled exception. NPOI.Util.RecordFormatException: Unable to construct record instance
 ---> NPOI.Util.RecordFormatException: Unexpected size (0)
   at NPOI.HSSF.Record.FtCfSubRecord..ctor(ILittleEndianInput in1, Int32 size) in C:\github\npoi\main\HSSF\Record\FtCfSubRecord.cs:line 63
   at NPOI.HSSF.Record.SubRecord.CreateSubRecord(ILittleEndianInput in1, CommonObjectType cmoOt) in C:\github\npoi\main\HSSF\Record\SubRecord\SubRecord.cs:line 58
   at NPOI.HSSF.Record.ObjRecord..ctor(RecordInputStream in1) in C:\github\npoi\main\HSSF\Record\ObjRecord.cs:line 102

After resaving the file with Microsoft Excel, it can be opened correctly with NPOI. It means Excel fixes some internal records. You need to check with the provider of this Excel.

from npoi.

I did exactly that, opened the file in Excel and saved a copy of it.
As soon as I put it to import, the error appeared: Wrong Local header signature: 0xE011CFD0.
Is there anything else that should be done when saving the file?

at ICSharpCode.SharpZipLib.Zip.ZipInputStream.GetNextEntry()
at NPOI.OpenXml4Net.Util.ZipInputStreamZipEntrySource..ctor(ZipInputStream inp)
at NPOI.OpenXml4Net.OPC.ZipPackage..ctor(Stream in1, PackageAccess access)
at NPOI.OpenXml4Net.OPC.OPCPackage.Open(Stream in1)
at NPOI.Util.PackageHelper.Open(Stream is1)
at NPOI.XSSF.UserModel.XSSFWorkbook..ctor(Stream is1)
at Yamaha.GQC.Web.Controllers.SolicitacoesInspecaoController.ValidarArquivoXLS_Modelo2(RealizarInspecaoViewModel realizarInspecaoViewModel) in C:\Yamaha\Fontes\gqc\src\Yamaha.GQC.Web\Controllers\SolicitacoesInspecaoController.cs:line 5723

from npoi.

The file is with xls extension. You should keep using HSSFWorkbook instead of XSSFWorkbook.

from npoi.

ok, I got it, thanks for the help.

I will contact the owner of the file and see what could be done.

from npoi.