1 Reply Latest reply on Mar 3, 2012 10:17 AM by Vincent_L

    Import excel with hidden worksheet dialog box

    PreetHooda

      Title

      Import excel with hidden worksheet dialog box

      Post

      Hi, I am using fm pro adv 11.0v1.

      I need to import an .xlsx file. User will select file and this file have multiple worksheet. I don't want user to select worksheet too. I can define .xlsx in variable, but how to define worksheet name in variable. File will have pre-defined worksheet name and it is hidden in xlsx file.

      Under import script step, If I do have select file as selected, then of course I can pre-define worksheet name. But I need to give choice to user to select the file.

      My all attempts failed to hide the "select worksheet" dialog box.

      Any clue will be helpful. Thanks in advance.