LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dstacey

Hi,

Is there a way to allow me to specify the filename and path of the excel file of an excel file that I want to generate using a field record.

I'm looking for the equivalent of FileNameExpr that comes with the Excel Fiel acquisition node.

thanks,
Dave

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

No. That option does not exist at this time.

However.. you can write the Excel sheet out with a name such as "temp.xls" and then use a Filter node to rename it:

moveFile("temp.xls","myproperlynamedfile.xls")

This method allows you to add dates/times and other such information to the filename:

moveFile("temp.xls","mydata_"+str(date())+".xls")

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: dstacey

Thanks, I'll use that approach instead!