What does “[Ljava.lang.Object;@” mean?

I am filling a Google spreadsheet from a form. The code writes some information into the spreadsheet, it always does it right, but before writing what it is supposed to, it writes [Ljava.lang.Object;@1c7aa4fc (or something like that) on the last row in the spreadsheet. Why is it appearing there?

The code for writing into the spreadsheet:

for (var p = 1; p < data.length; p++) {
    var ppopis = data[p][2]; 
    var sstav = data[p][7];
    var ukonceno_dne = data[p][9];
    var cell = spred2.getRange("H"+(p+1));
    var celll = spred2.getRange("J"+(p+1));
    if(nadpis_pole == ppopis && vlozena_hodnota == "Zrušeno") {
      cell.clear();
      cell.setValue("Zrušeno");
      if(ukonceno_dne == "" || ukonceno_dne == null){
        celll.setValue(dnesni_datum);
      }
    } else if (nadpis_pole == ppopis && vlozena_hodnota == "Vráceno") {
      cell.clear();
      cell.setValue("Vráceno");
      if(ukonceno_dne == "" || ukonceno_dne == null){
        celll.setValue(dnesni_datum);
      }
    }
  }

Thanks :)

Answers:

Answer

App script has underlying data structure built up on java...Ljava.lang..... represents object notation in Java to indicate any object such as Array,JSON in GAS.To get actual value try toString() (or) JSON.Stringify() and check whether you have a value.

Answer

Be careful of when you do value setting. You could be passing an array ( or an object type ) by mistake, and you really want to insert a string.

For Example:

        ...
        aSheet.appendRow([["hello world"]]);

Will append "Java.Lang.Object" into the first cell of the appended row.

The correct API will be:

        ...
        aSheet.appendRow(["hello world"]); // single array

Tags

Recent Questions

Top Questions

Home Tags Terms of Service Privacy Policy DMCA Contact Us

©2020 All rights reserved.