Home

$inValANSI:="D"+Char(0x00E9)+"gnation"

  //create a blank book with n sheets
$numberOfSheets:=3
$wb:=XLS Create ($numberOfSheets)  //min=1, max=10

  //by default, the Unicode value is set
  //if you specify an encoding, the ANSI value is set
$success:=XLS Set text value ($wb;1;1;1;$inValANSI;"iso-8859-1")
$success:=XLS Set text value ($wb;1;1;2;$inValANSI)

  //the command will attempt to read the Unicode value.
  //if it fails (the cell is not Unicode),
  //it re-tries with the specified encoding.
$outVal:=XLS Get text value ($wb;1;1;1;"iso-8859-1")
ALERT($outVal)
$outVal:=XLS Get text value ($wb;1;1;2)
ALERT($outVal)

$filePath:=System folder(Desktop)+"test.xls"
$success:=XLS Save as ($wb;$filePath)

XLS CLOSE ($wb)