Copy utiable to Excel
14 views (last 30 days)
Show older comments
I have populated a uitable created in GUIDE with some data. I want to be able to click a button and have the uitable data copied to clipboard so I can then paste into Excel. So far I have the following code for a button callback:
s=get(handles.uitable1,'data');
clipboard('copy', s);
However, this just creates one large string in excel and not each uitable cell to an exel cell. any suggestions. Thanks Jason
0 Comments
Answers (1)
Robert Cumming
on 24 Feb 2011
you will see in the clipboard help that clipboard converts your matrix to a string using MAT2STR.
In the past I've had a similar issue and in that case I created the string myself with delimiter between each number (build it with sprintf and formatting).
7 Comments
Jay Basingerja
on 2 Apr 2020
Thank you Paolo and Robert, this worked for me as well.
Frustrating that it isn't already something addressed by Mathworks, because that was a key reason I was building my GUI in the first place, to provide data that could be copied out to Excel and pasted where the user wanted it, but this will serve as an acceptable workaround.
See Also
Categories
Find more on Environment and Settings 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!