2 Replies Latest reply: May 11, 2017 5:30 PM by Julisy Amador RSS

    Cannot read BIFF file

    Alexandr Shilyaev


      I am trying to read xls file.

      But when it is reading via QlikCloud, it fails.

      Error : Cannot read BIFF file.



      Crosstable (Month, Value, 6)

      LOAD *

      FROM [lib://shilyaev/Pritok2017.xls]

      (biff, embedded labels, table is Data$);


      Let me know if anyone could help to solve this issue.


        • Re: Cannot read BIFF file
          Michael Tarallo

          Hello Alexandr,


          Just to be clear - is this an Excel Binary type file? - If so - have you verified that it works with Qlik Sense Desktop? I believe what you may be using is a Binary Excel file that this type .xlsb. Can you save this as a .xlsx and try again?


          I have attempted to use this (attached) and I get unsupported file format,



          If I save as and Excel Workbook.



          It works:



          So please let us know.


          When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.




          Mike Tarallo


          • Re: Cannot read BIFF file
            Julisy Amador


            Here you are an example that I'm sure that work.


            I hope it help you!