topic Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ? in QlikView

Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

Wed, 25 Nov 2020 16:16:04 GMT

Dear Experties,

As per my requirements I am loading couple of Excel files into Qlikview while loading am getting BIFF error, Manually I have changed the format to .xls but still the same error happening.

Don’t know does any one facing this issue before

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

Anil_Babu_Samineni — Tue, 07 Feb 2017 14:02:50 GMT

Same problem here check

ScriptError: Cannot read BIFF file - Any ideas?

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

vishsaggi — Tue, 07 Feb 2017 14:10:49 GMT

Look here if this may be of any help?

Bad Zip File Error from reading XLS files

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

vinieme12 — Tue, 07 Feb 2017 14:12:35 GMT

instead of manually changing the file extension do a "save as" and see if it helps

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

Tue, 07 Feb 2017 14:15:04 GMT

Hi Anil ,

They haven't mentioned any Macro code for this .

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

Tue, 07 Feb 2017 14:15:41 GMT

Hi Vishwa,

This is not a realted ZIP error issue

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

Tue, 07 Feb 2017 14:16:46 GMT

Hi Vineeth,

I tried the same way you suggetsed but no use

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

vinieme12 — Tue, 07 Feb 2017 14:22:51 GMT

post the script please

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

Anil_Babu_Samineni — Tue, 07 Feb 2017 14:41:02 GMT

They clearly mentioned over theory.

Try to share Excel, So that we can found the issue to solve and please reply to vinieme12 (Reg - Script)

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

vinieme12 — Tue, 07 Feb 2017 14:43:59 GMT

Are you trying to do a "save as" on the file that you manually renamed?

do a "save as" of the original .xlsx, it should work

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

Wed, 08 Feb 2017 11:53:04 GMT

Hi Vineeth,

Please find attched sample excel file for your reference which is in .xlsx formart(original format).

I have opened .xlsx file and done save as to .xls format but no luck to solve the issue.

I have loading other files with this new format the other files are .xls format.

LOAD

[END Date],

[Received Date],

[Log Manager],

Handler,

Key,
Count

FROM
[file Path]
(biff, embedded labels, table is Sample$)

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

sdmech81 — Wed, 08 Feb 2017 12:03:55 GMT

HI,

Please attached excel it should work..I tried its working.

When u pasting a data don't doubl eclick into the excel shells and paste.

just one click and paste...

Hope it helps ..

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

sdmech81 — Wed, 08 Feb 2017 12:07:27 GMT

Still u face problem,plss let me know.

Sachin

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

vinieme12 — Wed, 08 Feb 2017 12:17:11 GMT

Load Script for XLSX file

-------------------------------------------------

let FilePath = 'C:\Users\vp51284\Downloads\Sample.xlsx';

LOAD [END Date],

[Received Date],

[Log Manager],

Handler,

[CA ID],

Key,

Count

FROM

[$(FilePath)]

(ooxml, embedded labels, table is Sample);

--------------------------------------------------------------------------------

--------------------------------------------------

Load Script for XLS file

-------------------------------------------------

LOAD [END Date],

[Received Date],

[Log Manager],

Handler,

[CA ID],

Key,

Count

FROM

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

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

Anonymous — Wed, 08 Feb 2017 12:45:50 GMT

Save your Excel file as ".xls" instead of ".xlsx" and change your qv script accordingly to load the new saved file.

Pooja

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

Wed, 08 Feb 2017 14:34:32 GMT

Vineeth,

can we use only one load script rarther than using two scripts ? and I had multiple files in my folder .Every month i am getting one new file which is .xlsx format and new file needs to join to other prevoius file i mean in folder mutiple files so in that case how would i tackle it.

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

Wed, 08 Feb 2017 14:35:48 GMT

Sachin,its working for when we loading single file but not for multiple files with .xls format.

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

sdmech81 — Wed, 08 Feb 2017 14:48:18 GMT

Hi,

Thats what these files are u r receiving r generated by users ryt?? Or any system.

If so ask users to single click on shells n paste the data.

Then save as .Xlsx then like said above should work.Else handling files in incremental load will get difficult..

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

Wed, 08 Feb 2017 14:57:34 GMT

Yes Sachin you said right but My aim is how do i handle in qlikview if i get that kind of format file instaed of changing manaually an everytime.

Re: Does anyone Solved ‘BIFF’ Error while loading .xlsx files into Qlikview ?

sdmech81 — Wed, 08 Feb 2017 15:02:37 GMT

Yes..But it's better bfr u receive them,frm which source u r receiving files thr only it should be taken care..

I faced the problm but it has been handled in excel source system frm where we were getting files..