Lately, I have been playing around with the Excel spreadsheet import functions. What I am trying to do is to import both text and numerical values, and then have each text column correspond to each numerical column. For instance:
Let us assume that we have a excel speadsheet:
first column second column
Text A 10
Text B 20
Text C 30
While [text, data] = xlsread('name of spreadsheet') pulls both the text and the numerical value from the excel spreadsheet, it does so assigning "name = A B C" and "data = 10 20 30" Is there a way to automatically assign "A = 10, B = 20, C = 30"?
I apologize if this has been asked before. I have searched far and wide, without finding the answer. The Matlab help file also comes up empty on this.