Hello Guys,
The below code is running from last 30 mins and still giving me neither results nor error. it seems the function reading the file is lost somewhere inside my file.
Is excel.link the only package to read binary formatted files in R ?
any alternatives with data.table approaches ?
Regards,
Vishal
> ```
> library(excel.link)
>
> start.time = Sys.time()
> Cust_Transactions <- xl.read.file("C:/Users/vishals758/Desktop/Workspace/Apr-Sep.xlsb", header = TRUE, row.names = NULL, col.names = NULL,
> xl.sheet = "sample", top.left.cell = "A1", na = "", password = NULL,
> write.res.password = NULL, excel.visible = FALSE)
>
>
> end.time <- Sys.time()
> time.taken <- end.time - start.time
> time.taken
> ```