如何在Google Sheets中让初始值为0的A1单元格每秒自动递增1

Got it, let's figure out how to get cell A1 counting up by 1 every second starting from 0. Since Google Sheets doesn't have a built-in function for real-time second-by-second updates, we'll use Google Apps Script with client-side JavaScript to make this work. Here's a straightforward step-by-step guide:

Step 1: Open the Apps Script Editor #

• In your Google Sheet, head to Extensions > Apps Script to launch the script editor.

Step 2: Replace the Default Code #

Delete the auto-generated myFunction() code and paste this in its place:

// Add a custom menu to the sheet when it opens
function onOpen() {
  SpreadsheetApp.getUi()
    .createMenu('Auto Increment')
    .addItem('Start Counting', 'showSidebar')
    .addToUi();
}

// Open a sidebar with the client-side counting logic
function showSidebar() {
  const html = HtmlService.createHtmlOutput(`
    <script>
      let count = 0;
      // Set A1 to 0 first, then start the timer
      google.script.run.withSuccessHandler(() => {
        window.intervalId = setInterval(() => {
          count++;
          google.script.run.updateCell(count);
        }, 1000);
      }).initializeCell();
      
      // Stop counting when the sidebar closes
      window.addEventListener('beforeunload', () => {
        clearInterval(window.intervalId);
      });
    </script>
    <p>Counting started! Check cell A1.</p>
    <button onclick="window.close()">Stop Counting</button>
  `)
  .setTitle('Auto Increment Tool');
  
  SpreadsheetApp.getUi().showSidebar(html);
}

// Initialize A1 to 0
function initializeCell() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.getRange('A1').setValue(0);
}

// Update A1 with the current count
function updateCell(count) {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  sheet.getRange('A1').setValue(count);
}

Step 3: Save and Launch the Tool #

• Click the save icon (💾) and name your project (like "AutoIncrementA1").
• Close the script editor and refresh your Google Sheet. You'll see a new Auto Increment menu at the top.
• Click Auto Increment > Start Counting — a sidebar will pop up, and cell A1 will start ticking up by 1 every second right away.

Quick Notes: #

• Counting stops if you close the sidebar or refresh the sheet. Just use the menu again to restart.
• You'll need edit access to the sheet, since the script needs permission to modify cells.
• This setup uses minimal resources, so you won't hit Google's Apps Script quotas for regular use.

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