I am using “Use Excel File,” and in the “Do” section of “Use Excel File,” I am using “Write Cell” at the end, but I am encountering the following problem:
From what I’ve researched, “Use Excel File” and “Write Cell” work simultaneously, which causes the issue. However, if I place it outside the “Do” section, I wouldn’t have access to the dtCostData variable where I store the data table I want to read. What can I do?
Place the Write Range Workbook Outside the Do and change the scope of the variable dtCostData variable.
Or use Write DataTable to Excel activity within Use Excel File instead of Write Range Workbook. It won’t throw you an error.
Regards
Hello @rosina.flores
Use excel Process scope and inside use the “Use Excel File” And in that activity select the file which you have to use in Excel File(Property) and in the do section use Read Range(Excel Activity). And store it in Datatable variable
And Use Write DataTable to Excel activity pass the Datatable variable.
Hie @rosina.flores you can do that things with two approaches
1- for write range workbook you don’t need the excel application we widely used write range workbook while the system does not have the excel . so if you go with the write range approach just use write range and delete use excel activity…
2- approach is if you want to use use excel application activity delete write range workbook and instead of this use write range activity…
Using this approaches you don’t get the error .
cheers Happy Automation 
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.