PDF To CSV By Pages - Powershell
PDF Extractor SDK sample in Powershell demonstrating ‘PDF To CSV By Pages’
PDFToCSVByPages.bat
@echo off
if "%~1"=="" (
echo -----------------------------------------------------
echo Invalid parameter!
echo -----------------------------------------------------
echo Usage: PDFToCSVByPages.bat file_name
echo Example: PDFToCSVByPages.bat "sample3.pdf"
echo -----------------------------------------------------
if not "%NOPAUSE%"=="1" pause
exit /b 1
)
powershell -NoProfile -ExecutionPolicy Bypass -Command "& .\PDFToCSVByPages.ps1" "%1"
echo Script finished with errorlevel=%errorlevel%
pause
PDFToCSVByPages.ps1
#*******************************************************************************************#
# #
# Download Free Evaluation Version From: https://bytescout.com/download/web-installer #
# #
# Also available as Web API! Get Your Free API Key: https://app.pdf.co/signup #
# #
# Copyright © 2017-2020 ByteScout, Inc. All rights reserved. #
# https://www.bytescout.com #
# https://pdf.co #
# #
#*******************************************************************************************#
Param (
[Parameter(Mandatory = $true)]
[string] $InputFileName = ""
)
#Add reference to Bytescout.PDFExtractor.dll assembly
Add-Type -Path "C:\Program Files\Bytescout PDF Extractor SDK\net4.00\Bytescout.PDFExtractor.dll"
# Check input file exists
if ((Test-Path $InputFileName) -eq $false) {
Write-Host "Input file does not exist." -ForegroundColor Red
Exit 0
}
# Create and activate Bytescout.PDFExtractor.CSVExtractor instance
$Extractor = New-Object Bytescout.PDFExtractor.CSVExtractor
$Extractor.RegistrationName = "demo"
$Extractor.RegistrationKey = "demo"
# you can change CSV separator symbol (if needed) from "," symbol to another if needed for non-US locales
# $Extractor.CSVSeparatorSymbol = ","
try {
# Load sample PDF document
$Extractor.LoadDocumentFromFile($InputFileName)
# Get page count
$PageCount = $Extractor.GetPageCount()
Write-Host "Pages: $PageCount"
for ($i = 0; $i -lt $PageCount; $i++) {
# Construct output file name
$OutputFileName = "page$i.csv"
# Write-Host $OutputFileName
# Save extracted CSV data
$Extractor.SavePageCSVToFile($i, $OutputFileName)
}
Write-Host "Data has been extracted to separate files for pages."
} catch {
Write-Host $_.Exception.Message
}
$Extractor.Dispose()