TOPIC: Does FlowHeater Read Excel based on Cell ID?

I am having a problem here. Using the sample file provided by FlowHeater, even though my definition ignore OrderNumber (Cell A in Excel spreadsheet), after executing the file I always received the OrderNumber (1000010) which I did not include in my definition. I would appreciate if anyone you have had similar experience and guide me in doing it correctly. thx

The Excel Adapter reads first the range you defined in Excel Configurator. In your case you have to use the Excel Column “B” instead of “A”. Afterwards from this range the column index is used to address the needed columns. Hope this helps.

I could avoid Column A, but how about Column F (DeliveryDate)? Based on the Configurator can I key in B,C,D,E,G? In this way the exact columns would be specified, but I tried it and it does not work this way. Any suggestion? thanks

Hi,
I am doing a little testing using the same Excel spreadsheet. If I take away the OrderType, when I press the Read button,it will show NoColumnName (pls see output1.png); if i remove OrderNumber (Column A) and i do a Read, it will assume the first row does not exist and go to read second row (output2.png). I hope I had provided information for you to have a good idea what I am trying to achieve here

Sorry, I’m just a bit confused. For me it´s not clear what you want to do? Could you please post your used definition files including your modified example excel files?

Robert,
It is the same definition file I sent earlier. May be the other way to ask the question is: Under what condition NoColumnName will flag out? Why Flowheater read the second row for field information when Column A has no data?

Flowheater is a nice piece of software. Unfortunately my data is constructed in that way, I would need Flowheater to read Excel spreadsheet in the way I want it and not from Column A .. Z

Hi Chang Thai,

You have to define the range from B-G. In this way NoColumnName will disappear.

FlowHeater needs to read always a specific range. In case your first column sometimes doesn’t contain data you need to define the end column too. With this you deactivate the automatic column detection. Perhaps this was the confusion?