| T O P I C R E V I E W |
| Ju1s |
Posted - 10/14/2014 : 08:24:00 AM
Origin Ver. and Service Release (Select Help-->About Origin): 9.1
Operating System: Windows 7
Hi,
how can I extract variables when I import excel files? I want to extract the filename as variable and put it into the comment line of my worksheet.
Cheers,
Julius |
| 1 L A T E S T R E P L I E S (Newest First) |
| greg |
Posted - 10/14/2014 : 12:22:05 PM
Excel Import does not have the same Variable Extraction features of ASCII Import, however all imports record File Date, File Name and File Path.
Run this script after import to put the file name into the Comments row of Column "A":
col(A)[C]$ = page.info.system.import.filename$;
|
|
|
