Hello Keith,
Currently the
Excel Adapter
doesn´t know about who many Sheets are present in the current Excel Workbook.
But with a simple PowerShell script you can perform this. The script like below runs in a loop as long the
Batch Module
returns with success (EXITCODE = 0). For each call a
FlowHeater Parameter
“SHEET” will be set with the current value of the script variable $sheet. This will be increment by 1 before calling the Batch Module into the loop. In the
Excel Adapter
on the READ side you have just to use this
FlowHeater Parameter
as the Worksheet name, see screenshot below. In case the
Excel Adapter
doesn´t found a Worksheet name like “1”, “2”, the
Excel Adapter
will try to get the first Sheet (=1), Second Sheet (=2) and so on.
Please find attached a short example.
PowerShell script for advanced Excel Spreadsheet processing# FlowHeater Advanced Excel Spreadsheet processing
[string]$FHBATCH = "C:\Program Files\FlowHeater V4\BIN\FHBatch.exe"
[int]$sheet = 0
do {
$sheet = $sheet + 1
# Execute the FlowHeater Defintion with the dynamic sheet parameter
& $FHBATCH /ReadFileName input.xlsx /SetParameter SHEET=$sheet advanced-excel-processing.fhd | Out-Null
} while ($LASTEXITCODE -eq 0)