High res screenshot of Excel workbook

SideWinder · 12 Oct 2018 at 10:45

Hi,

I need to take screenshots of a workbook (Excel 2016) and turn it into a high res video. The zoom is set to 110% on the workbook. There are 200+ screenshots to take as it is showing graphs/progress throughout weeks 27 to 52.

Googled but there doesn't seem to be a high enough resolution...i have tried print screen and pasting into Paint but if i zoom in a bit, it goes blurry.

I am reluctant to use the snipping tool as it will be different sizes each time?

Also tried to use the screenshot function on Excel to turn it into a Bitmap but this also doesn't come up clear enough.

It is being pasted into Photoshop currently but ideas welcome...!

Thanks

Jonnybmac · 12 Oct 2018 at 11:07

Screen grabs work on the resolution of your screen

Have you tried searching excel macros? Amazing what some people can code in macros

Edit

Quick search brought this up. Not sure if you could splice something from it to save photos faster

https://stackoverflow.com/questions...save-screenshot-of-specific-area-in-same-file

james.miller · 12 Oct 2018 at 11:27

You can create images from ranges if that's any good to you

https://stackoverflow.com/questions/43646682/export-range-as-image

jpaul · 12 Oct 2018 at 11:58

You might try PDF printing too, too larger paper sizes to ensure high enough resolution (I use older non-bloatware pdfcreator);

cleartype fonts maybe messing up your screen grabs too

DaleTheWhale · 16 Oct 2018 at 11:58

Greenshot is good for taking multiple screenshots easily (shift+PrtScr) will repeat the last area.

Could try taking them at 4K res if you can upscale/have a 4k screen.

SideWinder · 17 Oct 2018 at 20:31

Cheers guys (sorry for the late reply!)

Going to try Greenshot i think. We did try PDFs but its complex to turn them into a video it seems!

nade · 18 Oct 2018 at 10:27

I use Gadwin Printscreen for doing random screenshots, it's got some good features and shortcuts. Don't think it's got any automated feature but might be worth a look.

smogsy · 18 Oct 2018 at 11:05

i did something similar at work but in our case it was 32,000 images I ended up coding a program in C# to automatically take screenshots of an entire area then convert images into to video at your selected FPS. whilst being multi core aware. tested it up to 28 cores

seem like it could have been handy here... may have to rewrite it for general public use?

Sasahara · 19 Oct 2018 at 12:17

I would have saved as a PDF and them open in photoshop to convert in to the res & image format of your choose.