Hi,
I am using Eviews 10.
I tried to imprt/wfopen excel files formatted as xlsx as attached.
The code I used as following
***************
%dir1="D:\100.SC_CombineAllMkt\1.900A\1.PreliminaryFilter"
%type=".xlsx"
for %cn %fn Chil 226
wfopen {%dir1}\{%cn}{%type}
next
**************
I obtained some message like "table does not exist ....." while I run code above.
I can not successfully wfopen/import the excel files until
i) I execute code above in Eviews 9
or ii) I rename the worksheet name from "工作表1" to "Chil", some English name
Could anyone kindly take a look for me? I have no idea what happened. I need to open/import over 500 files formatted in xlsx. I don't really want to manually rename worksheet for those 500+ files... So...any comments are welcome. Thank you very much in advanced.
Plus, I have installed the updates of 20180604 for Eviews 10.
wfopen and import in Eviews 10
Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt
-
- Posts: 1
- Joined: Fri Jun 15, 2018 10:59 pm
wfopen and import in Eviews 10
- Attachments
-
- Chil_Rename.xlsx
- (55.44 KiB) Downloaded 232 times
-
- Chil.xlsx
- (59.22 KiB) Downloaded 239 times
Who is online
Users browsing this forum: No registered users and 65 guests