4 Replies Latest reply: Oct 22, 2014 5:20 AM by Gysbert Wassenaar RSS

    Load an Excel file with variable worksheet name

    Friedrich Hofmann

      Hi,

       

      how do I load a table from an Excel_file if I know the file_name, but not the sheet_name - it is usually "owssvr", but it might be "owssvr (1)" - I don't know the reason. I'm trying to keep the manual effort to a minimum so that the person fetching those files - there are six, my code runs as a loop over them all - doesn't have to manually rename that.

      Thanks a lot!

       

      Best regards,

       

      DataNibbler