Support > Forums > OpenBots Studio > Excel - Load Dictionary - ERROR Unable to convert DTNull to string

Excel - Load Dictionary - ERROR Unable to convert DTNull to string

Gabriel Diaz

  • Reporter
  • Calender Icon October 14,2022 at 4:50 PM

Helllo I enconter this error while trying to run a simple automation I have an excel file with two columns one for the key values and other for the values that will be save for later used. Is there is a way to solve this error or should I iterate throw each row to convert a read range to a Dictionary ?

This forum has 314 topics, 681 replies, and was last updated 20 days ago by Support Agent

Rushabh Arbat

  • Participant
  • Calender Icon October 18,2022 at 6:08 PM

Hi Gabriel Diaz,

Thank you for sharing your query.

There are some cases which gives this error - Key column name and value column name should be match - Key always should be unique - Key should not be Null

You are not authorized to reply, please click here to login and add your reply to this topic.