Hey Guys, does anybody know the problem “The given Key was not present in the dictionary” with the stand-alone “Write Range” Activity? [Error_Dict_1] 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-al…

hi @Akimbow , 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 . Please check the arguments pane also – Mukesh

[image] Akimbow: I don t want to open Excel in the foreground if I don t have to. Have a look on the visible parameter as well: Activities - Excel Application Scope The UiPath Documentation Portal - the home of all our valuable information. Find here everything you need to guide …

Thanks for your help but I think it is a bug of the activity because the same activity for excel application scope works fine. Mmmh…

@Akimbow , 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

Hey @SamanGuruge Could you let us know which version of the Excel activity package are you using? I tested this scenario on this one and it works just fine: [image] Alternatively, if you could reproduce the issue on a fresh new project with dummy Excel files and send it in this topic, it would …

Hi @loginerror , [image] Actually its working for normal scenarios. but when I parse SheetName and Filepath from argument it giving above error [image] SheetName = in Argument type - Dictionary <String,String> Value = “5. combined ABC100_ABC100 LF” Filepath = “Data\Output\something\11.18.202…

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 Applic…

Hi @loginerror , 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…

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

Write Range Error "The given Key..."

Help Activities

loginerror (Maciej Kuźmicz) March 29, 2024, 1:23pm 21

Hi @Juliana_Damiano

Could you please double check with the latest Excel activity package?

Topic		Replies	Views
Error: The given key was not present in the dictionary with several Excel acitivites Activities excel , activities , question	1	1652	February 5, 2021
Write Range: The given key was not present in the dictionary Activities excel , activities , xlsm	12	3193	September 9, 2022
Workbook WriteCell activity issue Learning Hub excel , activities , error	1	1180	June 11, 2020
Write Cell:The given key was not present in the dictionary. Error Help excel , activities	16	6462	January 22, 2020
Regarding excel calculation Activities excel , activities , question	4	507	September 28, 2023

Write Range Error "The given Key..."

Related topics