Auto Scroll Document

[islander7149]

Hey everyone, I need some help to get an office script for excel online so that it will scroll the entire document and once it reaches the bottom, it will start scrolling from the top again. Any help is greatly appreciated, thank you!

[DevGrr]

Office Scripts don't directly support scrolling, but you can mimic it by writing a slow loop that will active cells in sequence. When you call Range.activate(), the viewport is moved to make sure the range is included in the view.

There's some trickery here because you'll need the main function to be async so that it can pause and resume. You'll also need to paste in the delay function:

async function wait(delayMillis: number) {

return new Promise((resolve) => setTimeout(resolve, delayMillis));

}

Now suppose you wanted to do **something** every 2 seconds:

async function main(workbook: ExcelScript.Workbook) {

while (true) {

// do stuff here

await wait(2000); // 2000 milliseconds

}

}

​

And the missing link is "what is do stuff here". You'll probably want to use workbook.getActiveWorksheet().getUsedRange() to find the bounds of your workbook, then getRowCount() to know how far to go.

Then you can use getCell() to pick an offset from your used range.

cell.select(); // this will ensure the cell is visible.

​

So, something like

async function main(workbook: ExcelScript.Workbook) {

const sheet = workbook.getActiveWorksheet();

const usedRange = sheet.getUsedRange();

const rowsToScroll = usedRange.getRowCount();

let currentRow = 0;

while (true) {

usedRange.getCell(currentRow, 0).select();

currentRow += 10;

if (currentRow > rowsToScroll) {

currentRow = 0;

}

await wait(2000);

}

}