wfsave(type=excelxml) internationalization bugs
Posted: 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:
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