问如何按字母顺序排列Google工作表的每一行

EN

function sortHorizontal()
{

  var startCol = 1;              // left-most column to where the sort will be applied; A = 1, B = 2, C = 3 etc
  var startRow = 1;              // first row to apply the sort
  var sheetName = 'Sheet1';      // name of sheet in which sort will be applied

  var s = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(sheetName);
  var d = s.getDataRange().getValues();
  var output = [], temp;
  for (var i = startRow - 1; i < d.length; i++)
  {
    temp = d[i].slice(startCol - 1);
    temp.sort(ascSort);          // change to descSort for Z -> A sort
    output.push(temp);
  }
  s.getRange(startRow, startCol, output.length, output[0].length).setValues(output);
}


function ascSort(a, b)
{
  return ((a == b) ? 0 : (a && (!b || a < b)) ? -1 : 1);
}


function descSort(a, b)
{
  return ((a == b) ? 0 : (a > b) ? -1 : 1);
}