Does the xlsx package work for xlsm files in R?

r xlsx xlsm
overflowname picture overflowname · Jun 26, 2012 · Viewed 17.4k times · Source

I am trying to read a range into a data.frame from a xlsm workbook. Can I do this with the xlsx package in R? If not, does anyone know of a way to do it?

Thank you!

Answer

John picture John · Jun 26, 2012

Did you try using read.xlsx or read.xlsx2 as described in the manual?

http://cran.r-project.org/web/packages/xlsx/xlsx.pdf

If these do not work with your file format, and you are trying to access tabular data you might want to open the .xlsm and export your data to csv format.

These are easily imported uisng read.csv('filename.csv')

Related questions

Importing Excel files into R, xlsx or xls

Please can someone help me on the best way to import an excel 2007 (.xlsx) file into R. I have tried several methods and none seems to work. I have upgraded to 2.13.1, windows XP, xlsx 0.3.0, I don't know why the error …

Read More
Easy way to export multiple data.frame to multiple Excel worksheets

I am surprised to find that there is no easy way to export multiple data.frame to multiple worksheets of an Excel file? I tried xlsx package, seems it can only write to one sheet (override old sheet); I also …

Read More
Importing a big xlsx file into R?

I'm wondering if anyone knows of a way to import data from a "big" xlsx file (~20Mb). I tried to use xlsx and XLConnect libraries. Unfortunately, both use rJava and I always obtain the same error: > library(XLConnect) > …

Read More