Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2017-02-07 08:58 AM

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

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

9,953 Views
0 Likes
1 Solution

Accepted Solutions
sdmech81
Specialist
Specialist
‎2017-02-08 10:02 AM

In response to

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

View solution in original post

9,412 Views
0 Likes
20 Replies
Anil_Babu_Samineni
MVP
MVP
‎2017-02-07 09:02 AM

Same problem here check

ScriptError: Cannot read BIFF file - Any ideas?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
5,769 Views
0 Likes
vishsaggi
Champion III
Champion III
‎2017-02-07 09:10 AM

Look here if this may be of any help?

Bad Zip File Error from reading XLS files

5,769 Views
0 Likes
vinieme12
Champion III
Champion III
‎2017-02-07 09:12 AM

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
5,769 Views
0 Likes
Not applicable
‎2017-02-07 09:15 AM
Author

In response to Anil_Babu_Samineni

Hi Anil ,

They haven't mentioned any Macro code for this .

5,769 Views
0 Likes
Not applicable
‎2017-02-07 09:15 AM
Author

In response to vishsaggi

Hi Vishwa,

This is not a realted ZIP error issue

5,769 Views
0 Likes
Not applicable
‎2017-02-07 09:16 AM
Author

In response to vinieme12

Hi Vineeth,

I tried the same way you suggetsed but no use

5,769 Views
0 Likes
vinieme12
Champion III
Champion III
‎2017-02-07 09:22 AM

In response to

post the script please

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
5,769 Views
0 Likes
Anil_Babu_Samineni
MVP
MVP
‎2017-02-07 09:41 AM

In response to

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)

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
5,769 Views
0 Likes
vinieme12
Champion III
Champion III
‎2017-02-07 09:43 AM

In response to

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

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
5,769 Views
0 Likes