Dynamic data import / export


simply more productive
Up to 100,000 records can be processed with the freeware version!
Welcome, Guest
Username: Password: Remember me
Welcome to the FlowHeater support forum.

Questions about using FlowHeater are answered here.
  • Page:
  • 1

TOPIC: Process all excel worksheets

Process all excel worksheets 4 years 1 month ago #2289

  • Heinz
  • Heinz's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 13
Hi there,

How do I go about processing more than 1 worksheet in an Excel adaptor?
I set up the processing rules for 1 worksheet, but would like to specify how to process the other sheets in the same file.

So lets say I have sheet A,B,C,D,E,F - sheets B,C and E contain data that I want to process in a similair way, I could use the value of worksheet to add some logic where required, but I would still need the process to cycle through all the sheets.

Or should I open the file multiple times?

Please Log in or Create an account to join the conversation.

Process all excel worksheets 4 years 1 month ago #2290

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 274
Hi Heinz,

Currently FlowHeater doesn’t supports processing more than one Excel sheets at once, but this is a nice feature and I will integrate this function in a further version.

To make this work a bit easier you could use FlowHeater Parameters . For example go to the menu option "Edit->Parameters" and create a new Parameter "SHEET". For testing in the Designer you should also define a default value. This parameter you can use in the Excel READ Adapter for the Excel Worksheet name. Here you have to use $SHEET$.

Now you can use the FlowHeater Batch Module to export more Excel sheet at once by using the following CMD script.
@echo off
REM adapt the following to the actual path of FHBatch.exe
set FHBATCH="C:\Program Files (x86)\FlowHeater V3\BIN\FHBatch.exe"

REM Export Excel Sheet B
%FHBATCH% /SetParameter SHEET=B export-excel-sheet-with-parameter.fhd

REM Export Excel Sheet C
%FHBATCH% /SetParameter SHEET=C export-excel-sheet-with-parameter.fhd

REM Export Excel Sheet E
%FHBATCH% /SetParameter SHEET=E export-excel-sheet-with-parameter.fhd

REM and so on...

Please Log in or Create an account to join the conversation.

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.
  • Page:
  • 1
Moderators: FlowHeater-Team
Time to create page: 0.089 seconds