topic Re: Excel files wont load unless saved in QlikView

Excel files wont load unless saved

sangland2 — Tue, 20 Oct 2015 23:37:41 GMT

Hi, I have xlsx files loading into a QV model. The script allows for 12 header lines:

(ooxml, embedded labels, header is 12 lines,table is [$(vSheetName)] ).

My problem is that unless the excel file is first opened and saved, QV cannot work out how many header rows there are and the script errors with fields not found. I assume this is problem with different Excel versions. I am preprocessing files with a vbscript, but is there another option ?

Re: Excel files wont load unless saved

HirisH_V7 — Wed, 21 Oct 2015 04:50:57 GMT

Hi,

I think your excel files are generated from database Excel export Service ,

This may vary due to daily changes of Header Lines OR Sheet-name OR The file name may also change .

Check out the above.

Hope this helps.

regards,

Hirish

Re: Excel files wont load unless saved

Wed, 21 Oct 2015 04:55:27 GMT

Steps to load data from Excel:

1. Open the desktop version.

2. Press Ctrl+E . On the lower part go to 'Data' Tab.

3. Click on Table Files. Browse and load the data from excel.

Re: Excel files wont load unless saved

avinashelite — Wed, 21 Oct 2015 05:10:07 GMT

If your excels are in opened in edit mode and then QV cannot load such file . Excel version might has impact in loading the file unless if it corrupted, and follow the steps mentioned by anjali12gupta you should be able to load . If your still facing any issues please share the sample excel file.

Re: Excel files wont load unless saved

jonathandienst — Wed, 21 Oct 2015 05:10:22 GMT

I don't really understand. If the file does not have 12 header lines, then adjust that parameter. It will look for field names as column titles in the first row after it has skipped the header lines. It seems that the field names / column titles are not in that row.

There is not normally a need to first open and save the file. What is your vbscript doing?

Re: Excel files wont load unless saved

jonathandienst — Wed, 21 Oct 2015 05:13:01 GMT

>>If your excels are in opened in edit mode and then QV cannot load such file

I am not sure what you mean by opening in "edit" mode. I have never had a problem loading Excel files while the file is open in Excel.

Re: Excel files wont load unless saved

avinashelite — Wed, 21 Oct 2015 05:24:07 GMT

jontydkpi‌‌ sir , I mean if some one has opened the excel file and editing the fields than Qlikview load will fail rite

Re: Excel files wont load unless saved

sangland2 — Wed, 21 Oct 2015 06:54:31 GMT

Interesting, same problem. If I open the file I receive the wizard does not find column names at all when specifying 12 lines of heading. If I firstly open the file in excel and save it, then the wizard works as expected.

Re: Excel files wont load unless saved

sangland2 — Wed, 21 Oct 2015 06:58:04 GMT

The vbscript is just opening and saving the file which solves the problem. I suspect that the file I receive is not entirely compatible with QV, but opening in and saving it in Excel locally seems to correct whatever the problem is.

Re: Excel files wont load unless saved

Wed, 21 Oct 2015 07:08:05 GMT

Can u capture a screen and explain what it shows?

Regards,

Anjali

Re: Excel files wont load unless saved

avinashelite — Wed, 21 Oct 2015 07:25:21 GMT

I feel the issue is with the Excel compatible version, try to let the latest version on the excel and check once

Re: Excel files wont load unless saved

sangland2 — Wed, 21 Oct 2015 07:37:18 GMT

http://www.screencast.com/t/fM6XjjN3Y