For Programmers: Free Programming Magazines  


Home > Archive > Matlab > February 2007 > Re: Write a Matlab PLOT directly into Excel or WOr









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Re: Write a Matlab PLOT directly into Excel or WOr
Gerald Dalley

2007-02-28, 10:13 pm

engr.student wrote:
>
>
> On Feb 28, 4:42 pm, manya <manya_no_S...@yahoo.com> wrote:
directly[color=darkred]
> pasting it
>
> Manya,
>
> Whatever answer you get is going to be system dependent. I program
> on
> a mac, and every pc-function that works to interface excel to
> matlab
> doesnt work on a mac. The file formats are different, and
> incompatible. The operating system doesnt have the same hooks when
> generating compatible image files. Yes Microsoft cheats and builds
> hooks in excel that talk to the OS and hooks in the OS that make
> excel
> interoperable. Its just ugly.
>
> If you want a system dependent solution, then I dont know what it
> is.
>
> If you want a more system-independent solution, then there is a
> better
> way. I would take the plot figure and export it to eps, or pdf and
> then import that into the excel or word. Those handle the
> postscript
> a little better, and it doesnt necessarily require cheating on the
> part of Microsoft in order to work well.
>
> -mm
>
>


I've used the general mechanism that engr.student suggests, however
Microsoft's support for PDF and EPS is quite poor (maybe Office 2007
is better?). Instead, if you want to import into Office apps, export
to an EMF file. Use the "print" command in matlab using the "-dmeta"
format. I always save directly to a file and then import the file
into Word. Apparently there's some way to use the print command to
copy the figure to the clipboard.
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com