AnsweredAssumed Answered

Import excel with hidden worksheet dialog box

Question asked by PreetHooda on Dec 29, 2010
Latest reply on Mar 3, 2012 by Vincent_L


Import excel with hidden worksheet dialog box


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.