Excel office script - ctrl + shift + end

Hello everyone,   Is there an interface or alghoritm to select the range that I would get if I were to click CTRL+ SHIFT + END. I would need the rightmost column and downmost row that contains data...