Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Contributor III
Contributor III

Can you please share that example

Highlighted
Master II
Master II

Hi,

Can you share the script CODE?

Highlighted
Contributor II
Contributor II

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

Highlighted
MVP & Luminary
MVP & Luminary

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

Highlighted
Contributor II
Contributor II

you mean

1) put same file to diff drive and try

if doesn't work

2) change xlsx to xls and try

Highlighted

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?

Highlighted
MVP & Luminary
MVP & Luminary

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