Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
RashmiD
Contributor II
Contributor II

QV12 Error: Unknown error in xlsx file

In QV12 script is failing

Log shows error

"Error: Unknown error in xlsx file"

 

This same script works in QV11

7 Replies
Rojarao
Contributor III
Contributor III

Can you please share that example

qlikviewwizard
Master II
Master II

Hi,

Can you share the script CODE?

RashmiD
Contributor II
Contributor II
Author

IN QV12.20, accessing SharePoint site,I am getting error

marcus_sommer

Copy this file to a "normal" drive and try it again. If it not worked open and save the file with Excel and try it again. This is just to rule out issues with the sharepoint and/or an invalid file-structur.

 

- Marcus

RashmiD
Contributor II
Contributor II
Author

you mean

1) put same file to diff drive and try

if doesn't work

2) change xlsx to xls and try

Colin-Albert

Is the report being run by the same user in QV11 and QV12?

Or is one version on a desktop and one on a server?

If it is being run on a server reload, does the account running the QlikView Distribution Service have permissions to access the sharepoint folder and xlsx file?

marcus_sommer

1 - yes, I meant to try it from a real drive and not from a website like sharepoint which might lead to various issues which aren't related to Qlik.

 

2 - no, just opening and saving the file with a desktop Excel without any change within it or to the fileformat. Files created by an online Excel or any third party tools could be different to an origin Excel file.

 

- Marcus