"Create vectors from each column using column names" option greyed out, how to access it?
6 views (last 30 days)
Show older comments
I have a script to pull an n number of variables from a spreadsheet and have it create .mat for the respective variables selected. I have as seen in the photo two column vectors each have a column header, red then green. In the past I was able to use the "Create vectors from each column..." option but am now not able to. My spreadsheet has not changed nor has any of the script. I am not sure why I am not allowed this option nor what to do to allow me.

2 Comments
Accepted Answer
More Answers (1)
Steven Lord
on 27 Mar 2021
Are the column names in the spreadsheet valid MATLAB identifiers (if you passed them to isvarname would it return true?)
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!