I am working on excel data, with in a specific range(B16:K400) there are few cells that have blue color back ground. I need to take out those value and save them to a variable.
I have tried and succeeded getting values from individual cells.
excel = actxserver('Excel.Application');
excel.Visible = true;
workbook = excel.Workbooks.Open(filename);
rgb = workbook.Worksheets.Item(sheetname).Range(cell).Interior.Color;
but, I can work one cell at a time. by doing for-loop I can do for a given range of cell.
My problem is how can i get a array of cell Names if i have a range.
It would be great if some one can suggest me, Thank you in advance