wfsave(type=excelxml) internationalization bugs

For notifying us of what you believe are bugs or errors in EViews.
Please ensure your copy of EViews is up-to-date before posting.

Moderators: EViews Gareth, EViews Moderator

paues
Posts: 215
Joined: Fri Apr 15, 2011 7:16 am
Location: Stockholm, Sweden

wfsave(type=excelxml) internationalization bugs

Postby paues » Sat Apr 06, 2013 5:21 am

I believe I have found two bugs associated with internationalization in the wfsave(type=excelxml) command in EViews 8 (Mar 28 2013 build).

1. New Excel files are created with English default sheet names (Sheet1, Sheet2 and Sheet3) and not the local language (Swedish: Blad1, Blad2 and Blad3).

2. When I use the Swedish default names when exporting to a new Excel file the data wind up in Sheet1 for the range of sheets Blad1 to Blad8:

Code: Select all

pagesave(t=excelxml) "k:\stab\test.xlsx" range="Blad1!A1" pagesave(t=excelxml) "k:\stab\test.xlsx" range="Blad2!A1" 'In Sheet1 pagesave(t=excelxml) "k:\stab\test.xlsx" range="Blad3!A1" 'In Sheet1 ... pagesave(t=excelxml) "k:\stab\test.xlsx" range="Blad8!A1" 'In Sheet1 pagesave(t=excelxml) "k:\stab\test.xlsx" range="Blad9!A1" 'In Blad9

EViews Jason
EViews Developer
Posts: 870
Joined: Tue Sep 16, 2008 3:50 pm

Re: wfsave(type=excelxml) internationalization bugs

Postby EViews Jason » Wed Apr 10, 2013 11:40 am

1. Navigate on your computer to where EViews is installed (normally c:\program files\eviews8)
Rename xlsx_template.xlsx to xlsx_template_orig.xlsx
Download the following file:http://eviewsdropbox.s3.amazonaws.com/x ... _swed.xlsx
Copy the downloaded file to c:\program files\eviews8
Rename xlsx_template_swed.xlsx to xlsx_template.xlsx

This will default the sheet names to Blad1, Blad2, and Blad3. Until we develop a more dynamic solution, a new xlsx_template.xlsx file will need to be created for each foreign language.

2.The steps performed in #1 above, will fix the first 3 pages and hopefully the proceeding pages as well. Let me know what you find.


Return to “Bug Reports”

Who is online

Users browsing this forum: No registered users and 2 guests