I have a situation where I need to display a table with multiple rows of data. Row count can be from 1 to 99. Is a scrollable modal the correct UX, or should I display this info on its own page?
Generally I steer away from tables in modals/lightboxes
Tables this large would almost certainly be handled in-page as you are likely to need to perform actions on elements in the table (create/delete/edit etc) and having a table in a modal (or slide-out/lightbox) would lead to horrible interactions down the line
edit: just saw your comment
I did an interaction like this where it was done in-page. It was much easier to manipulate/view the spreadsheet data when the user wasn't constrained by smaller windows.