Page MenuHomeDevCentral

No OneTemporary

diff --git a/tools/spreadsheet2json b/tools/spreadsheet2json
index ff122b7..af2db2a 100755
--- a/tools/spreadsheet2json
+++ b/tools/spreadsheet2json
@@ -1,36 +1,36 @@
#!/usr/bin/env python3
#
# Converts key/value lines from a spreadsheet to a JSON object:
# 1. create a spreadsheet with two columns, one for keys, one for values
# 2. copy paste into a text file (or save as a file delimited with tabs)
# 3. `spreadsheet2json neko.dat > neko.json`
import collections
import json
import sys
import os.path
# Parses arguments
if len(sys.argv) < 2:
print("Usage: spreadsheet2json <some-copy-paste-of-a-spreadsheet.dat>")
sys.exit(1)
source = sys.argv[1]
if not os.path.exists(source):
print("File not found:", source)
sys.exit(2)
# Reads tabular data file and produce JSON
-with open(source, "r") as file:
+with open(source, "r") as translations_file:
translations = {}
- for line in file:
+ for line in translations_file:
record = line.rstrip().split('\t')
translations[record[0]] = record[1]
# Sorted JSON output
sorted_translations = collections.OrderedDict(sorted(translations.items()))
json = json.dumps(sorted_translations, indent=4)
print(json)

File Metadata

Mime Type
text/x-diff
Expires
Sat, Nov 7, 20:58 (1 w, 3 d ago)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
4249846
Default Alt Text
(1 KB)

Event Timeline