FilesExpand file tree

 master

/

CopySpreadsheetTableToDocument.js

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

102 lines (96 loc) · 2.73 KB

 master

/

CopySpreadsheetTableToDocument.js

Copy path

Top

File metadata and controls

• Code
• Blame

102 lines (96 loc) · 2.73 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

101

/*global SpreadsheetApp: false, Browser: false, DocumentApp: false, Logger: false*/

/*

* Written by: mick@javascript-spreadsheet-programming.com

*

* Date: 2013-07-05

*

* Passed by JSLint

*/

/**

* Copy array values to a document table

*

* Given a document name and an array of arrays, creates the document table.

* Highlights the first row (header) in bold.

* Checks for two arguments, the first must be a string and the second an array.

*

* @param {type} docName

* @param {type} values

* @returns {undefined}

*/

function writeTableToDocument(docName, values) {

"use strict";

var doc,

table,

headerRow,

styles = {};

if (typeof docName !== 'string') {

throw {name: 'TypeError',

message: 'Function writeTableToDocument() ' +

'expects a string name for the new ' +

'document as its first argument!'};

}

if (!Array.isArray(values)) {

throw {name: 'TypeError',

message: 'Function writeTableToDocument() ' +

'expects an array of values as its second argument.'};

}

try {

doc = DocumentApp.create(docName);

table = doc.getBody().appendTable(values);

headerRow = table.getRow(0);

styles[DocumentApp.Attribute.BOLD] = true;

headerRow.setAttributes(styles);

doc.saveAndClose();

} catch (ex) {

throw ex;

}

}

/**

* Return the cell values of a named range

* checks that the given argument is type string.

* Uses this name to reference a spreadsheet range.

* If the range name does not exists, it will return 'undefined'

*

* @param rngName string

* @returns array

*/

function getRangeNameValues(rngName) {

"use strict";

var ss = SpreadsheetApp.getActiveSpreadsheet(),

namedRng,

namedRngValues = [];

if (typeof rngName !== 'string') {

throw {name: 'TypeError',

message: 'Function getRangeNameValues() ' +

'expects a single string argument for the ' +

'name of the target range!'};

}

try {

namedRng = ss.getRangeByName(rngName);

namedRngValues = namedRng.getValues();

return namedRngValues;

} catch (ex) {

throw ex;

}

}

/**

* Runs the copying code

*

* @returns {undefined}

*/

function main() {

"use strict";

var rngName = "ContactDetails",

docName = rngName,

rngValues;

try {

rngValues = getRangeNameValues(rngName);

writeTableToDocument(docName, rngValues);

Browser.msgBox('New file created');

} catch (ex) {

Browser.msgBox('There has been an error, check the log');

Logger.log('ERROR:');

Logger.log(ex.message);

throw ex;

}

}