wfopen and import in Eviews 10

For questions regarding programming in the EViews programming language.

Moderators: EViews Gareth, EViews Jason, EViews Moderator, EViews Matt

DumplingPeng
Posts: 1
Joined: Fri Jun 15, 2018 10:59 pm

wfopen and import in Eviews 10

Postby DumplingPeng » Sat Jun 16, 2018 6:22 am

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.
Attachments
Chil_Rename.xlsx
(55.44 KiB) Downloaded 227 times
Chil.xlsx
(59.22 KiB) Downloaded 234 times

Return to “Programming”

Who is online

Users browsing this forum: No registered users and 13 guests