PDF.co Web API - PDF To Excel API - PowerShell - Convert PDF To XLS From URL - ByteScout

PDF.co Web API – PDF To Excel API – PowerShell – Convert PDF To XLS From URL

  • Home
  • /
  • Articles
  • /
  • PDF.co Web API – PDF To Excel API – PowerShell – Convert PDF To XLS From URL

PDF.co Web API – PDF To Excel API – PowerShell – Convert PDF To XLS From URL

ConvertPdfToXlsFromUrl.ps1

[powershell]
# The authentication key (API Key).
# Get your own by registering at https://app.pdf.co/documentation/api
$API_KEY = “***********************************”

# Direct URL of source PDF file.
$SourceFileUrl = “https://s3-us-west-2.amazonaws.com/bytescout-com/files/demo-files/cloud-api/pdf-to-excel/sample.pdf”
# Comma-separated list of page indices (or ranges) to process. Leave empty for all pages. Example: ‘0,2-5,7-‘.
$Pages = “”
# PDF document password. Leave empty for unprotected documents.
$Password = “”
# Destination XLS file name
$DestinationFile = “.\result.xls”

# Prepare URL for `PDF To XLS` API call
$query = “https://api.pdf.co/v1/pdf/convert/to/xls?name={0}&password={1}&pages={2}&url={3}” -f `
$(Split-Path $DestinationFile -Leaf), $Password, $Pages, $SourceFileUrl
$query = [System.Uri]::EscapeUriString($query)

try {
# Execute request
$jsonResponse = Invoke-RestMethod -Method Get -Headers @{ “x-api-key” = $API_KEY } -Uri $query

if ($jsonResponse.error -eq $false) {
# Get URL of generated XLS file
$resultFileUrl = $jsonResponse.url;

# Download XLS file
Invoke-WebRequest -Headers @{ “x-api-key” = $API_KEY } -OutFile $DestinationFile -Uri $resultFileUrl

Write-Host “Generated XLS file saved as `”$($DestinationFile)`” file.”
}
else {
# Display service reported error
Write-Host $jsonResponse.message
}
}
catch {
# Display request error
Write-Host $_.Exception
}

[/powershell]

run.bat

[text]
@echo off

powershell -NoProfile -ExecutionPolicy Bypass -Command “& .\ConvertPdfToXlsFromUrl.ps1”
echo Script finished with errorlevel=%errorlevel%

pause
[/text]


  Click here to get your Free Trial version of the SDK

Tutorials:

prev
next