If an excel file contains multiple sheets with different data\table . how to create a qvd for each sheet present in that excel file?

[#1]

If an excel file contains multiple sheets with different data\table . how to create a qvd for each sheet present in that excel file?

[maxgro]

set s='Sheet1','Sheet2','Sheet3';

for each i in $(s);

  $(i):

     LOAD   *

     FROM [Book1.xlsx] (ooxml, embedded labels, Table is [$(i)]);

     store $(i) into $(i).qvd (qvd);

     DROP Table $(i);

next

[maxgro]

or here for odbc

how to count no.of sheets in execl file