如何使我的Google电子表格打开到今天的日期? [英] How do I get my google spreadsheet to open to today's date?

问题描述

这是我的文档的链接: https://docs.google.com/spreadsheets/d/1wBpeCUTmePD3N5CDz57LeBBWZHnSwrX-5b6XscdbB4s/edit?usp = sharing

Here is a link to my document: https://docs.google.com/spreadsheets/d/1wBpeCUTmePD3N5CDz57LeBBWZHnSwrX-5b6XscdbB4s/edit?usp=sharing

我希望文档打开到今天的日期或每周的星期一.请帮忙.预先感谢.

I want the document to open to today's date or to the Monday of each week. Please help. Thanks in advance.

function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getActiveSheet();
  var range = sheet.getRange("A:A");
  var values = range.getValues();
  var day = 24*3600*1000;
  var today = parseInt((new Date().setHours(0,0,0,0))/day);
  var ssdate; 
  for (var i=0; i<values.length; i++) { 
    try { 
      ssdate = values[i][0].getTime()/day; 
    } catch(e) { } 
    if (ssdate && Math.floor(ssdate) == today) { 
      sheet.setActiveRange(range.offset(i,0,1,1));
      break;
    }
  }
} 

推荐答案

尝试中的主要问题是，您抓住了列 A，但是日期存在于 row 中2.试试这个:

The main issue in your attempt is that you grabbed column A, but your dates exist in row 2. Try this:

function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = ss.getSheetByName("2018"); // Specifiy the sheet
  var range = sheet.getRange("2:2"); // Row 2
  var values = range.getValues()[0]; // This is a 2-dimensional array in the form [[row1-col1, row1-col2],[row2-col1,row2-col2]].
  // Because we only pulled one row (Row 2), we can immediately select just that row by appending the [0]

  var today = new Date();
  var todayDate = today.getDate();
  var todayMonth = today.getMonth();
  var todayYear = today.getFullYear();

  for (var i=0; i<values.length; i++) { 
    var columnDate = new Date(values[i]);
    if (columnDate.getDate() === todayDate && columnDate.getMonth() === todayMonth && columnDate.getFullYear() === todayYear) {
      sheet.getRange(1, i+1).activate();
      break;
    }
  }
} 

这篇关于如何使我的Google电子表格打开到今天的日期?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！