no matter what I change in append range I get an error when working on exercise 2. Anyone that can help?
Hi @gigjat22,
Use the same Excel Scope for both Write Cell and Append Range, as UiPath requires consistent workbook reference.
Also provide the details of the error message please.
Let me know the update
Hey @gigjat22,
Append Range only accepts an output from Read Range not a single cell value.
Use Read Range to capture the source data as a range reference.
Pass the Read Range output into Excel range to append.
Try and let me know.
If it helps the whole project looks currently like this. I was trying to keep going but it resulted in more errors.
Hey @gigjat22,
Read Range output must be saved into a variable like dtData not a sheet string.
In Append Range assign Excel range to append = dtData.
Keep target location defined in Append after range.
Check this document:
In Append Range you cannot pass Excel.Sheet(“Sheet1”).Cell(“A2”) .
Read Range must output to a variable (e.g. dtData) instead of sheet name text.
In Append Range set Excel range to append = dtData and target sheet/cell in “Append after range”.
Sorry for the confusion and resulting more error you can keep the 1st approach ignore the read range part your image was not so clear i just misunderstood. In your initial append range activity follow:
Since In Append Range you cannot pass Excel.Sheet(“Sheet1”).Cell(“A2”).
Read Range must output to a variable (e.g. dtData ) instead of sheet name text.
In Append Range set Excel range to append = dtData and target sheet/cell in “Append after range”.
Hey @gigjat22,
Looks like so, double check if you are getting expected output.
If I am able to help you then please mark as solution.
Thanks happy automation.
You are most welcome. Happy automation.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.