Dynamic data import / export

datenbank

simply more productive
Up to 10,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: Does FlowHeater Read Excel based on Cell ID?

Does FlowHeater Read Excel based on Cell ID? 2 years 10 months ago #2310

  • chang thai tang
  • chang thai tang's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • 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
Attachments:

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

Does FlowHeater Read Excel based on Cell ID? 2 years 10 months ago #2311

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 243
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.

Attachments:

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.

Does FlowHeater Read Excel based on Cell ID? 2 years 10 months ago #2312

  • chang thai tang
  • chang thai tang's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • 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.

Does FlowHeater Read Excel based on Cell ID? 2 years 10 months ago #2313

  • chang thai tang
  • chang thai tang's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • 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
Attachments:

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

Does FlowHeater Read Excel based on Cell ID? 2 years 10 months ago #2314

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 243
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?

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.

Does FlowHeater Read Excel based on Cell ID? 2 years 10 months ago #2319

  • chang thai tang
  • chang thai tang's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • 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.

Does FlowHeater Read Excel based on Cell ID? 2 years 10 months ago #2320

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 243
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?

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.143 seconds