In that check the following1) The Sheet Name should be PROCESS_SHEET.2) The Data should start from Row 43) Check if your Window's Regional Date Settings is set to DD-MMM-YY
In the field 'No of Rows' Enter the Number of Rows. Here it is 20. Click on Open File and Select the appropriate Location where your Excel File is locatedClick on Read File.Now we can see the excel data in the "Load Process Sheet From Excel" window which is shown as below.
The fields highlighted in Yellow or Red color are errors. To view the Error click on the button 'Err'.Use the List of Value buttons to Enter Valid Data After all the wrong fields have been corrected Now click the button 'Validate'.(Note 1: Before validation data's can be deleted using the delete button)(Note 2 : The fields highlighted in Red colors are the errors related to "Part No").See below
When the "Validate" button is clicked the "Load Process Sheet From Excel" window appears with a new buttoncalled "Extract" which is shown below.
When the "Extract" button is clicked a message called "Conform Extraction of data" is shown. Click "Yes" to Extract.Then a message box is displayed saying "4 Operations Loaded"(For Example) which is shown below. Click "Yes".
