I have created an dashboard in which i am pulling data from 100 Excel sheets which have same colums and are placed in different folders.I am using a "Do Dir()" script to pull all this data together.Now when i try to store these into "Qvd' it is storing the data of the first sheet only and ignorining the rest 99 sheets.Over here in "c:\data" there is 100 folders each having one file each.So iam pulling all the files together.Any help will be appriciated.
SUB DoDir (Root)
FOR each File in filelist(Root& '\*.xlsm')
Table: LOAD Sino, Name
FROM [$(File)] (ooxml, embedded labels, table is Data, filters( Remove(Row, Pos(Top, 1)) ));
NEXT File FOR each Dir in dirlist (Root&'\*') CALL DoDir(Dir) NEXT Dir END SUB CALL DoDir('\\c:\data');
Document Properties > General > Checked to Check Box "Generate Logfile" > Checked to Check Box "Timestamp in Logfile Name" > Apply > OK.
The Logfile will be generate at the same place where QVD exist. Open and check it, for better understanding means where is the script is going to be failed.
