Dear Sir,
rcom is a great package of R. Yet it seems that there is some problem of
Chinese character supporting.
comGetPropery() always get the part of the Chinese character.
Any suggestion would be appreciated.
Thanks.
Michael
> library(rcom)
Loading required package: rscproxy> txe<-comCreateObject("Excel.Application")
> comSetProperty(txe,"Visible",TRUE);
NULL> newwb <-
comInvoke(comGetProperty(txe,"Workbooks"),"Add")
> ws <- comGetProperty(newwb,"Worksheets",1)
> e<-comGetProperty(ws,"Range","A1")
> comSetProperty(e,"Value","abc defg hijl agfasdg")
NULL> comGetProperty(e,"Value")
[1] "abc defg hijl agfasdg"> c<-comGetProperty(ws,"Range","A2")
> comSetProperty(c,"Value","中国北京")
NULL> comGetProperty(c,"Value")
[1] "中国"> sessionInfo()
R version 2.9.0 (2009-04-17)
i386-pc-mingw32
locale:
LC_COLLATE=Chinese (Simplified)_People's Republic of
China.936;LC_CTYPE=Chinese (Simplified)_People's Republic of
China.936;LC_MONETARY=Chinese (Simplified)_People's Republic of
China.936;LC_NUMERIC=C;LC_TIME=English_United States.1252
attached base packages:
[1] stats graphics grDevices utils datasets methods base
other attached packages:
[1] rcom_2.2-1 rscproxy_1.3-1>
The computer is a notebook with Windows Vista Home Premium, Simplified
Chinese edition.
[[alternative HTML version deleted]]