How to see the logs

Question

How to see the logs

rmlopes opened this issue 5 years ago · 11 comments

Hi,

How can I see the logs of the R script that is run?

Answer 1 · 2019-09-12T21:07:41.000Z

I am now able to provide a bit more info. The code I am trying is very simple:

lista =   xl.current.region('Sheet1!k2:k53', col.names = FALSE, row.names = FALSE)
res =   ks.test(as.numeric(lista),'pnorm',mean=mean(lista),sd=sd(lista))$p.value
xl['Sheet1!N2'] = NA
xl['Sheet1!N2'] = res

The problem is if I try to get the data from a different sheet it does not work. Moreover, If I rename my sheet (changing line 1 accordingly) is does not work either. I have to go back to the original name.

Answer 2 · 2019-09-12T21:22:54.000Z

Hi,
Sorry, there are no logs at this moment.
As far as I can see lista is data.frame and ks.test doesn't work with data.frames.
Try the following:

lista =   xl.current.region('Sheet1!k2:k53', col.names = FALSE, row.names = FALSE)[[1]] # take only first column
res =   ks.test(as.numeric(lista),'pnorm',mean=mean(lista),sd=sd(lista))$p.value
xl['Sheet1!N2'] = NA
xl['Sheet1!N2'] = res

Additionally check what will be selected when you press Ctrl+Shift+* on sheet1!k2. All selected values need to be numeric.

Answer 3 · 2019-09-12T21:38:21.000Z

Maybe I did not express myself correctly. The R code is fine, I can run it in R, and it runs in excel if I make a new sheet and use the original name "Sheet1" like the sample I provided. If I simply change the name of that same sheet to "Sheet2" (updating also the first line of the R code) than there is some error and the R code stops executing in the very first line.

This is a bit of an ackward error, and it is behavior that does not happen on the example file. Maybe there is some workbook setting/option that I am missing?

Just to be clear, If I change the name of the sheet back to "Sheet1" the code executes and gives the result.

Answer 4 · 2019-09-12T21:57:07.000Z

Yes, it is really strange.
Did you try to run your code in the R itself (not via Excel) with lista = xl.current.region('Sheet2!k2:k53', col.names = FALSE, row.names = FALSE)?
It should work the same way or rise an error with descriptive message.

Answer 5 · 2019-09-12T22:05:45.000Z

In R it works fine, just tried it.

Answer 6 · 2019-09-12T22:08:45.000Z

Hmm... I will try tomorrow - by now I don't have Windows system near me.
Did you save workbook after the renaming workbook? Perhaps, it helps.

Answer 7 · 2019-09-12T22:13:16.000Z

Yep, also tried that after renaming the sheet, and close and reopen the workbook as well. Thanks for the help.

Answer 8 · 2019-09-12T22:23:55.000Z

One more check. Try in Excel:

tryCatch({
  lista =   xl.current.region('Sheet1!k2:k53', col.names = FALSE, row.names = FALSE)
  res =   ks.test(as.numeric(lista),'pnorm',mean=mean(lista),sd=sd(lista))$p.value
  xl['Sheet1!N2'] = NA
  xl['Sheet1!N2'] = res},
  error = function(e) e$message
  )

It should return error message.

Answer 9 · 2019-09-12T22:29:25.000Z

Nothing happens when I run it.

Answer 10 · 2019-09-12T22:33:49.000Z

Sorry:

xl['Sheet1!N2'] = tryCatch({
  lista =   xl.current.region('Sheet1!k2:k53', col.names = FALSE, row.names = FALSE)
  res =   ks.test(as.numeric(lista),'pnorm',mean=mean(lista),sd=sd(lista))$p.value
  xl['Sheet1!N2'] = NA
  xl['Sheet1!N2'] = res},
  error = function(e) e$message
  )

Answer 11 · 2019-09-12T22:43:21.000Z

It prints "Exception ocurred". In the meanwhile I was able to debug it through R, the data has different formats when picking up from the different sheets for some reason (the type is numeric in both, but the result is different for some reason). All working like a breeze now. Many thanks @gdemin.