Java：访问ANY模块之外的相对路径(Java: Access relative path outside ANY module)

 你不能使用appendRow做你想要的。 您正在使用： 
 
target_sheet.appendRow(data);
 
 你需要使用setValues() 
 
target_sheet(start row, start column, number of rows, number of columns).setValues(data);
 
 在您的情况下，如果要覆盖（编辑）现有行，则需要在其中找到包含索引的行，并将该数字用于start row参数。 
 
var data, dataAs1D,dataFromCol1,ouss, target_sheet, lastRow,rowToEdit;

ss = SpreadsheetApp.getActiveSpreadsheet();
target_sheet = ss.getSheetByName('name');

lastRow = target_sheet.getLastRow();

dataFromCol1 = target_sheet.getRange(1,1,lastRow,1).getValues();//Get all col A values
dataAs1D = dataFromCol1.toString().split(",");//Convert 2D array to 1D

rowToEdit = colorRow;//

data = ['one','two','three'];
outerArray = [];//Assign empty array to variable name
outerArray.push(data);
target_sheet.getRange(rowToEdit,1,data[0].length,data.length).setValues(data);
 
 此示例假定您的索引号位于第一列。 

You can not use appendRow to do what you want. You are using:
 
target_sheet.appendRow(data);
 
You need to use setValues()
 
target_sheet(start row, start column, number of rows, number of columns).setValues(data);
 
In your case, if you want to overwrite (edit) an existing row, then you will need to find the row with the index in it, and use that number for the start row parameter.
 
var data, dataAs1D,dataFromCol1,ouss, target_sheet, lastRow,rowToEdit;

ss = SpreadsheetApp.getActiveSpreadsheet();
target_sheet = ss.getSheetByName('name');

lastRow = target_sheet.getLastRow();

dataFromCol1 = target_sheet.getRange(1,1,lastRow,1).getValues();//Get all col A values
dataAs1D = dataFromCol1.toString().split(",");//Convert 2D array to 1D

rowToEdit = colorRow;//

data = ['one','two','three'];
outerArray = [];//Assign empty array to variable name
outerArray.push(data);
target_sheet.getRange(rowToEdit,1,data[0].length,data.length).setValues(data);
 
This example assumes that your index numbers are in column one.