cancel
Showing results for 
Search instead for 
Did you mean: 

How to read Excel values ​​including color information

sumire
Level 8

Hello,

I have a Excel table like this:

sumire_0-1715587108549.png

I would like to get the values ​​of this table as collection, including color information.
Like this:

sumire_1-1715587340222.png

I'm looking for a suitable method.
If you know of a better way, please let me know.

------------------------------
Mitsuko
Asia/Tokyo
------------------------------
10 REPLIES 10

sumire
Level 8

Thank you for your help.

The results of considering this issue are as follows:

  1. Add a symbol to identify the color before colored text using an Excel macro
  2. Get an Excel sheet into a collection in a Blue Prism process
  3. Add a column 'color' and write in the 'color' column while removing symbols to identify the color.
  4. Use the Excel macro to delete the color identification symbol added to the Excel sheet.
------------------------------
Mitsuko
Asia/Tokyo
------------------------------