num2clip: copy numerical arrays to clipboard

Copies a numerical array to the clipboard as a tab-separated string ready for pasting.

Description

A basic extension to the existing MATLAB function clipboard.m. This function allows a numerical array of any size to be copied to the clipboard ready for pasting (to say Word or Excel).

The array is copied as a tab-separated string with carriage-returns separating subsequent rows.

I suspect someone may have created this already but I can't find anything on the exchange. Sorry if I am duplicating code.

• Acknowledgements: This submission has inspired the following:; MAT2CLIP, Straightforward COPY and PASTE functions
• MATLAB release: MATLAB 7.0.4 (R14SP2)

[James J. Cai]

 

[Gerd Kunert]

The idea is nice.
However, Excel has very strange ways to open files and to import data (depending e.g. on your language).
In other words, the pasted data may be formatted in an "arbitrary" way. In my case, values were simply not correct.

Conclusion: Use xlswrite to export data to Excel. Otherwise fine.

[Gabriele Bulian]

I had to change the line:
arraystring = num2str(array');
into
arraystring = num2str(array,'%100e');
otherwise I had some problems in making excel recognise the data...

[Mink H]

Nothing wrong, it just works!!
I pasted directly into excel with no problems.
Keep it up!

[Jon Petter Grandal]

Working excellent! This saves me a lot of work. Thanks!