Managing File Path Setup for Runtime Data Operations

When this issue occurs, you may observe the following behavior: 

• The test step fails during execution when attempting to write data in Excel. 
• The error message displayed is: File path not set None

This issue may occur due to one or more of the following reasons: 

• The file path for the Excel file was not set before performing write operations. 
• The required step to initialize the file path is missing in the test case workflow.

To resolve this issue and ensure successful execution, perform the following actions:

1. Add a prerequisite step before Excel operations: 
   Ensure that the file path is defined before attempting to write data. 
2. Configure the step correctly:  
   • Select Element Type as "Element" 
   • Choose the action "Set Path for File" 
   • Provide the correct Excel file path in the input value field 
3. Use the correct syntax for setting file path: 
   <File Path>;<SheetName (optional for Excel)> 
   Example: 
   C:\Users\vijayalaxmi.desai\Downloads\Fund Transfer.xlsx;Sheet1  
   
   If a sheet name is provided, the system will operate on that specific sheet.
   
   
4. Verify the sequence: 
   Make sure the "Set Path for File" step is executed prior to any Excel write actions in the test flow.

• This step is mandatory for Excel operations and must be added before write action. 
• For Data Table operations, this step is not required, as the data table does not depend on an external file path configuration.