MATLAB: Print screen of an excel worksheet using a matlab script

excelimageimage acquisitionimporting excel dataMATLAB

Hi
Does anyone know how to do a screen capture / print screen of an excel worksheet using a matlab script?
I have a script that sends a lot of information to an excel worksheet, I then need this information to be saved as an image file (with the excel formatting). This all has to be done automatically so I can't just manually take a printscreen, it must be part of my script
thanks
Andy

Best Answer

As far as I know, there is no direct cammand in MATLAB to to take screenshot.
You can try below piece of code for it. (Copied from here)
robo = java.awt.Robot;     
t = java.awt.Toolkit.getDefaultToolkit();      
%# Set the capture area as the size for the screen     
rectangle = java.awt.Rectangle(t.getScreenSize());      
%# Get the capture     
image = robo.createScreenCapture(rectangle);      
%# Save it to file     
filehandle = java.io.File(sprintf('capture%d.jpg', i));        javax.imageio.ImageIO.write(image,'jpg',filehandle);
Also, there are lots of free print screen utilities available on internet like this one.
Install any such utility and run it from MATLAB using dos() or system() command.
Related Question