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.
Can you Verify the Properties of the Write Range - There you are not using ant dictionary on timeouts. Also, One More thing you can try Here … Copy paste this code in a new Xaml File and then Run .
Visible - When selected, the Excel file is opened in the foreground while performing actions on it. When it is cleared, all operations are done in the background.
Have you got any solution for this issue. lately I’m also trying to resolve this issue. I did everything but I think it’s a Bug. @Pablito, @loginerror, @Syed_Pasha is there any solution for this issue
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
the same activity for excel application scope works fine as they said before. Thats the way I solved it.
But issue keeps appearing in the standalone activity.
The year is February 2022. I lost 3 hours before I realized that the fault was in the note in the cell !!! Why has it not been further fixed? What a crap
ashokkarale
anjani_priya
Dheerendra_vishwakarma
Parvathy
Aakash_Singh_Rawat
Luis_Fernando
bjorn2390
neco
pere
Shiva_Nikhil