2 Replies Latest reply: Dec 16, 2010 7:49 PM by cisco_kid RSS

    Loading data from Excel folders



      I would like to load some folders from an Excel file.

      In the Excel file, the folders are named JAN, FEB, ... OCT.

      In fact the number of folders in my Excel file depends on the current date, for exemple :

      • At the end of February, it will only contain one folder JAN and anaother folder FEB
      • At the end of June, il will contain different folders for JAN, FEB, MAR, APR, MAY and JUNE
      • ...

      I want to create a script that loads data from the Excel file whatever the number of folders in it , That's to say JAN and FEB if the Excel file contains only these 2 folders.

      Could you help me ? Thanks.