Excel reading data into a datatable


#1

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.

#2

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


#3

thanks @Manjuts90
yes…


#4

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


#5

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


#6

There is no such built in activity for now.


#7

is there any way to achieve this…


#8

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.