old_contents: #!/usr/bin/env python3
  # -*- coding: utf-8 -*-
  
  '''第 0015 题： 纯文本文件 city.txt为城市信息, 里面的内容（包括花括号）如下所示：
  {
      "1" : "上海",
      "2" : "北京",
      "3" : "成都"
  }
  请将上述内容写到 city.xls 文件中。'''
  
  __author__ = 'Drake-Z'
  
  import os
  import re
  from collections import OrderedDict
  import xlwt
  
  def read_data(data, re1, re2):
      c = OrderedDict([])
      re_xuhao = re.compile(r'%s' % re1)            
      re_yuansu = re.compile(r'%s' % re2)            
      a = re_xuhao.findall(data)                      #得到序号
      b = re_yuansu.findall(data)                 #得到具体数据
      for m, n in zip(a, b):                          #将数据转为Dict
          n = re.split(r',', n)
          c[m] = n
      writeFlie(c, hangshu, lieshu)
  
  def writeFlie(dictdata, hangshu, lieshu):
      workbook = xlwt.Workbook(encoding = 'utf-8')                #创建工作薄
      worksheet = workbook.add_sheet('My Worksheet')              #创建表
      num = list(dictdata.keys())                                                    #得到序号
      for i in range(0, hangshu):
          worksheet.write(i, 0, label = num[i])
          for m in range(0, lieshu):
              worksheet.write(i, m+1, label = dictdata[num[i]][m])
      workbook.save('city.xls')
      
  if __name__ == '__main__':
      file = open('city.txt', 'r', encoding='utf-8')
      hangshu = 3
      lieshu = 1
      re1 = '"(.*?)" :'
      re2 = ': "(.*?)"'
      read_data(file.read(), re1, re2)
new_contents: #!/usr/bin/env python3
  # -*- coding: utf-8 -*-
  
  '''第 0015 题： 纯文本文件 city.txt为城市信息, 里面的内容（包括花括号）如下所示：
  {
      "1" : "上海",
      "2" : "北京",
      "3" : "成都"
  }
  请将上述内容写到 city.xls 文件中。'''
  
  __author__ = 'Drake-Z'
  
  import json
  from collections import OrderedDict
  from openpyxl import Workbook
  from openpyxl.styles import Font
  
  def txt_to_xlsx(filename):
      file = open(filename, 'r', encoding = 'UTF-8')
      file_cintent = json.load(file, encoding = 'UTF-8')
      print(file_cintent)
      workbook = Workbook()
      worksheet = workbook.create_sheet(title = 'city')
      for i in range(1, len(file_cintent)+1):
          worksheet.cell(row = i, column = 1).value = i
          worksheet.cell(row = i, column = 2).value = file_cintent[str(i)]
      workbook.save(filename = 'city.xls')
  
  if __name__ == '__main__':
      txt_to_xlsx('city.txt')
subject: Fix 0015