File Exchange Pick of the Week

September 20th, 2005

Clipboard to Excel

A lot of us MATLAB users hate to admit it, but sometimes circumstances arise and for reasons beyond our control, we need to use Excel. When that happens it is nice to be able to easily bring your data to Excel. There are functions that will do that in MATLAB like, XLSWRITE or XLSREAD. There are products like Excel Link and MATLAB Builder for Excel that help bring MATLAB and Excel closer together.

This is great, but what if you want to do something really simple like copy a single matrix from MATLAB and paste it into Excel. You could always copy it directly from the array editor . But that is like what, three clicks or something. Why go through all that work when Grigor has written this script, num2clip, that will copy a matrix directly to your clipboard so you can just go paste it without copying it manually. I am all for making things that much easier. Also being a function like this allows you to put it into a GUI that you build in MATLAB, adding some nice functionality.

By Doug Hull

16:48 UTC | Posted in Excel, Uncategorized | Permalink |

You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Comments are closed.

About

Bob, Brett & Jiro share their favorite user-contributed submissions from the File Exchange.

Subscribe


Recent Comments

  • Zach: Hi Doug and Les, I didn’t have a lot of time to mess with this, but I did find a work-around. I plotted...
  • hamed: k
  • Les: @Zach This isn’t exactly what you are looking for but at least it puts all three parameters on the same...
  • Zach: Thanks for your suggestions Doug. I’ll give that a shot and see what happens. I’ve seen many of...
  • Doug: @Zach, I would say to use plotYYY, because that is close to what you want, but using depth as Y makes sense....
  • Doug: @Teja, I think this will work: http://www.mathworks .com/access/helpdesk /help/techdoc/ref...
  • Gify: merry christmas :) nice christmas tree! Regards, Janet Gify
  • Teja: Dear Doug Is there anyway to plot a surface from nonuniform data without meshgrid and griddata? Basically i...
  • Zach: I’m working with geophysical data, so I’d like to produce a depth profile. The y-axis would be...
  • Doug: @Ashok First, please do not use variable names that are MATLAB commands (std and mean). Second, p(j) should be...

Blog Admin

These postings are the author's and don't necessarily represent the opinions of The MathWorks.