FlowHeater Logo

FlowHeater Support Forum

simply more productive

Download the freeware version (10 Mb)

Up to 100,000 records can be processed with the freeware version!

Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: X-value doesn't copy to excel file

X-value doesn't copy to excel file 1 year 10 months ago #2726

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:

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

X-value doesn't copy to excel file 1 year 10 months ago #2727

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.

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.

X-value doesn't copy to excel file 1 year 10 months ago #2728

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)]

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

  • Page:
  • 1
Time to create page: 0.145 seconds