Page 1 of 1
Import unstructured data from excel
Posted: Tue May 03, 2016 4:17 am
by dan.solverud@gov.se
If I try to import unstructured data from an excel sheet via the wfopen-command, I have to open the excel file before I execute the command. If I run the command without first opening the excel file EViews will create a structured workfile page. What is the reason for this? Is there a way around this problem? My colleges have suggested I should use a combination of the wfcreate- and import-commands instead, but for various reason I would prefer to use the wfopen-command if possible (I can always open the excel file through a Shell- command before I run the wfopen-command)?
/Dan
Re: Import unstructured data from excel
Posted: Tue May 03, 2016 6:14 am
by EViews Gareth
That sounds a little odd. Could you give a precise example?
Re: Import unstructured data from excel
Posted: Tue May 03, 2016 8:11 am
by dan.solverud@gov.se
I have reach the conclusion that the problem probably is not that EViews interpret the file as containing structured data, but rather that it does not interpret or import the data at all, if I do not have the excel file opened in advance. I am not sure of what kind of example I should provide you with. This is the code I use to import the excel data.
wfopen(type="excelxml", wf=temp, page=unstr) %excelfile range=%WorkSheetName
Re: Import unstructured data from excel
Posted: Tue May 03, 2016 8:15 am
by EViews Gareth
Could you provide the Excel file?