Dictionary to Excel column

[Julien_Horreau]

Hello everyone,

I have a technical problem …
I have a data dictionary (new dictionary (of String, String), whose keys are the column titles of an output Excel file.
I want from my dictionary to feed my Excel file according to the key (which is linked to the column name.

Thanks in advance for your help.

[Parvathy (PS Parvathy)]

Hi @Julien_Horreau

Check out these threads. It might help you.

Writing data in excel from dictionary

Hi, I need to write data in excel file from dictionary(key, value) both key and value are string type. Conditions are, My excel sheet already have some data. I have to match key of a dictionary to excel header and write dictionary value into same column below the existing data. thanks in advance

How do I print from Dictionary to Excel?

Hello All, my first post here. I am curious how to print my data from a dictionary to an Excel file. The dictionary (myDict) contains a key (string) and a List(of string). The List(of string) is called dictList and contains two items. I initialize both at the beginning to be able to work with them. Then I read the range of my config xlsx file to add the key-value pairs to the dictionary and they correctly appear in the dictionary. Example: “180012”: {“Eastern Airlines”, “Aviation”} Now, I…

Regards,

[postwick (Paul)]

Create datatable variable

• For Each CurrentKey in yourDict.Keys
  ** Add Data Column CurrentKey to yourDT
• Add Data Row to yourDT with row array set to yourDict.Values
• Write/Append Range to Excel from yourDT

[ppr (Peter Preuss)]

Write range Activity (e.g.Workbook, Classic with EAS,…)
In the field, where the DataTable will be passed use

Newtonsoft.Json.Linq.JArray.FromObject({YourDictVar}).ToObject(of DataTable)

Sample: