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(at least a single non-empty cell).