Import unstructured data from excel

[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

[EViews Gareth]

That sounds a little odd. Could you give a precise example?

[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

[EViews Gareth]

Could you provide the Excel file?