topic Re: Read Excel Data with Same Cell/Font Color into BP Collection in Product Forum

Read Excel Data with Same Cell/Font Color into BP Collection

salman_shaik — Thu, 21 Sep 2023 13:44:33 GMT

Hi Team,

I have a requirement, in an excel file we have some data, some of the rows are colored and some of them are not. So, when we read the data from excel the data should be captured along with exact cell/font color into collection. Then after doing some validations i have to paste the collection data on the body of the email.

I am able to paste the collection data on the body of the email but i am not able to get the data along with the color into collection.

The following things needs to be considered.

Colors will be changing by the business end, so we cannot apply the color while creating the HTML body. We must copy the color from excel to collection.
In the entire excel sheet we should read the data along with the cell/font color only for some specific rows, so we should have the flexibility in our code such that we have to give the which row number/ numbers should be extracted with cell/ font color rest all rows can be read as usual.

Thanks

Salman Shaik

Re: Read Excel Data with Same Cell/Font Color into BP Collection

Athiban_Mahamathi — Thu, 21 Sep 2023 14:30:17 GMT

Hi Salman,

Obtain the background cell color code for each row (create a custom code action to achieve this) and utilize these color codes to generate the HTML body with corresponding colors.

Re: Read Excel Data with Same Cell/Font Color into BP Collection

salman_shaik — Thu, 21 Sep 2023 15:35:17 GMT

Hi Athiban,

In my case under each row the cell colors are different based on the column no as well so it will be complicated, if the entire row contains same color irrespective of column no, then we can follow your approach. But unfortunately, it's not the case.