Skip to main content
100%

Add signature image to PDF

✓ Published0🌍 Public
TTomStanczyk
Last edited Jun 21, 2020
Created on Jun 21, 2020

This example shows a PowerShell script that converts Excel workbooks to PDF files and inserts a signature image into each one. It processes every .xls and .xlsx file in a specified folder, opening the first worksheet of each workbook. Using the Excel COM object, it places the signature PNG into cell D10 via the `Shapes.AddPicture` method, then exports the workbook as a PDF using `ExportAsFixedFormat`. The script relies on the Microsoft Office Interop Excel API and iterates through files with `Get-ChildItem`.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist ea8710410afc9bb88a65f846e46d04da

This example demonstrates how to automate opening a Google Sheets tab in Chrome at user logon and session unlock, using a PowerShell script to register a Windows scheduled task. The task triggers on logon and session unlock events, launching Chrome with an app-mode URL pointing directly to the spreadsheet. The code constructs an XML task definition with the `Register-ScheduledTask` cmdlet, embedding the Chrome executable path and the spreadsheet URL as arguments. It highlights the use of PowerShell’s scheduled task API and XML trigger configuration, showing a practical workflow automation for persistent access to a specific data source without manual intervention.

HHerbCaudill
48% match
Loading thumbnail…

Gist f5904c4a8279840f341742d30c5d9a9e

This example demonstrates a PowerShell script that processes a text file by replacing caret characters with semicolons and writes the result to a new file. It shows a batch text-transformation workflow using the `Get-Content` cmdlet to read input in chunks of 1000 lines, a custom filter function `replace-chars` that applies the `-replace` operator, and `Add-Content` to append the processed lines to the output file. The script first checks if the output file exists and clears it to ensure a fresh write. The approach highlights pipeline-based file handling and character encoding preservation without additional libraries.

HHugoberry
47% match
Loading thumbnail…

Zip all files in folder older than date

This example demonstrates a PowerShell script that archives files and folders older than a specified date by month. It processes items in an input directory matching a file mask, copying those created before the first day of the given month and year into monthly subdirectories, then compressing each into a separate ZIP archive. The script uses the `Get-ChildItem` cmdlet with the `-Include` parameter, `Copy-Item` with `-Recurse`, and the `Compress-Archive` cmdlet, writing progress to the console via `Write-Host`.

TTomStanczyk
47% match
Loading thumbnail…

Excel Macro for exporting all sheets as csv

This example presents a VBA macro that exports every worksheet in an Excel workbook to a separate CSV file. It iterates through each sheet using a `For Each` loop over `Application.ActiveWorkbook.Worksheets`. For each sheet, it copies the sheet to a new workbook and saves it with the sheet’s name using the `SaveAs` method with `FileFormat:=xlCSV`. The macro then closes the temporary workbook, leaving the original file untouched.

LLeeMendelowitz
47% match
Loading thumbnail…

Gist b9433f6b51b1a8df2251968500ea421e

This example provides a PowerShell script that adds Windows Terminal shortcuts to the Win+X context menu. It shows how to create both an administrator and a normal shortcut in the Group3 folder, using the WScript.Shell COM object to set display names and manually modifying shortcut file bytes to enable the "Run as administrator" flag. The script downloads a pre-hashed .lnk file that references Windows Terminal by its ApplicationId, ensuring compatibility across installations, and includes an optional variant to replace Command Prompt entries.

Aanemochore
46% match
Loading thumbnail…

Convert powerpoint slides to images in VBA

This example shows how to batch-convert every slide in a PowerPoint presentation into JPEG images. The VBA macro iterates through all slides in the active presentation, exporting each one with a fixed output size of 2667 by 1500 pixels. The code uses the `Slide.Export` method, which is part of the PowerPoint object model, and references the `ActivePresentation` object. The filenames include a zero-padded slide index to preserve order. The macro relies on the built-in VBA `For Each` loop and the `Format` function to generate sequential names, with the output directory hardcoded as "Z:\". This approach automates slide-to-image conversion without manual screen captures.

CChristosT
46% match
Loading thumbnail…

Adds GitExtensions support to the git bash

This example demonstrates a PowerShell script that configures the Git Bash environment to integrate with GitExtensions. The script first detects the operating system architecture using `Get-WMIObject` to determine the appropriate Git installation path, then modifies the system `PATH` variable by appending the Git directory. It subsequently creates a `git-ex` file in the Git `bin` folder, writing a shell script content that launches `GitExtensions.exe` with any passed arguments. The code uses PowerShell's `Write-Host` for user feedback and `Test-Path` and `New-Item` for file operations.

RRestuta
45% match
Loading thumbnail…

List Azure File Shared Storage using the REST API and Powershell

This example demonstrates how to list Azure File Shared Storage contents using the REST API and PowerShell. It constructs a signed request by building a canonicalized signature string with the account key and HMAC-SHA256 encryption, then sends a GET request through `Invoke-RestMethod`. The code explicitly sets required headers such as `x-ms-date`, `x-ms-version`, and `Authorization`, and outputs the signature for inspection. The script uses PowerShell’s `System.Security.Cryptography.HMACSHA256` and `System.Uri` classes to compute authentication and parse the endpoint.

HHugoberry
44% match