Welcome Guest.   Make a donation to an author on the site September 01, 2014, 02:46:58 AM  *

Please login or register.
Or did you miss your validation email?


Login with username and password (forgot your password?)
Why not become a lifetime supporting member of the site with a one-time donation of any amount? Your donation entitles you to a ton of additional benefits, including access to exclusive discounts and downloads, the ability to enter monthly free software drawings, and a single non-expiring license key for all of our programs.


You must sign up here before you can post and access some areas of the site. Registration is totally free and confidential.
 
Read the full one-year retrospective report on DonationCoder.com.
   
   Forum Home   Thread Marks Chat! Downloads Search Login Register  
Pages: [1]   Go Down
  Reply  |  New Topic  |  Print  
Author Topic: xls to png  (Read 4292 times)
kalos
Member
**
Posts: 999

View Profile Give some DonationCredits to this forum member
« on: April 06, 2012, 08:43:32 AM »

hello!

I want to select cells in EXCEL and export them as image (screenshot) with one click

is it possible?

thanks!
Logged
Carol Haynes
Waffles for England (patent pending)
Global Moderator
*****
Posts: 7,952



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #1 on: April 06, 2012, 10:09:21 AM »

You could use a screen capture tool and then select the cells you want to capture.

Not sure how you do it with one click.
Logged

kunkel321
Supporting Member
**
Posts: 385


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #2 on: April 06, 2012, 12:34:04 PM »

Excel does have the ability to "paste as image."
http://i.imgur.com/Vtrp3.png
Though it might only work from within an Office app....  I'm sure you'd be able to "paste special" into an Outlook message.
Logged
Carol Haynes
Waffles for England (patent pending)
Global Moderator
*****
Posts: 7,952



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #3 on: April 06, 2012, 01:40:56 PM »

You learn something new every day - thanks  Thmbsup
Logged

kalos
Member
**
Posts: 999

View Profile Give some DonationCredits to this forum member
« Reply #4 on: April 06, 2012, 02:13:58 PM »

amazing!
pity it is not available in EXCEL 2003
Logged
skwire
Charter Member
***
Posts: 4,036



Another Coding Snack request? Om nom nom...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #5 on: April 06, 2012, 02:16:19 PM »

Excel does have the ability to "paste as image."

Maybe the feature you point out is what kalos wants but it sounds to me like he wants something like "copy as image" instead of "paste as image," right?  If so, Excel 2007 does have this feature:



Works with whatever you have selected.  Yeah, really intuitive being on the paste menu...
Logged

kunkel321
Supporting Member
**
Posts: 385


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #6 on: April 06, 2012, 02:57:32 PM »

Cool.  I didn't even know about the "copy as..." feature.

I know Office 2003 does have "paste special" options (in think in the Edit > Paste menu). 
Maybe there are some "copy special" items too..
Logged
bob99
Supporting Member
**
Posts: 322

see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #7 on: April 06, 2012, 04:54:24 PM »

This isn't a one-click solution but you can do the same thing in Excel 2003.

Found this on Bright Hub How to Save an Excel Object as an Image

The article gives a step by step for both 2007 and 2003. Maybe a macro/script could make it one step??

Logged
x16wda
Supporting Member
**
Posts: 446


what am I doing in this handbasket?

see users location on a map View Profile Read user's biography. Give some DonationCredits to this forum member
« Reply #8 on: April 06, 2012, 05:08:59 PM »

Wow that looks convoluted!  cheesy
Logged

vi vi vi - editor of the beast
cranioscopical
Friend of the Site
Supporting Member
**
Posts: 4,167



see users location on a map View Profile Read user's biography. Give some DonationCredits to this forum member
« Reply #9 on: April 07, 2012, 02:42:40 AM »

The article gives a step by step for both 2007 and 2003.
In 2007 one can add the relevant comands to the quick access bar...
Logged

Chris
erikts
Supporting Member
**
Posts: 145


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #10 on: April 07, 2012, 08:04:33 AM »

amazing!
pity it is not available in EXCEL 2003

In Excel 2003: Push and hold Shift key and click Edit menu. You will have three new command: Copy Picture, Paste Picture, and Paste Picture as Link.
Logged
bob99
Supporting Member
**
Posts: 322

see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #11 on: April 07, 2012, 08:15:39 AM »

I should have added more to my post above but I was pressed for time.

Like x16wda says it is pretty convoluted with 2003. But since kalos mentioned using 2003 that is what I had found in an earlier time when I was trying to do the same. I'm also still running 2003 on one machine and didn't have 2007 yet on my other one. It is much easier now with 2007. My reference to maybe using a script or macro to make it easier should have said for the 2003 edition.

Another thought, is this something that could be accomplished using one of the free alternatives like LibreOffice? I don't have a copy installed, but if someone else does maybe they can answer.
Logged
IainB
Supporting Member
**
Posts: 4,640


Slartibartfarst

see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #12 on: April 07, 2012, 12:46:04 PM »

I'm not sure about Excel 2003, but the (non-intuitive) Excel 2007 approach described above works fine. The image is copied into the Clipboard and can be pasted from there.

Just a thought: Alternatively, if you used (say) ScreenShotCaptor (SSC), then the image is captured into SSC's working buffer and saved as a file. However, I think SSC does not get the image copied into the Clipboard. So, to get the image into the Clipboard, you have to select the image (or a part of it) captured in SSC, copy it and then you can paste it from the Clipboard.
Logged
tomos
Charter Member
***
Posts: 8,477



see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #13 on: April 07, 2012, 12:49:28 PM »

if you used (say) ScreenShotCaptor (SSC), then the image is captured into SSC's working buffer and saved as a file. However, I think SSC does not get the image copied into the Clipboard.

see SC Options >Post Capture Options
Select "Copy image to clipboard" :-)
Logged

Tom
erikts
Supporting Member
**
Posts: 145


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #14 on: April 07, 2012, 01:01:43 PM »

You can also copy a range in Excel and paste it to IrfanView and save it as PNG. Yes, it is not one click solution.  Grin
Logged
IainB
Supporting Member
**
Posts: 4,640


Slartibartfarst

see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #15 on: April 07, 2012, 02:25:42 PM »

if you used (say) ScreenShotCaptor (SSC), then the image is captured into SSC's working buffer and saved as a file. However, I think SSC does not get the image copied into the Clipboard.
see SC Options >Post Capture Options
Select "Copy image to clipboard" :-)
Thanks @tomos! I felt sure there would be a way to do that.
EDIT: Oops. Spoke too soon.
My SSC seems to give me just the image file path, not the image.
The second tickbox apparently overrides the first.
« Last Edit: April 07, 2012, 02:51:10 PM by IainB; Reason: Added image. » Logged
kalos
Member
**
Posts: 999

View Profile Give some DonationCredits to this forum member
« Reply #16 on: April 07, 2012, 05:31:29 PM »

This isn't a one-click solution but you can do the same thing in Excel 2003.
Found this on Bright Hub How to Save an Excel Object as an Image
ohmy ohmy ohmy ohmy
omg, those people at Microsoft did this on purpose? this excellent feature is hidden in a way most could never imagine to trigger (ie. open a filemenu entry, while keep SHIFT pressed, does nothing in most GUIs)
« Last Edit: April 07, 2012, 05:38:02 PM by kalos » Logged
Renegade
Charter Member
***
Posts: 11,191



Tell me something you don't know...

see users location on a map View Profile WWW Give some DonationCredits to this forum member
« Reply #17 on: April 08, 2012, 03:10:37 AM »

This isn't a one-click solution but you can do the same thing in Excel 2003.
Found this on Bright Hub How to Save an Excel Object as an Image
ohmy ohmy ohmy ohmy
omg, those people at Microsoft did this on purpose? this excellent feature is hidden in a way most could never imagine to trigger (ie. open a filemenu entry, while keep SHIFT pressed, does nothing in most GUIs)

Yeah, it's so well hidden that if MS didn't have a strong anti-Easter egg policy, you'd have to guess that it was an Easter egg.
Logged

Slow Down Music - Where I commit thought crimes...

Freedom is the right to be wrong, not the right to do wrong. - John Diefenbaker
AndyM
Charter Member
***
Posts: 616


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #18 on: April 08, 2012, 05:26:39 PM »

I want to select cells in EXCEL and export them as image (screenshot) with one click
I'm still using Excel 2002, but the Shift-Edit thing works.  When I record using it to copy a picture or group of cells  to the clipboard, one line of code is generated:

Selection.CopyPicture Appearance:=xlScreen, Format:=xlBitmap

So this would be the first line of a macro you could assign to a button.  Select your picture or cells, click the button, and the picture is copied to the clipboard.

There is vba code to save files, etc.  When you say "export as image" you mean to a file?  What kind?
« Last Edit: April 08, 2012, 05:39:40 PM by AndyM » Logged
kalos
Member
**
Posts: 999

View Profile Give some DonationCredits to this forum member
« Reply #19 on: April 08, 2012, 05:35:26 PM »

When you say "export as image" you mean to a file?  What kind?

yes, to a graphics file of any kind in My Documents folder or something

the different options "as shown on screen" and "as printed" would be nice to be available in the macro as well (just via different hotkey)
Logged
AndyM
Charter Member
***
Posts: 616


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #20 on: April 08, 2012, 05:46:18 PM »

Selection.CopyPicture Appearance:=xlPrinter, Format:=xlPicture
    checked this again, either it quit working or never did, sorry
Something always worth trying is recording a macro.  I just recorded it again but this time selected "as printed".

It's been a while since I've used Excel daily.  Back then I would have either been able to quickly give you the basic code to save files, or looked at something similar I'd already done (more likely) and then modified it.

I don't even remember which spreadsheets had the good file-related code I was using, so I'll first try to record something to see if it jogs the memory.  I'll get back to you.
 
« Last Edit: April 08, 2012, 05:52:07 PM by AndyM » Logged
AndyM
Charter Member
***
Posts: 616


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #21 on: April 08, 2012, 08:16:27 PM »

I realized that I had never seen (never needed) any "save selection" choices in Excel and Excel-specific VBA.  I started fooling with it and realized it was going to be more than a few lines.

So I googled "excel save selection as image" and got all sorts of interesting stuff, but more involved than I thought.  I'll use code I don't completely understand if I understand the purpose, input, and output of the chunks I don't get.  And if the code works right off, or with a little modification of the parts I do understand.

What you could also do is have Excel copy the selection as a bitmap to the clipboard, and then have the last line of the vba code call something else (an Autohotkey script, a batch file, etc).  This could all be run with just one click.
Logged
kunkel321
Supporting Member
**
Posts: 385


see users location on a map View Profile Give some DonationCredits to this forum member
« Reply #22 on: April 09, 2012, 09:57:39 AM »

@Andy:  No kidding!  I just found this http://office.microsoft.c...in-excel-HP010014103.aspx  Apparently Excel 2007 has 13 different clipboard formats (21 if you count the different extensions). 
Logged
Pages: [1]   Go Up
  Reply  |  New Topic  |  Print  
 
Jump to:  
   Forum Home   Thread Marks Chat! Downloads Search Login Register  

DonationCoder.com | About Us
DonationCoder.com Forum | Powered by SMF
[ Page time: 0.054s | Server load: 0.13 ]