MATLAB: Font color from Excel to Matlab

colorcolourexcelMATLAB

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?

Best Answer

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)
Related Question