does anybody know the problem “The given Key was not present in the dictionary” with the stand-alone “Write Range” Activity?
I just use the read range inside an Excel application scope and try to write the output (data table) into another Excel Workbook with the stand-alone write range activity. Then I get that Dictionary error but I don`t use it in my workflow, I just want to write the data table.
The funny thing is, if I use the write range acticity from the Excel application scope I don`t get the error.
I would like to use that one because I dont want to open Excel in the foreground if I dont have to.
Alternatively, if you could reproduce the issue on a fresh new project with dummy Excel files and send it in this topic, it would help us quickly address the bug (if it still exists in the latest activity package version)
Actually its working for normal scenarios. but when I parse SheetName and Filepath from argument it giving above error
SheetName = in Argument type - Dictionary <String,String> Value = “5. combined ABC100_ABC100 LF”
Filepath = “Data\Output\something\11.18.2020\Something ABC_100_11.18.2020.xlsx”’
DataTable = comes from SQL query result
when I’m running using above input it will fail and if I used excel activity it works but for workbook activity it fails
I am having trouble reproducing it on the latest Studio 20.10 and the same activity package as you are using.
Are you should that your dictionary is correctly set when you are using the arguments? (this is only a slight suggestion, I assume it is due to the fact it exactly the same for Excel Application Scope).
I would really appreciate a full project that reproduces the issue. It doesn’t have to be your specific project, but could be a newly created one with minimum amount of activities that will reproduce the issue.
Thank you for the support, ya i’m using exact same argument for the Excel activities then it works fine but for the Workbook activity it wont work,
I’ll replicate code into new project and send you ASAP
If I walkthrough the bigger picture it like I have a template and I coped into a directory to produce my final result and the all output path names are pass into the immediate next flow and in that flow SQL query result will be entered into a one sheet using Workbook > write range activity the issue is if I Hardcode all the values and run the process if gives me the above error even I haven’t used any Dictionary
I could Repro with the following setting:
When the write range is used into an existing XLSX where in the header a column has either a NOTE or a COMMENT, then this error is thrown. @Pablito posted in internal activities channel with repro workflow