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.

TOPIC: Does FlowHeater Read Excel based on Cell ID?

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

  • chang thai tang
  • chang thai tang's Avatar
  • Offline
  • 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:
The administrator has disabled public write access.

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

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 239
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.
The administrator has disabled public write access.

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

  • chang thai tang
  • chang thai tang's Avatar
  • Offline
  • 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
The administrator has disabled public write access.

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

  • chang thai tang
  • chang thai tang's Avatar
  • Offline
  • 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:
The administrator has disabled public write access.

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

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 239
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.
The administrator has disabled public write access.

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

  • chang thai tang
  • chang thai tang's Avatar
  • Offline
  • 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
The administrator has disabled public write access.

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

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 239
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.
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.084 seconds