ObjService

Turns spreadsheet's rows of data into Javascript objects to make them easier to use.

Project Key: MTeYmpfWgqPbiBkVHnpgnM9kh30YExdAc

function camelStringExample(){

var aString = '1 This String ';

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

}

More examples are available here:

https://sites.google.com/site/scriptsexamples/custom-methods/gs-objects/examples

ObjApp (version 1)

First Release

objectToArray(String[] headers, Object[] objValues)

Changes an object like e.parameter into a 2D array useful in writting to a spreadsheet using the .setValues method

Arguments:

Return Values:

Type

String[][]

Description

[[value, value, ...], ...]

rangeToObjects(String[][] range)

Changes a range String[][] often returned from .getValues() into an Object[] with key value pairs. The first element in the String[][] is used to create keys

Arguments:

Name

range

Type

String[][]

Description

[[key, key, ...],[value, value, ...]]

Return Values:

Type

Object[]

Description

[{key:value, ...}, ...]

splitRangesToObjects(String[] headers, String[][] values)

Combines a String[] and String[][] into an Object[] with key value pairs

Arguments:

Return Values:

Type

Objec[]

Description

[{key:value, ...}, ...]

camelArray(String[] headers)

Converts a String[] to camelCase, Example: "First Name" -> "firstName"

Arguments:

Name

headers

Type

String[]

Description

[string, string, ...]

Return Values:

Type

String[]

Description

[string, string, ...]

camelString(String header)

Converts a String to camelCase, Example: "First Name" -> "firstName"

Arguments:

Name

header

Type

String

Description

String

Return Values:

Type

String

Description

camelCase