Copy data from Excel Column and Paste in Matlab Row
78 views (last 30 days)
Show older comments
Hi everyone,
I'd like to copy a column with a bunch of values from excel and paste it into a row in matlab. Whenever I paste, the values are pasted in a column. How can I paste it in the row instead? I've seen the option to transpose the data, but that works only with the first set of data, as the transposition of subsequent data will be transposed altogether.
Any help is greatly aprecciated! Thank you.
5 Comments
dpb
on 4 Sep 2022
Edited: dpb
on 4 Sep 2022
I still don't know where you're pasting stuff into MATLAB?
Being older than dirt, I've never used any of the newfangled GUI interface stuff, I operate from the command line or write code; I guess the what do they call it -- the variable editor??? maybe can work sorta' like a klunky spreadsheet, maybe is what your're trying to use???
<poke, poke, ...>
Yeah, guess that must be it -- if open "New variable" I can see a RB click menu that seems to match up with what you describe. Looks like TMW hasn't finished their job; there should be an option on Paste to transpose the pasted data when doing so, but appears not to be implemented.
Looks like if you're determined to play at the keyboard only you're stuck...best plan of attack unless this is a "one-time-only" exercise still appears to me to be to write a script/function instead -- you can make the file selection somewhat less cumbersome for user by using the GUI filepicker in multi-select mode (if at least the files are in one folder).
Failing that, go ahead and paste all the data first, then transpose the results.
Answers (0)
See Also
Categories
Find more on Logical 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!