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: X-value doesn't copy to excel file

X-value doesn't copy to excel file 6 months 5 days ago #2726

  • David
  • David's Avatar
  • Offline
  • New Member
  • Posts: 2
I have created X-values to add formulas to my excel file. However, when I execute the definition a blank value is passed to the excel file and not the X-value. How do I correct this? I am unable to get any value to pass to my excel file using X-values.
Attachments:
The administrator has disabled public write access.

X-value doesn't copy to excel file 6 months 4 days ago #2727

  • FlowHeater-Team
  • FlowHeater-Team's Avatar
  • Offline
  • Administrator
  • Posts: 240
Hi David,

I guess this issue is related to wrong data type setting for the Excel field “Balance due”. Please check whether the FlowHeater data type is set to “String” for this field.

Did you receive warnings about? Usually you should receive warnings because wrong conversions!

In case this does not solve the issue please post your FlowHeater Definition file for more analytics.
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.

X-value doesn't copy to excel file 6 months 4 days ago #2728

  • David
  • David's Avatar
  • Offline
  • New Member
  • Posts: 2
Thanks Robert

Setting the data type to string solved the problem.

I reviewed the posting #2050 for passing formulas to excel. A much easier way is to set the range in excel as a table and pass formulas that reference the table names in the formula. Such as [=IF(AND([@LastUpdated]-[@DueDate]>30,[@LastUpdated]-[@DueDate]<=60),[@Balance],0)]
The administrator has disabled public write access.
Moderators: FlowHeater-Team
Time to create page: 0.073 seconds