topic Can't open excel files withQlikView in QlikView

Can't open excel files withQlikView

Mon, 27 Apr 2009 15:25:34 GMT

I cant open excelfiles with qlikview even though they are not protected, can it be a user access issue?

Can't open excel files withQlikView

Mon, 27 Apr 2009 15:27:05 GMT

It could be many things. What are you doing? What's the error?

Can't open excel files withQlikView

Mon, 27 Apr 2009 15:29:00 GMT

when i run the script i get an error message that says that the files can't be opened. i'm trying to get data from the excel files. i've checked the path and it's correct, the files aren't protected or read only or anything either

Can't open excel files withQlikView

Mon, 27 Apr 2009 15:33:14 GMT

What is the specific error message? I've had several variations on this over the years. Sometimes it is an invalid file format. Sometimes the file is locked open by Excel. It depends.

Can't open excel files withQlikView

Mon, 27 Apr 2009 15:33:20 GMT

Hi,

Check the file access permissions... The file must have read write permissions.

Thanks,

Saran.

Can't open excel files withQlikView

Mon, 27 Apr 2009 15:42:01 GMT

@Jay Jakovski

The file can't be opened '192.168...xls'...

(it's swedish so I translated it, beware that it might not be the exact message)

Can't open excel files withQlikView

Mon, 27 Apr 2009 15:49:47 GMT

Can you paste the section of script that loads from the file?

Can't open excel files withQlikView

Mon, 27 Apr 2009 15:54:47 GMT

NyaMux: Load Postnummer AS #PostNummer, [Nya Mux 5] AS sls_Nya_Mux_5 FROM \\192.168.101.130\QlikView\exempel\NyaMux5.xls] (biff, embedded labels, table is [Mux$]);

if I change the Ip to "D:" it works, but I would like to use the ip and that doesn't seem to work

Can't open excel files withQlikView

Anonymous — Mon, 27 Apr 2009 20:56:50 GMT

I'm not sure whether this is just a character that was cut in the copy / paste.. but you seem to be missing the first [ - bracket before the \\ in the example above.

Can't open excel files withQlikView

Mon, 27 Apr 2009 22:12:33 GMT

it's a copy/paste fail

Can't open excel files withQlikView

yblake — Mon, 27 Apr 2009 22:27:18 GMT

using "\\host\path" syntax assumes that "path" is a network shared path.

Can you see "QlikView" shared folder when exploring \\192.168.101.130 host thru the network ? Can you open excel file remotly in exempel subfolder ?

Can't open excel files withQlikView

Mon, 27 Apr 2009 22:30:15 GMT

is there anyone that as an idea why i as a user can reach the files with local path like d:\QlikView\files, and not through a network path like \\someCompNameOrIP\QlikView\files?

Can't open excel files withQlikView

Mon, 27 Apr 2009 22:47:36 GMT

i found the error, i could see and get the files since i had permissions on them, but had forgotten make part of the users on the created shared folder, under share. thanks everybody for your input

Can't open excel files withQlikView

rwunderlich — Mon, 27 Apr 2009 22:55:30 GMT

Accessing a file from a remote machine is done using a network share name like:

\\someCompNameorIP\shareName

When mapped to a drive letter, like "D", you can reference files within the "shareName" like

D:\subdir\myFile.xls

The full (UNC) path to this file would be:

\\someCompNameorIP\shareName\subdir\myFile.xls

In your question, you said this works:
d:\QlikView\files
but this doesn't:
\\192.168.101.130\QlikView\exempel\NyaMux5.xls

Assuming 😧 is a network drive, In your UNC form, you are missing the "ShareName" portion of the path -- whatever you used to map drive 😧
\\192.168.101.130\ShareName\QlikView\exempel\NyaMux5.xls

-Rob