How to use a variable name as an Excel range?
11 views (last 30 days)
Show older comments
I want to be able to use my variable, Value_Col, as the range which the Excel file references to find the column. The column is not always located in the same place so I am not able to use conventional methods like:'B2:B' to locate the correct column.
0 Comments
Answers (1)
Image Analyst
on 17 Feb 2018
Try something like this:
cellReference = sprintf('A%d:C%d', rowA, rowC); % Create cell reference
[numbers, strings, raw] = xlsread(filename, sheetname, cellReference);
where rowA and rowC are numerical variables saying what rows you want to read in.
Basically you can use sprintf() to build up any cell reference in the standard "A1:B2" style, then pass that in to xlsread().
0 Comments
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!