R: Error while reading XLS file because of styles

491 views Asked by At

While trying to load XLS file to R

people <- readWorksheetFromFile("/Users/andi/export_exp_11.xls",sheet="people")

I got:

ERROR: IllegalArgumentException (Java): Unable to set user specified style names for built in styles!le 

When I openede the file in Excel and selected whole spreadsheet and set style to None it runs ok. I would like to manipulate programatically this styles before reading it to R? Without using Excel of course. Is it possible?

0

There are 0 answers