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

[#1]

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

[#2]

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$)

[sdmech81]

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 ..

[sdmech81]

Still u face problem,plss let me know.

Sachin

[vinieme12]

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$);

[Anonymous]

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

Pooja

[#7]

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.

[#8]

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

[sdmech81]

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..

[#10]

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.

[sdmech81 · Accepted solution]

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..