Capturing your screen on Windows PC is an easy affair, but when it comes down to taking screenshots of a spreadsheet in Microsoft Excel, we would not recommend using anything else apart from Excel ...
This Python script takes all excel files (xlsx files) in folder in, adds picture to defined cell and export it as pdf file to folder out. I use this script for automatic signature of attendace sheets.