I am afraid that at this stage the Spreadsheet widget does not offer lazy loading functionality for its sheets. Having that said, I would recommend you to cast your vote for the following feature request:
Based on the support it receives from the community, we will decide on whether to proceed with its implementation or not.
Progress is here for your business, like always. Read more
about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic.
Our thoughts here at Progress are with those affected by the outbreak.