FlowHeater - The Data Import / Export Specialist
See also the existing examples of using the Excel Adapter , which may answer your question: CSV export with grouping

X-value doesn't copy to excel file

More
6 years 8 months ago #2726 by David
X-value doesn't copy to excel file was created by David
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.

More
6 years 8 months ago #2727 by FlowHeater-Team
Replied by FlowHeater-Team on topic X-value doesn't copy to excel file
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.

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

More
6 years 8 months ago #2728 by David
Replied by David on topic X-value doesn't copy to excel file
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.

Time to create page: 0.260 seconds

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

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

Follow us on

twitter  facebook

YouTube

 de en