This is not a very straightforward task, but it is possible to access most of the information you need from an excel file through the excel interop. Here is an example I have made previously of how to get the cell color from an excel file (this is not what you are doing, but similar methods may be used to achieve your specific solution). There are also plenty of methods to work with revit tables which I have not personally used, but may be of use to you.
2 Likes