S-PLUS to Excel link error via the Script option

["Edmond" <edmond@statwks.com>]

Dear S-PLUS Users

 

In S-PLUS 6.0 for Windows, it is possible to link S-PLUS data frames to Excel via the S-PLUS to Excel link wizard. I'm able to do this succesfully via the GUI option. However, when I try run the history log script that was generated when I did this via the GUI, I'm getting the following error message:

 

> guiCreate("ActiveDocument")

> guiOpenView("data.frame", Name = "catalyst")

> XLCreateLink(link.name = "Std", xl.workbook.name = "SplusBook1",

xl.worksheet.name = "Sheet1", data.range = "", row.names = "",

col.names = "", col.types = "", update.direction = 2, serialize = T)

[1] F

1: 1 missing values generated coercing from character to logical in: XLCreat\

eLink(link.name = "Std", xl.workbook.name = "SplusBook1", ....

2: 1 missing values generated coercing from character to logical in: XLCreat\

eLink(link.name = "Std", xl.workbook.name = "SplusBook1", ....

 

Has anyone else been having the same problem? If the history log script is wrong, does anyone know what changes I need to do to the script manually in order for it to run without these errors?

thanks.

regards,

Edmond