Advanced Spreadsheet Processing

I get excel spreadsheets with multiple tabs of the same data, there is more to the data dump that will fit in a single tab. The data format is the same, it is just a quantity issue.

Can FH be made to read across the tabs and combine multiple tabs (of Excel Spreadsheet) into a single output stream
automatically?

Regards,
Keith

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