xlsx软件包可用于R中的xlsm文件吗? [英] Does the xlsx package work for xlsm files in R?

问题描述

我正在尝试从xlsm工作簿读取一个范围到data.frame中.我可以使用R中的xlsx软件包来做到这一点吗?如果没有，有人知道这样做的方法吗?

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?

谢谢！

推荐答案

您是否尝试按照手册中所述使用read.xlsx或read.xlsx2?

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

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

如果这些文件不适用于您的文件格式，并且您尝试访问表格数据，则可能需要打开.xlsm并将数据导出为csv格式.

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.

这些很容易导入uisng read.csv('filename.csv')

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

这篇关于xlsx软件包可用于R中的xlsm文件吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！