含计算字段时Google Sheets Query无法隐藏表头的问题

问题场景 #

对如下表格执行Query查询：

当查询包含通过 upper('c') 生成的固定值计算列时，使用URL参数 headers=0 试图隐藏表头失效；移除计算列后，表头可正常隐藏。尝试使用 Offset 参数也无法解决该问题，需确认是否为平台异常，并寻求可行的解决方案/替代方法。

带计算列的代码及错误结果 #

代码 #

function testSQL() 
{
  const fileKey="xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx";
  const sheetName="Sheet1";
  const formatType="csv";
  
  var queryA="SELECT A, B, C, upper('c')";
  var queryURLA = 'https://docs.google.com/spreadsheets/d/' + fileKey + '/gviz/tq?tqx=out:' + formatType + '&headers=0&sheet=' + sheetName + '&tq=' + encodeURIComponent(queryA);

  //Logger.log(queryURLA);

  var retA = UrlFetchApp.fetch(queryURLA, {headers: {Authorization: 'Bearer ' + ScriptApp.getOAuthToken()}}).getContentText();
  var retAV = Utilities.parseCsv(retA,",");

  Logger.log(retAV);

  return retAV;
}

执行日志（错误：出现异常表头） #

7:35:20 AM  Notice  Execution started
7:35:21 AM  Info    [[, , , upper("c"())], [1, 2, 3, C], [4, 5, 6, C], [7, 8, 9, C], [10, 11, 12, C], [13, 14, 15, C]]
7:35:21 AM  Notice  Execution completed

无计算列的代码及正确结果 #

代码 #

function testSQL() 
{
  const fileKey="xxxxxxxxxxxxxxxxxxxxxxxxx";
  const sheetName="Sheet1";
  const formatType="csv";
  
  var queryA="SELECT A, B, C";
  var queryURLA = 'https://docs.google.com/spreadsheets/d/' + fileKey + '/gviz/tq?tqx=out:' + formatType + '&headers=0&sheet=' + sheetName + '&tq=' + encodeURIComponent(queryA);

  //Logger.log(queryURLA);

  var retA = UrlFetchApp.fetch(queryURLA, {headers: {Authorization: 'Bearer ' + ScriptApp.getOAuthToken()}}).getContentText();
  var retAV = Utilities.parseCsv(retA,",");

  Logger.log(retAV);

  return retAV;
}

执行结果（正确：无表头） #

Execution log
7:31:59 AM  Notice  Execution started
7:31:59 AM  Info    [[1, 2, 3], [4, 5, 6], [7, 8, 9], [10, 11, 12], [13, 14, 15]]
7:32:00 AM  Notice  Execution completed

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