Examples

function makeObjectsExample() {

var range = SpreadsheetApp.getActiveSheet().getDataRange().getValues();

var dataObjects = Objapp.rangeToObjects(range);

Logger.log(dataObjects[1]['headerA']);

}

function camelArrayExample(){

var data = SpreadsheetApp.getActiveSheet().getDataRange().getValues();

var headers = Objapp.camelArray(data[0]);

Logger.log(headers);

}

function camelStringExample(){

var aString = '1 This String ';

Logger.log(Objapp.camelString(aString));

}

function SubmitButton1 (e) {

var app = UiApp.getActiveApplication();

var sheet = SpreadsheetApp.getActiveSheet();

var headers = sheet.getRange(1,1,1,sheet.getLastColumn()).getValues()[0];

var valuesR = Objapp.objectToArray([e.parameter]); //returns [[]]

sheet.getRange(sheet.getLastRow()+1, 1, 1, valuesR[0].length).setValues([valuesR[0]]);

return app;

}

//spreadsheet example where only one row is written.

//the object is an array of rows

function objToSS(){

var sheet = SpreadsheetApp.getActiveSheet();

var data = sheet.getDataRange().getValues();

var dataObjects = Objapp.rangeToObjects(data);

var headers = sheet.getRange(1,1,1,sheet.getLastColumn()).getValues()[0];

var valuesR = Objapp.objectToArray(headers, dataObjects);

sheet.getRange(7, 1, 1, valuesR[0].length).setValues([valuesR[0]]);

}

function changeSomeValues(){

var sheet = SpreadsheetApp.getActiveSheet();

var data = sheet.getDataRange().getValues();

var dataObjects = Objapp.rangeToObjects(data);

var headers = sheet.getRange(1,1,1,sheet.getLastColumn()).getValues()[0];

//Change the value of the first data row in column header named 'Header A'

dataObjects[0].headerA = 'New value';

var valuesR = Objapp.objectToArray(headers, dataObjects);

sheet.getRange(2, 1, valuesR.length, valuesR[0].length).setValues(valuesR);

}