Qlik Community

Qlik Sense Cloud Discussions

Not applicable

Cannot read BIFF file

Hi,


I am trying to read xls file.

But when it is reading via QlikCloud, it fails.

Error : Cannot read BIFF file.

indb:

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.


Thanks.

3 Replies
Employee
Employee

Re: Cannot read BIFF file

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.

Regards,

Mike Tarallo

Qlik

Regards,
Mike Tarallo
Qlik
Not applicable

Re: Cannot read BIFF file

Hi,

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

I hope it help you!

krzysztof_toman
New Contributor III

Re: Cannot read BIFF file

Hi Michael,

just sharing another issue I've came across lately.

Was using Microsoft Azure Information Protection tool build in Excel (Version 1.4.21.0).

Azure Information Protection client: Version release history and support policy | Microsoft Do...

When I've triad to import xlsx to Qlik Sense Desktop (September edition) have received the incorrect format information (screen attached).

The solution was not perfect but worked - I've taken the protection off and xlsx file was imported with no further issues.

Kind regards,

Chris.

Community Browser