Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /**
- * Convert Spreadsheet data into strings.xml (android) and Localized.string (ios)
- * requierment:
- * 3 sheets should be create (wordings, android, ios)
- * wording sheet should have 3 column (comment_flag, key, value)
- **/
- function convertSpreadSheetToMobileWordingsFile() {
- var spreadSheet = SpreadsheetApp.getActiveSpreadsheet();
- var sheet = spreadSheet.getSheets()[0];
- var data = sheet.getDataRange().getValues();
- var generatedAndroidFile = "<resources>" + "\n";
- var generatedIosFile = "";
- for (var i = 1; i < data.length; i++) {
- var comment = data[i][0];
- var key = data[i][1];
- var value = data[i][2];
- if (key == '') {
- generatedAndroidFile += "\n";
- generatedIosFile += "\n"
- continue;
- }
- generatedAndroidFile += printLineAndroid(comment, key, value);
- generatedIosFile += printLineIos(comment, key, value);
- }
- generatedAndroidFile += "\n</resources>";
- wroteGeneratedFile(1, generatedAndroidFile);
- wroteGeneratedFile(2, generatedIosFile);
- }
- function wroteGeneratedFile(sheetNumber, generatedFile) {
- var spreadSheet = SpreadsheetApp.getActiveSpreadsheet();
- var sheetToWrite = spreadSheet.getSheets()[sheetNumber];
- var range = sheetToWrite.getRange('A1');
- range.clear();
- range.setValue(generatedFile);
- // set style
- range.setWrap(true);
- range.setBackground("#2e2e2f");
- range.setFontColor("#ffffff");
- }
- // ----- ANDROID -----
- function printLineAndroid(comment, key, value) {
- if (comment == '//') {
- var newLine = "<!-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -->\n";
- newLine += "<!-- " + key + " -->\n\n";
- return newLine;
- }
- var newLine = "\t<string name=\"" + key + "\">" + value + "</string>\n";
- return newLine;
- }
- // ----- IOS -----
- function printLineIos(comment, key, value) {
- if (comment == '//') {
- var newLine = "// ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~\n";
- newLine += "// " + key + "\n\n";
- return newLine;
- }
- var newLine = "\"" + key + "\" = \"" + value + "\";\n";
- newLine = newLine.replace('%1$s', '%1$@');
- newLine = newLine.replace('%2$s', '%2$@');
- return newLine;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement