I have a large Excel workbook with multiple sheets. We are trying to save the workbook with the resolved values and removing both the formulas and conditional formatting. Part of the resolution includes conditionally formatting the fill color of some cells. I'm trying to find a way to get the fill color that the Excel app would use to render the cell in a window. This process is running on hundreds of sheets with no UI though. Launching Excel is not a viable solution.
The desired end result is a set of sheets that have no formulas, no conditional formatting, etc. but the result of calculating the value of each cell and applying the conditional styles. I've gotten the value but haven't had any luck following the model to find the fill color based on the conditions. Any suggestions? Links, snippets, etc. all welcome.
I need to do this using the DocumentFormat.OpenXml nuget package.