[R-SIG-Mac] Problem in importing xlsx files

[Timothy Bates]

have you tried the gdata package?

it works great, and is spreading in use here (especially with students. who love the ability to enter and clean data up in an easy to use spreadsheet)

fWHR <- gdata::read.xls("~/Dropbox/Capuchin_fWHR.xlsx”)

tim


On 5 Sep 2012, at 3:31 PM, Simon Urbanek <simon.urbanek at r-project.org> wrote:
>> Please suggest what should I do. I have used alternative method of
>> importing then i got error like
>> 
>> 
>> Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method,  :
>> Intermediate file
>> 'C:\.................................................\file15c45663419f.csv'
>> missing!
>> In addition: Warning message:
>> running command '"C:\STRAWB~1\perl\bin\perl.exe"
>> "C:/.............................../2.15/gdata/perl/xls2csv.pl"  "Sales
>> 2011_12.xlsx"
>> "C:\Users\....................................file15c45663419f.csv"
>> "AMJ2011"' had status 1
>> Error in file.exists(tfn) : invalid 'file' argument

-- 
The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.