In Robotiq documentation writes : If file at the defined File path folder does not exist, file will be created containing the data from the datatable variable at the defined sheet name.
Today, my process failed because the datatable could not be saved into the dtPath variable that I create in the script step (this process had previously run successfully in production this way). Compared to the last deployment, I made minor changes to the filter settings on the website, but these changes do not affect either dtPath or the dt itself. The entire point of the process is to scrape data into a datatable and save it in an Excel file that is sent to the client. When I identified the error, I tried to create a process that would save an empty dt to a path that was not defined, resulting in the following error message (link below). When I manually created the file and saved the datatable into it, it executed successfully. I am wondering if it is necessary to manually create Excel files or this step automatically creates them? I should note that I currently have multiple processes in production where the described situation occurs and i dont have problems with that. Did something change in way which this step works?
https://drive.google.com/file/d/1TX2zb_-MmlkzsVw33hrjTHdq7nbSODGl/view?usp=sharing
- ManjaDex asked 9 months ago
- You must login to post comments
The issue arises when trying to save an empty datatable. If the variable does not have any values, it cannot be saved. However, the process will succeed if the datatable variable is not empty. Furthermore, this step will work correctly if the datatable is not empty, even if you don’t have Excel (it will create the Excel file) and/or if you don’t have that specific sheet name (it will create the sheet and save the datatable within it).
- Emb answered 9 months ago
- You must login to post comments
Please login first to submit.