Export_acad_to_excel

Dear ,
I am working on a project in AutoCAD that involves recognizing the color of individual faces on 3D solids. I have the following question and problem:
Problem:
I am trying to use the AutoCAD API through a Python script to recognize the color of individual faces on solids, which have been assigned using the color faces command. Despite my efforts, I have not been able to obtain accurate information about the color of the faces.
Here is a brief description of my approach:
I connect to AutoCAD using win32com.client.
I iterate through all 3D solids in the model space.
For each 3D solid, I access its Faces and try to retrieve the TrueColor or Color attribute of the face.
I then check the face area and color to assign appropriate values in a table.
Implementation Details:
In my drawing, I have a solid with dimensions 1120 x 300 x 18. One long face is colored red (color index 1), and the three remaining faces are colored yellow (color index 2).
The expected result for my solid is:
Dimensions: 1120 × 300 × 18
Colors:
One long face (red): "ABS22/2".
Three other faces (yellow): "abs22/0,5".
However, the API does not recognize the assigned colors as expected. I have not been able to obtain accurate information about the TrueColor or Color attributes of the faces.
My Question:
Is there a recommended way or tool in AutoCAD that allows precise recognition of the colors of individual solid faces when assigned using the color faces command? Is there an API function or method I could use to successfully read the colors of the faces and their dimensions?
Thank you in advance for your help and guidance.
Sincerely,