I am trying to create a script that will automatically import the first excel worksheet for an excel (,xlxs) file. In each case when i run the script I want to import the first worksheet in the file regardless of the worksheet name. The excel file will always have the same name however the worksheet name will change depending on the date it is run.
Is there a way I can do this using IDEA script? To import the worksheet at present, i have to specify the sheet name each time e.g. task.SheetToImport = "sales01012020".
Any assistance would be appreciated.
Last seen: 3 weeks 11 hours ago
Joined: 05/11/2020 - 06:47