我使用了我的代码大约一周(已经很慢了),但仍然继续下去。今天,在尝试运行它时,我收到消息“ReferenceError: Function function getValues() {/* */} 不能用作赋值的左侧或用作 ++ 或 -- 运算符的操作数。 ”
这是代码:
function PreenchePlanilha()
{
var App = SpreadsheetApp;
App.getActiveSpreadsheet().getSheetByName('MacroHelp').getRange(1,1).activate();
var helpMacro = App.getActiveSpreadsheet().getActiveSheet();
var i = 250;
var j = 1;
var k = 1;
while (helpMacro.getRange(i,5).getValue() != "")
{
if(helpMacro.getRange(i,17).getValue() == "")
{
while (helpMacro.getRange(j,20).getValues().toString() != helpMacro.getRange(i,5).getValues().toString())
{
j = j+1;
}
var aba = helpMacro.getRange(j,21).getValue();
var valores = helpMacro.getRange(i,6, 1, 11);
var email = helpMacro.getRange(i,1).getValue();
App.getActiveSpreadsheet().getSheetByName(aba).getRange(1,1).activate();
var cols = contalinha();
while (App.getActiveSpreadsheet().getActiveSheet().getRange(k,8).getValue() != email && k <= cols)
{
k = k + 1;
}
App.getActiveSpreadsheet().getActiveSheet().getRange(k,31,1,11).getValues() = helpMacro.getRange(i,6, 1, 11);
App.getActiveSpreadsheet().getSheetByName("MacroHelp").getRange(i,17).activate();
App.getActive().getCurrentCell().setValue('Feito');
}
i++;
j = 1;
k = 1;
}
}
function contalinha() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('A1').activate();
spreadsheet.getCurrentCell().getNextDataCell(SpreadsheetApp.Direction.DOWN).activate();
var cols = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet().getActiveRange().getRow();
return cols;
};
我尝试更换线路
App.getActiveSpreadsheet().getActiveSheet().getRange(k,31,1,11).getValues() = helpMacro.getRange(i,6, 1, 11);
我尝试了这两个代码,但没有一个工作:
App.getActiveSpreadsheet().getActiveSheet().getRange(k,31,1,11).setValues() = valores;
App.getActiveSpreadsheet().getActiveSheet().getRange(k,31,1,11).setValues(valores);
我究竟做错了什么?