Import Excel Tables into R [duplicate]

2

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.

    
asked by anonymous 11.07.2017 / 16:31

1 answer

4

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 or read.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!

    
11.07.2017 / 18:34