C# VSTO Excel加载项：实现按下向下箭头键时强制滚动一行

Got it, let's build this feature for your Excel add-in! The core idea is to override the default ArrowDown key behavior so that pressing it always scrolls the worksheet by one row—no matter if the selected cell is in the middle of your visible screen or at the bottom edge.

Step-by-Step Implementation (Using Office JavaScript API) #

First, we'll listen for the ArrowDown keypress, block Excel's default action, then manually trigger the scroll and optionally update the selected cell.

1. Add Keyboard Event Listener

We'll attach a global keydown listener to catch the arrow press, but we'll make sure it only acts when focus is on the Excel worksheet (not task pane inputs).

window.addEventListener('keydown', async (event) => {
  // Target only ArrowDown, and ignore if focus is on task pane input fields
  if (event.key === 'ArrowDown' && !['INPUT', 'TEXTAREA'].includes(document.activeElement.tagName)) {
    event.preventDefault(); // Stop Excel's default behavior (selecting next cell without scroll)
    
    try {
      await Excel.run(async (context) => {
        const worksheet = context.workbook.activeWorksheet;
        const activeView = worksheet.getActiveView();
        const selectedRange = context.workbook.getSelectedRange();
        
        // Get the height of the currently selected row (handles variable row heights)
        const currentRow = worksheet.getRangeByIndexes(
          selectedRange.rowIndex,
          0,
          1,
          worksheet.getUsedRange().columnCount
        );
        currentRow.format.rowHeight.load('value');
        await context.sync();
        
        // Calculate new scroll position: current offset + row height
        activeView.verticalScrollPosition += currentRow.format.rowHeight.value;
        await context.sync();
        
        // Optional: Move selection to the next row (matches default selection behavior)
        const nextRowRange = worksheet.getRangeByIndexes(
          selectedRange.rowIndex + 1,
          selectedRange.columnIndex,
          selectedRange.rowCount,
          selectedRange.columnCount
        );
        nextRowRange.select();
        await context.sync();
      });
    } catch (error) {
      console.error('Scroll error:', error);
      if (error instanceof OfficeExtension.Error) {
        console.error('Debug details:', error.debugInfo);
      }
    }
  }
});

2. Key Details to Note

• Variable Row Height Support: Instead of hardcoding a row height, we fetch the height of the currently selected row—this works even if your worksheet has rows with custom heights.
• Focus Handling: We skip the event if focus is on an input/textarea in your add-in's task pane, so your users can still type normally there.
• Optional Selection Update: The code includes logic to move the selected cell down one row (matching Excel's default behavior), but you can remove that block if you only want to scroll without changing the selection.
• Permissions: Make sure your add-in's manifest file includes the ReadWriteDocument permission to modify worksheet views and selections.

Testing the Feature #

1. Sideload your add-in into Excel.
2. Select any cell in the middle of your visible screen.
3. Press the ArrowDown key—your worksheet should scroll down by exactly one row, just like when you're at the bottom edge of the screen.

内容的提问来源于stack exchange，提问作者Tuong Phan