Font color from Excel to Matlab

Hi,

I've to import a lot (four years logged every minute for 60 objects) of logged data from Excel into Matlab. If the logger wasn't working properly during a measurement the data in Excel is coloured red. Is there any way I can get the color of the data in Excel to Matlab so I can sort the data that wasn't measured properly?

Answer 1

[ES]

objExcel=actxserver('excel.application');

objExcelW=objExcel.Workbooks;

objExcelF=objExcelW.Open('ExcelFileName');

objExcelS=objExcelF.ActiveSheet;
colour = objExcelS.Range('A1').Interior.color; %To read the colour of A1 cell
objExcelF.Close;
objExcel.Quit;
objExcel.delete;

You can read the colour value and split the colours

http://www.rapidtables.com/convert/color/how-rgb-to-hex.htm

[R, G, B] to hex is R*256*256+G*256+B where R, G, B can be (0 to 255)

[Helma Maria Tróndheim]

Thank you, but I wanted the font color, so I changed it to:

colour = objExcelS.Range('A1').Font.color;

This worked

Answer 2

[ES]

It is not straighforward. You will have to use ActiveX https://in.mathworks.com/help/matlab/matlab_external/using-a-matlab-application-as-an-automation-client.html