MATLAB: Get information from Excel file based on cell color
cell colorĀ“get cell information
How can i get information of the cell fill in an excel file. Like there could be more than one cell coloured.
Best Answer
It is certainly possible to query the cell colour in an excel spreadsheet from matlab (only on Windows, with Excel installed) however you will need to be familiar withExcel object Model. In addition, there is no function in Excel to find all the cells of a specific colour, so you'll have to loop over the cells and query their colour one by one.
If either of these is an obstacle, I would suggest that you find a different way of defining your cell range.
Here is an example of how to query the colour of a cell:
Best Answer