Boucle STORE Excel to QVD

Anouklbs — Tue, 10 May 2022 14:17:26 GMT

Hello,

I want to convert several Excel files contained in a folder A to save them in another folder B under QVD format. Is there a solution by "for loop" to convert each file one by one under QVD format by the "STORE" function?

Thanking you in advance,

Re: Boucle STORE Excel to QVD

Taoufiq_Zarra — Wed, 11 May 2022 08:46:04 GMT

@Anouklbs Maye be like this:

suppose you have Excel file in this path : C:\Users\admin\Downloads\qvdsave\*.xls

and you want copy all file into this path : C:\Users\admin\Downloads\qvdsave\B in qvd format :

you can use this script :

for each vFile in filelist('C:\Users\admin\Downloads\qvdsave\*.xls') let vFileName = subfield(subfield(vFile,'\',-1),'.',1) ; YourTableName: load *,'$(vFile)' as Filename from [$(vFile)] (biff, embedded labels, table is Sheet1$); STORE YourTableName INTO 'C:\Users\admin\Downloads\qvdsave\B\$(vFileName).qvd'; next vFile

output:

topic Re: Boucle STORE Excel to QVD in QlikView

Boucle STORE Excel to QVD

Re: Boucle STORE Excel to QVD