Home Retrieve all excel cell names within given range
Reply: 0

Retrieve all excel cell names within given range

user721 Published in May 24, 2018, 11:25 pm

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

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.336161 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO