Excel reading data into a datatable

Hi all,

   when we are reading the excel file(that excel file is having background colors) i am able to store the data only into the data table i am not getting cell colors while we are using the read range.

@kalyanDev u wont get cell color in read range activity.

thanks @Manjuts90

Hi @kalyanDev, if you want to get cell color, you have to use Get Cell Color activity.

hi @quihan, i just want to get cell color in read range while reading excel it self i need to get…

There is no such built in activity for now.

is there any way to achieve this…

Hi @kalyanDev, I guess the only way is to loop through each cells, use Get Cell Color activity and store the color value in your datatable.