Page 1 of 1

wfsave(type=excelxml) internationalization bugs

Posted: Sat Apr 06, 2013 5:21 am
by paues
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

Re: wfsave(type=excelxml) internationalization bugs

Posted: Wed Apr 10, 2013 11:40 am
by EViews Jason
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.