Hi All...
I have the requirement to load an Excel spread sheet that contains multiple languages. I've tried al sorts of things
like using
load file action scripts
Alpha ADO using excel as the data source
converting the file to XML and reading it as a file
nothing seems to preserve the special characters.
I've added a little sample for you guru's to have a play with... couldn't seem to be able to attach it so I've just added the xml version... It does load into Excel
thanks
garth
<lanaguages encoding="UTF-8">
<language>
<name>Modern Greek</name>
<sample>Καλώς Ορίσατε</sample>
</language>
<language>
<name>Chinese - Cantonese</name>
<sample>歡迎</sample>
</language>
<language>
<name>Chinese - Mandarin</name>
<sample>歡迎光臨</sample>
</language>
<language>
<name>Bengali</name>
<sample>স্বাগতম</sample>
</language>
<language>
<name>Arabic</name>
<sample>أهلاً و سهلاً</sample>
</language>
<language>
<name>Georgian</name>
<sample>კეთილი იყოს თქვენი</sample>
</language>
<language>
<name>Gujarati</name>
<sample>પધારો</sample>
</language>
<language>
<name>Lao</name>
<sample>ຍິນດີຕ້ອນຮັບ</sample>
</language>
<language>
<name>Persian - Farsi</name>
<sample> خوش آمدید</sample>
</language>
<language>
<name>Limburgish</name>
<sample>Wilk?m</sample>
</language>
<language>
<name>Korean</name>
<sample>환영합니다</sample>
</language>
<language>
<name>Japanese</name>
<sample>ようこそ</sample>
</language>
<language>
<name>Russian</name>
<sample>Добро пожаловать!</sample>
</language>
<language>
<name>Czech</name>
<sample>V?t?me tĕ</sample>
</language>
<language>
<name>Polish</name>
<sample>Witam Cię</sample>
</language>
</lanaguages>
I have the requirement to load an Excel spread sheet that contains multiple languages. I've tried al sorts of things
like using
load file action scripts
Alpha ADO using excel as the data source
converting the file to XML and reading it as a file
nothing seems to preserve the special characters.
I've added a little sample for you guru's to have a play with... couldn't seem to be able to attach it so I've just added the xml version... It does load into Excel
thanks
garth
<lanaguages encoding="UTF-8">
<language>
<name>Modern Greek</name>
<sample>Καλώς Ορίσατε</sample>
</language>
<language>
<name>Chinese - Cantonese</name>
<sample>歡迎</sample>
</language>
<language>
<name>Chinese - Mandarin</name>
<sample>歡迎光臨</sample>
</language>
<language>
<name>Bengali</name>
<sample>স্বাগতম</sample>
</language>
<language>
<name>Arabic</name>
<sample>أهلاً و سهلاً</sample>
</language>
<language>
<name>Georgian</name>
<sample>კეთილი იყოს თქვენი</sample>
</language>
<language>
<name>Gujarati</name>
<sample>પધારો</sample>
</language>
<language>
<name>Lao</name>
<sample>ຍິນດີຕ້ອນຮັບ</sample>
</language>
<language>
<name>Persian - Farsi</name>
<sample> خوش آمدید</sample>
</language>
<language>
<name>Limburgish</name>
<sample>Wilk?m</sample>
</language>
<language>
<name>Korean</name>
<sample>환영합니다</sample>
</language>
<language>
<name>Japanese</name>
<sample>ようこそ</sample>
</language>
<language>
<name>Russian</name>
<sample>Добро пожаловать!</sample>
</language>
<language>
<name>Czech</name>
<sample>V?t?me tĕ</sample>
</language>
<language>
<name>Polish</name>
<sample>Witam Cię</sample>
</language>
</lanaguages>
Comment