- Posts: 27
Excel Adapter Write Side: Excel formulas & reference
- Gennaro
- Topic Author
- Offline
- User
Less
More
14 years 1 month ago #2048
by Gennaro
Excel Adapter Write Side: Excel formulas & reference was created by Gennaro
It wuold be great to put excel formulas with reference to cells which are able to change in relation to the active row.
i.e. Guessing I have to put the formula "LENGTH(B2)" in the cell C2 of the writing Excel File, if I have more than a row to write, the program should change automatically the formula to "LENGTH(B3)" in C3, "LENGTH(B4)" in C4,etc.. for each written row.
regards
i.e. Guessing I have to put the formula "LENGTH(B2)" in the cell C2 of the writing Excel File, if I have more than a row to write, the program should change automatically the formula to "LENGTH(B3)" in C3, "LENGTH(B4)" in C4,etc.. for each written row.
regards
Please Log in or Create an account to join the conversation.
- FlowHeater-Team
- Offline
- Admin
14 years 1 month ago #2050
by FlowHeater-Team
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.
Replied by FlowHeater-Team on topic Re:Excel Adapter Write Side: Excel formulas & reference
Thanks for suggestion. But you just have to build the formula by yourself with the FlowHeater string functions.
For example:
Note: You have to use the excel formula names in the language of your excel installation!
For example:
- Use the X-Value Heater with the value =Length(A or another offset B, C, …
- Use the AutoID Heater with the row offset you want to start. If you expect more than 999 rows you have to use the string Format Heater to eliminate the group separators? E.g. =Length(A1.000)!
- Use another X-Value Heater with the value )
- Use the string Append Heater to append these Heaters (values) to the excel formula =Length(A1) …
- Connect the output from the Append Heater to the Excel Field you want the formula
Note: You have to use the excel formula names in the language of your excel installation!
Attachment excel_formula.zip not found
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 or Create an account to join the conversation.
Time to create page: 0.255 seconds