How to read Excel values ​​including color information

[sumire]

Hello,

I have a Excel table like this:

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

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

[sumire]

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.