rxlsxxlsm

Does the xlsx package work for xlsm files in R?

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!

Solution

  • 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')