Is there a way to get last row/ last column of Excel sheet without VBA?

[EnjoyFX]

I'm trying to use R in Excel with Bert for few weeks.

I know how to easily get last row/column in VBA, but can BERT help to get this information directly too? For example, if I have loaded Excel file with different source data (some n x m matrix with different n and m) - can I write some function for detection of number of columns/rows of loaded data only in R file with help of Bert?

Thanks, Andy

[bro-bert]

Here is a way wb<-EXCEL$Application$get_ActiveWorkbook() wbx<-loadWorkbook(wb$get_FullName) ext_alc<-getBoundingBox(wbx,"Sheet Name")