To get a non-Latin alphabet string from a spreadsheet, and
display the string correctly in the browser from a server
running a language different from the language of the client's HTML page,
you must:
- Set the ExcelWriter script's charset property to the string language's
charset.
- Use the
UnicodeToAnsi method to convert the string to
an Ansi encoded string that can be displayed correctly to the user.
UnicodeToAnsi takes a Unicode string and the string language's
code page and returns an Ansi string:
AnsiString = UnicodeToAnsi(UnicodeString, CodePage)
To correctly display strings in only one language, uses a specific language code page.
To correctly display strings in any language, use
code page 65001. For a complete list of charset and code page values see,
Character Set Recognition
.
