I would like to know the best library for importing tables from excel to be manipulated in R. I would like one to support all extensions, especially .xlsm.
I would like to know the best library for importing tables from excel to be manipulated in R. I would like one to support all extensions, especially .xlsm.
I found a way to read with the XLConnect
package.
require(XLConnect)
dados <- readWorksheetFromFile("Pasta1.xlsm", sheet=1)
Here it worked for a very simple set of data saved in xlsm.
This package is for several excel file types. But the most common form (for .xls and .xlsx) is the one you described earlier:
According to the response this StackOverflow topic in English , and possible to read with the XLSX package of the R, with the command
read.xlsx
orread.xlsx2
. I believe it works for xlsm, however I can not say for sure because I've never used it for this format.This package makes it possible to read the various formats used in the Excel, such as csv, xls, and xlsx. I think it works for xlsb and xlsm.
I hope this time it will help!