language_string_generator/export.js at main · dinghk/language_string_generator · GitHub

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
102
103
function exportToIOS() {
  var spreadsheet = SpreadsheetApp.getActive();
  var total = spreadsheet.getSheets().length;
  var enData = new Array();
  var tcData = new Array();

  for (var a=0; a<total; a++)
  {
    var sheet = spreadsheet.getSheets()[a]
    if (sheet.getSheetName() == 'en' || sheet.getSheetName() == 'tc') {
        // do nothing
    } else {
      enData.push([""])
      enData.push(['/*******************************'])
      enData.push(['* ' + sheet.getSheetName()])
      enData.push(['*******************************/'])

      tcData.push([""])
      tcData.push(['/*******************************'])
      tcData.push(['* ' + sheet.getSheetName()])
      tcData.push(['*******************************/'])

      var range = 'A2:C' + sheet.getLastRow().toString()
      sheet.getRange(range)
        .getValues()
        .forEach(function(r, i) {
          if (r[0] == "") {

          } else {
            enData.push(['"' + r[0] + '" = ' + '"' + r[1] + '";'])
            tcData.push(['"' + r[0] + '" = ' + '"' + r[2] + '";'])
          }
        });
    }
  }

  // Add to sheet
  var enSheet = spreadsheet.getSheetByName('en');
  var tcSheet = spreadsheet.getSheetByName('tc');
  enSheet.clearContents()
  tcSheet.clearContents()
  for (var i=0; i<enData.length; i++) {
    enSheet.getRange(1,1,enData.length, 1)
      .setValues(enData)
  }
  for (var i=0; i<tcData.length; i++) {
    tcSheet.getRange(1,1,tcData.length, 1)
      .setValues(tcData)
  }

}

function exportToAndroid() {
  var spreadsheet = SpreadsheetApp.getActive();
  var total = spreadsheet.getSheets().length;
  var enData = new Array();
  var tcData = new Array();

  for (var a=0; a<total; a++)
  {
    var sheet = spreadsheet.getSheets()[a]
    if (sheet.getSheetName() == 'en' || sheet.getSheetName() == 'tc') {
        // do nothing
    } else {
      enData.push([""])
      enData.push(['/*******************************'])
      enData.push(['* ' + sheet.getSheetName()])
      enData.push(['*******************************/'])

      tcData.push([""])
      tcData.push(['/*******************************'])
      tcData.push(['* ' + sheet.getSheetName()])
      tcData.push(['*******************************/'])

      var range = 'A2:C' + sheet.getLastRow().toString()
      sheet.getRange(range)
        .getValues()
        .forEach(function(r, i) {
          if (r[0] == "") {

          } else {
            enData.push(['<string name="' + r[0] + '">' + r[1] + '</string>'])
            tcData.push(['<string name="' + r[0] + '">' + r[2] + '</string>'])
          }
        });
    }
  }

  // Add to sheet
  var enSheet = spreadsheet.getSheetByName('en');
  var tcSheet = spreadsheet.getSheetByName('tc');
  enSheet.clearContents()
  tcSheet.clearContents()
  for (var i=0; i<enData.length; i++) {
    enSheet.getRange(1,1,enData.length, 1)
      .setValues(enData)
  }
  for (var i=0; i<tcData.length; i++) {
    tcSheet.getRange(1,1,tcData.length, 1)
      .setValues(tcData)
  }

}