Read and write data in same excel

Hi All,

I am working on a use case in which bot will read data from excel using API call fetch data from weather API and update temp in same excel from which it reads data.

While running the USeCAse getting error --Read Range: A column named ‘CityName’ already belongs to this DataTable.

Main.xaml (12.4 KB)

Hi @shashank_dullu

This error will occur when you have duplicate column names in headers.

check this post as well,

Thanks
Latika