shentuo ShentuoZhan
ShentuoZhan
/ exportXML_Strings.js
Last active
May 19, 2016 09:59
— forked from pamelafox/exportjson.js
Google Spreadsheet Export to XML for Android string resource / strings file for iOS translation resource !
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // Includes functions for exporting active sheet or selected data as XML or Strings object | |
| // to xml/strings file in the Google Drive folder where current spreadsheet located. | |
| //0. Open the Tools -> Script editor inside the Spreadsheet you want to export data, then copy the codes here and save the | |
| // .gs file inside the editor with any project name. | |
| //1. Only file owner can export the spreadsheet as xml/strings file, so if you don't have the ownership, just make a copy | |
| // of the spreadsheet to your Google Drive and then execute the export function. | |
| //2. In order to export the xml/strings object, do freeze the first row(select first row, then View -> Freeze -> 1 row) | |
| //3. Select the columns you want to use as string name and value respectively. | |
| //4. You can also select the range you want to export before you trigger the export function. |