Skip to main content
simply more productive

The Data Specialist

Thanks to our intuitive transformation designer, you can convert data effortlessly to a variety of formats without knowing how to program. It’s not only efficient, it’s also easy to use.
Flowheater Download

Does FlowHeater Read Excel based on Cell ID?

  • chang thai tang
  • Topic Author
  • Offline
  • User
  • User
More
10 years 2 days ago #2310 by chang thai tang
Does FlowHeater Read Excel based on Cell ID? was created by chang thai tang
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 to join the conversation.

More
10 years 2 days ago #2311 by FlowHeater-Team
Replied by FlowHeater-Team on topic Does FlowHeater Read Excel based on Cell ID?
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.
Attachments:

Please Log in to join the conversation.

  • chang thai tang
  • Topic Author
  • Offline
  • User
  • User
More
10 years 2 days ago #2312 by chang thai tang
Replied by chang thai tang on topic Does FlowHeater Read Excel based on Cell ID?
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 to join the conversation.

  • chang thai tang
  • Topic Author
  • Offline
  • User
  • User
More
10 years 1 day ago #2313 by chang thai tang
Replied by chang thai tang on topic Does FlowHeater Read Excel based on Cell ID?
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 to join the conversation.

More
10 years 20 hours ago #2314 by FlowHeater-Team
Replied by FlowHeater-Team on topic Does FlowHeater Read Excel based on Cell ID?
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 to join the conversation.

  • chang thai tang
  • Topic Author
  • Offline
  • User
  • User
More
9 years 11 months ago #2319 by chang thai tang
Replied by chang thai tang on topic Does FlowHeater Read Excel based on Cell ID?
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 to join the conversation.

More
9 years 11 months ago #2320 by FlowHeater-Team
Replied by FlowHeater-Team on topic Does FlowHeater Read Excel based on Cell ID?
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 to join the conversation.

Time to create page: 0.315 seconds

FlowHeater - The Data Specialist

Efficient data integration and transformation with FlowHeater – the perfect solution for a seamless transfer of your data.

Rechtliches

Support & Contact

Kontaktinformation

Telefon:0951 / 99339792 E-Mail:This email address is being protected from spambots. You need JavaScript enabled to view it.

Copyright © 2009-2024 by FlowHeater GmbH. All rights reserved.