How to read xls/xlsx files using ArvadosR SDK

How-to
#1

Hi,

I went through the Arvados R SDK document, but I didn’t find how excel files (.xls or .xlsx) are read in R from Arvados API? So far it seems that only .txt, .tsv, .csv, .json can be read?

#2

I have not used it myself, but according to this, collection$readArvFile() supports reading xlsx:

https://doc.arvados.org/v2.6/sdk/R/index.html

#3

Thanks! But it didn’t work for me, so I was really looking for some function similar to read.delim but to read xlsx data. Unfortunately, openxlsx or readxl function only takes file not connection