search

trinker / reports

An R package to assist in the workflow of writing academic articles and other reports
http://cran.us.r-project.org/web/packages/reports/
102 stars 25 forks source link

read.xlsx problem with ," usage #22

Closed trinker closed 11 years ago

trinker commented 11 years ago

It seems that if a string contains ," then this will split the cell and the contents will be placed to the right.

An example is:

...and the success of one's effort to "understand," say, m...

or 

culture assesses "certain traits to honor, reward, and cultivate"

This is an issue with read.xlsx but still must be addressed by read.notes and or possbile QQ/GQ. This may be a special circumstance that requires a code that is inserted in by QQand then the ," is put back in by read.notes.

Possibly use another means of reading in xlsx files

trinker commented 11 years ago

also the explanatory columns to the rght appear to be an issue with gdata's read.xls

trinker commented 11 years ago

It appears:

library(XLConnect)
x <- readWorksheet(loadWorkbook(file),sheet=1)

is pretty accurate. Explore this and other options.