Import table from row oriented excel sheet
39 views (last 30 days)
Show older comments
Bruce MacWilliams
on 22 May 2019
Commented: Jerome Baranger
on 22 Apr 2022
I have Excel worksheets oriented such that variable names are in the first column and variables in rows. e.g.:
Var1 1 2 3 ...
Var2 4 5 6 ...
Var3 7 8 9 ...
etc.
This would be "row oriented" data to use the Matlab description of the readtable command which is expecting "column oriented" data. There does not seem to be a way to use readtable to transpose the data so it is read correctly. I can read the array and then transpose the data but there does not seem to be a way to read in variable names from a column with this command/approach. Seems like this should just be a simple orientation option that you can set in the function call or table options. Am I missing something? I looked at a bunch of similar themed questions but did not find a satisfactory answer. My guess is that I have two choices if I wnat to end up with table data:
1) Transpose the data in Excel into a new worksheet and use readtable()
2) Use xlsread() or some other variant to read data and varialbe names into separate arrays, do the transpose on the data and cobble together the table using opts.VariableNames
1 Comment
Bob Thompson
on 22 May 2019
Does the option to 'ReadRowNames' not work for your situation? This is for the readtable command.
Accepted Answer
More Answers (0)
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!