Write a filename in the excel writer using Expando fields (2 replies)
Screenshot please.
After further research, I expressed the filename as "DONE_" & %ExportFilename & ".xlsx" . I also ticked Evaluate Filename. This resolved the issue.
Screenshot please.
After further research, I expressed the filename as "DONE_" & %ExportFilename & ".xlsx" . I also ticked Evaluate Filename. This resolved the issue.
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.
Looking to purchase IMan, please see our resellers here.
Realisable Software
Ph: +44 (0) 208 123 1017
Copyright © Realisable. All rights reserved.
Realisable is a registered trademark
I am reading a csv file, for example, test.csv . I need to write the contents of the file to an excel spreadsheet using the excel writer where the filename needs to be of the format DONE_.xlsx . I have tried DONE_%[Record.ExportFilename] with the evaluate filename ticked but I just get the error
even though ExportFilename is a valid field.
Please can you advise me how to resolve this.