Unkown file format specifier

[#1]

Hi guys,

I am loading an excel file and it has two sheets lets suppose A and B. Both has similar structure and i use For Each loop for loading these files. Whenever i use this logic before it works but this time it generates an error which is 'unknown file format specifier'.

Kindly give me solution to solve this problem.I will very thankful to you guys..

Thanks in Advance...

[Anonymous]

Is the file path set to a variable?  If not that may be the issue. 

For reference:

http://community.qlik.com/thread/47437

[#3]

Actually when i load sheets individually it works but when i load both sheet in loop it doesn't and generates error.So i think their is nothing issue in path.

Please Help me out....

[Anonymous]

I would have to guess your Loop Statement is the cause.  Try the below resources to reformat your statement.

QlikView Maven: Loading All of the Files from a Folder

or

http://community.qlik.com/thread/62449

[kumarnatarajan]

Hi Syed,

When try to load multiple sheet you should have MS drive. else you made path problem. else send me your script i will help you

[#6]

Kumar i am sending you my qvw file for helping me hope you will do it Thanks..

[#7]

Anyone please helping me out...!!

[kumarnatarajan]

HI Syed,

PFA simple script.

Else find the below url:

Loading from multiple Excel files and multiple sheets

[kavicsgym]

Kumar's solution is GOOD, the issue was with the table name specification during xls load.

Instead this:                            

FROM
[.........................xls]
(biff, embedded labels, table is $(vSheetName) ;

this one has to be used:

FROM
[.........................xls]
(biff, embedded labels, table is [$(vSheetName)$]);

Thanks!