-
chang thai tang
-
Topic Author
-
Offline
-
Posts: 5
-
-
|
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
|
Please Log in or Create an account to join the conversation.
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
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.
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.
|
-
chang thai tang
-
Topic Author
-
Offline
-
Posts: 5
-
-
|
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
|
Please Log in or Create an account to join the conversation.
|
-
chang thai tang
-
Topic Author
-
Offline
-
Posts: 5
-
-
|
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
|
Please Log in or Create an account to join the conversation.
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
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?
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.
|
-
chang thai tang
-
Topic Author
-
Offline
-
Posts: 5
-
-
|
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
|
Please Log in or Create an account to join the conversation.
|
-
FlowHeater-Team
-
-
Offline
-
Posts: 391
-
-
-
-
|
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?
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.130 seconds