ByteScout Cloud API Server – PDF To Excel API – PowerShell – Convert PDF To XLSX From URL Asynchronously

Home
/
Articles
/
ByteScout Cloud API Server – PDF To Excel API – PowerShell – Convert PDF To XLSX From URL Asynchronously

printable version:
ByteScout-Cloud-API-Server-PowerShell-Convert-PDF-To-XLSX-From-URL-Asynchronously.pdf

How to convert PDF to XLSX from URL asynchronously for PDF to excel API in PowerShell using ByteScout Cloud API Server

How to convert PDF to XLSX from URL asynchronously in PowerShell with easy ByteScout code samples to make PDF to excel API. Step-by-step tutorial

On this page, you will find sample source codes which show you how to handle a complex task, such as, PDF to excel API in PowerShell. ByteScout Cloud API Server was designed to assist PDF to excel API in PowerShell. ByteScout Cloud API Server is API server that is ready to use and can be installed and deployed in less than 30 minutes on your own Windows server or server in a cloud. It can save data and files on your local server-based file storage or in Amazon AWS S3 storage. Data is processed solely on the API server and is powered by ByteScout engine, no cloud services or Internet connection is required for data processing..

PowerShell code snippet like this for ByteScout Cloud API Server works best when you need to quickly implement PDF to excel API in your PowerShell application. Follow the tutorial and copy – paste code for PowerShell into your project’s code editor. Use of ByteScout Cloud API Server in PowerShell is also described in the documentation given along with the product.

Trial version of ByteScout is available for free download from our website. This and other source code samples for PowerShell and other programming languages are available.

On-demand (REST Web API) version:
Web API (on-demand version)

On-premise offline SDK for Windows:
60 Day Free Trial (on-premise)

ConvertPdfToXlsxFromUrlAsynchronously.ps1

      # Please NOTE: In this sample we're assuming Cloud Api Server is hosted at "https://localhost". 
# If it's not then please replace this with with your hosting url.

# Cloud API asynchronous "PDF To XLSX" job example.
# Allows to avoid timeout errors when processing huge or scanned PDF documents.

# Direct URL of source PDF file.
$SourceFileUrl = "https://bytescout-com.s3.amazonaws.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 XLSX file name
$DestinationFile = ".\result.xlsx"
# (!) Make asynchronous job
$Async = $true


# Prepare URL for `PDF To XLSX` API call
$query = "https://localhost/pdf/convert/to/xlsx?name={0}&password={1}&pages={2}&url={3}&async={4}" -f `
    $(Split-Path $DestinationFile -Leaf), $Password, $Pages, $SourceFileUrl, $Async
$query = [System.Uri]::EscapeUriString($query)

try {
    # Execute request
    $jsonResponse = Invoke-RestMethod -Method Get  -Uri $query

    if ($jsonResponse.error -eq $false) {
        # Asynchronous job ID
        $jobId = $jsonResponse.jobId
        # URL of generated XLSX file that will available after the job completion
        $resultFileUrl = $jsonResponse.url

        # Check the job status in a loop. 
        do {
            $statusCheckUrl = "https://localhost/job/check?jobid=" + $jobId
            $jsonStatus = Invoke-RestMethod -Method Get  -Uri $statusCheckUrl

            # Display timestamp and status (for demo purposes)
            Write-Host "$(Get-date): $($jsonStatus.status)"

            if ($jsonStatus.status -eq "success") {
                # Download XLSX file
                Invoke-WebRequest  -OutFile $DestinationFile -Uri $resultFileUrl
                Write-Host "Generated XLSX file saved as `"$($DestinationFile)`" file."
                break
            }
            elseif ($jsonStatus.status -eq "working") {
                # Pause for a few seconds
                Start-Sleep -Seconds 3
            }
            else {
                Write-Host $jsonStatus.status
                break
            }
        }
        while ($true)
    }
    else {
        # Display service reported error
        Write-Host $jsonResponse.message
    }
}
catch {
    # Display request error
    Write-Host $_.Exception
}

ON-PREMISE OFFLINE SDK

60 Day Free Trial or Visit ByteScout Cloud API Server Home Page

Explore ByteScout Cloud API Server Documentation

Explore Samples

Sign Up for ByteScout Cloud API Server Online Training

ON-DEMAND REST WEB API

Get Your API Key

Explore Web API Docs

Explore Web API Samples

run.bat

      @echo off

powershell -NoProfile -ExecutionPolicy Bypass -Command "& .\ConvertPdfToXlsxFromUrlAsynchronously.ps1"
echo Script finished with errorlevel=%errorlevel%

pause