See also the existing examples of using the
Excel Adapter
, which may answer your question:
CSV export with grouping
Advanced Spreadsheet Processing
- FlowHeater-Team
-
Topic Author
- Offline
- Administrator
-
- FlowHeater-Team
-
Topic Author
- Offline
- Administrator
-
2 years 8 months ago #3569
by FlowHeater-Team
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Replied by FlowHeater-Team on topic Advanced Spreadsheet Processing
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
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
Code:
# 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)
Best wishes
Robert Stark
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Please Log in or Create an account to join the conversation.
Time to create page: 0.297 seconds
