Turn spreadsheet into image

I want to turn my spreadsheet into an image.
So far best I have come up with is a Grab image
but with 72 pixels/ inch it is not a very high quality image.

Upscaling line figures in photo apps has not been too successful for me.
Printing and scanning seems to be a doubtful experiment

Any ideas?
Any way to make the spreadsheet almost fill the screen ( a really big Grab image)?

emac, Mac OS 10.5.8, Mac OS 14.11, Mac OS 13.9, Mac OS 9.22 Quadra 660 av, Mac OS X (10.5.8)

Posted on Mar 19, 2011 11:35 AM

Reply
12 replies

Mar 19, 2011 12:07 PM in response to Pat Schaefer

Pat Schaefer wrote:
I want to turn my spreadsheet into an image.


Hi Pat,

You might try turning on Print View (view menu). Then use the slider at the bottom of the page to scale the contents to fill the page. (You can also set the margins to the minimum supported by the printer driver you are using, and the page size to something large as well.)

Press command-P (Print)
Click on the PDF button and select Save as PDF.

Open the file in Preview, and Save as... choosing one of the image formats offered (I tried PNG, but others may be better). If offered a "quality" or "compression" choice tend to the highest quality or lowest compression.

Regards,
Barry

Mar 19, 2011 1:24 PM in response to KOENIG Yvan

I just discover a free tool which crops PDF.

http://www.ne.jp/asahi/mijinko/mac/ja/Downloads/PDFCropperX/PDFCropperX.html

I would use it in lieu of Preview because it stores only the cropped area.
Preview is non-destructive so in fact, it doesn't crop, it masks.

Oops, forgot that.

I forgot the "Make a PDF from the clipboard" feature available in Preview.

Yvan KOENIG (VALLAURIS, France) samedi 19 mars 2011 21:09:43

Mar 19, 2011 1:23 PM in response to Pat Schaefer

Pat,

Get to know Preview. It's your built-in Swiss Army knife for graphics. Whatever you place on the clipboard in Numbers, or any other app, you can convert to any supported graphic type in Preview.

Let's say you would like to make a graphic of just part of a table. Select the cells and Command-C. Switch to Preview and Command-N. You now have a graphic file that you can Save to any supported format using the File menu in Preview.

Jerry

Mar 19, 2011 2:16 PM in response to Pat Schaefer

Okay here's as far as I got.
The print view was a good idea but seems to be missing some "print setup" capabilities.
Could not get numbers to accept a big paper size, so it always tried to chop the sheet into pieces.
From "Print" went to printer and set paper size to L (ledger I hope),
thinking it would give me a landscape 11x17 page to work with.
Numbers did not seem to recognize. so I stopped and tried something else.
The view magnification could use a type in function from 150% to 200% was too much.
I ended up in ss view, but with ss as object (with handles)
Scrunched sections tab on left as small as possible, would like to have hidden
Made window as big as possible, moved sections tab off screen
grabbed ss by corner and stretched to a full 13.76 x 8.67
and took a Grab shot of that. Probably not too bad for a emac screen.
Mad science experiment, put ss on wife's macbook,hook up to sony tv, and grab a big big shot there

Mar 19, 2011 2:27 PM in response to Pat Schaefer

On other front
Many photo apps allow you to change the 8 x 10 72 pixel/inch image
into a 2 x 2.5 200 pixel/inch image. Uncheck all interpolation features.
Still not sure what it is you end up with, it hurts my head to think about.
But maybe if you take a really large 72 ppi image and collapse, it will be an image of acceptable quality.

Cranked up the interpolation feature in photoshop 7
from auto to 999.99 lines per inch and best quality
in addition to setting size to 4x2 and 200 ppi
seemed to do a better job of interpolation on a line images (aka ss).

Mar 20, 2011 9:02 AM in response to Jerrold Green1

Guess I am only allowed 1 helpful. Award a fake helpful here.

Not better results with a Grab 2x the size of the first. So on to other avenues of endeavor.

Preview was encouraging. Got the ss into the handle state, copied and in Preview open from clipboard.

Was able to save as various formats, could even set ppi to 200, must be interpolating (?), but did not have any choices like photoshop.

Am willing to bet printing and scanning is going to give best results

Will let you know

Mar 20, 2011 6:54 PM in response to Pat Schaefer

Pat Schaefer wrote:
...Was able to save as various formats, could even set ppi to 200, must be interpolating (?), but did not have any choices like photoshop.

Am willing to bet printing and scanning is going to give best results

When you copy in iWork apps (not screen capture, but Select and Copy) you will get vector graphics for all the content except other types of graphics you may have added. It scales without loss. Nothing can be done about a low res jpeg you add, etc., but for text and shapes from within the app, all will be smooth until you export to some non-vector format.

Jerry

Mar 21, 2011 11:17 AM in response to Pat Schaefer

I am not understanding the problem, it seems so simple.

A screen grab is probably the worst resolution you can get. It is acceptable for posting an image to this forum but it usually looks terrible when used for other things (documents, printouts, etc).

Get it into Preview as a PDF (Print and choose "Open as PDF in Preview" , Copy followed by "New from Clipboard", or whatever other method you want to use). In Preview, save it as a JPEG at 600 or 1200 PPI or whatever PPI you want. This will give you a very useful and very high resolution image. When saving as a jpg, remember to hit Tab after typing in the pixels per inch or it will not take the setting.

If that doesn't do what you want, I have no idea what you are trying to do.

Mar 21, 2011 3:42 PM in response to Pat Schaefer

Thanks to everyone for their attention and suggestions.

As they say , the proof is in the pudd err printing.

Not sure exactly what was the best way (via Preview, I think)
but I found that what was on the screen and what printed out were very different.

Maybe its an old photoshop (7) thing
but when I resized to 4"x 2.5" and
hit view print size
it looked unreadable and crappy
but .....
it printed fine.

My brain was wired into looking good on the screen and printing crappy
so I was surprised when I finally checked my work.
No matter what way I did it, they all looked ok
and much better than I was expecting.

Now if I can just convince my editor ....

Mar 27, 2011 4:53 PM in response to Pat Schaefer

Had not planned to add any more to this but it turned out well (for me)

raster recipe

1) set your spreadsheet up as you like on your 72 ppi device (screen)

My spreadsheet is 20x10 cells
it is 8" on the screen

2) determine what the resolution of where you want to go

400 ppi (printer)
(not really but this is how I figured it out)

3) multiply the screen size by 144 (see below for explantation)
then divide by target resolution
this is the size of the image at the target resolution

for my spreadsheet (8*144)/ 400 = 2.89"

4) decide if this is what you want

no I will double

5) get to where your spreadsheet is an object / image/ has handles
open inspector, metrics (ruler at an angle)
check "Constrain proportions" and enlarge image

I went to a 16" spreadsheet on my 72 ppi device screen
This gave me 16*144= 2304 pixels
which makes the image size 2304/400 = 5.76" at my target resolution.

5.5) this spreadsheet will look lousy
double font size (me 14 > 28), doubled image size
lose check boxes as they do not scale
(I replaced check with a 'Y" and left uncheck/false blank)

6) copy in Numbers
open in Preview as "New from clipboard"
save as jpg, at target ppi

7) to print you need photoshop or gimp?
something that allows you tell the printer the size of the image
otherwise
the printer tries to fill the page of the media (page size) selected
or fill xx% of the page

when a spreadsheet is an image in numbers
the copy command seems to target a 144 ppi resolution device (2*72?)
I found this by looking at some examples
copy a spreadsheet
open in Preview as "New from clipboard"
this will be a pdf, save as an image
go to Tools Adjust size
this will give you width height and resolution.
144 seems to be the ticket.

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Turn spreadsheet into image

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.