"""
问题:纯文本文件 student.txt为学生信息, 里面的内容(包括花括号)如下所示:
{
"1":["张三",150,120,100],
"2":["李四",90,99,95],
"3":["王五",60,66,68]
}
请将上述内容写到 student.xls
workbook相关:
1、http://www.lfd.uci.edu/~gohlke/pythonlibs/下载 openpyxl-2.3.2-py2.py3-none-any.whl,
和其他两个支持库 et_xmlfile-1.0.1-py2.py3-none-any.whl jdcal-1.2-py2.py3-none-any.whl
2、使用命令pip install 进行安装
"""
from openpyxl.workbook import Workbook
from openpyxl.writer.excel import ExcelWriter
def getdata():
f = open('d://student.txt').read()
d = eval(f)
savefile(d)
def savefile(d):
wb = Workbook()
ew = ExcelWriter(workbook=wb)
filepath = 'd://student.xlsx'
ws = wb.worksheets[0]
row = 1
for k, v in d.items():
print('%s:%s' % (k, v))
ws.cell(row=row, column=1, value=k)
for vi in range(len(v)):
ws.cell(row=row, column=vi + 1, value=v[vi])
row += 1
ew.save(filepath)
if __name__ == '__main__':
getdata()
"""
问题:纯文本文件 city.txt为城市信息, 里面的内容(包括花括号)如下所示:
{
"1" : "上海",
"2" : "北京",
"3" : "成都"
}
请将上述内容写到 city.xls 文件中,如下图所示:
"""
from openpyxl.workbook import Workbook
from openpyxl.writer.excel import ExcelWriter
def getdata():
f = open('d://city.txt').read()
d = eval(f)
savefile(d)
def savefile(d):
wb = Workbook()
ew = ExcelWriter(workbook=wb)
filepath = 'd://city.xlsx'
ws = wb.worksheets[0]
row = 1
for k, v in d.items():
print('%s:%s' % (k, v))
ws.cell(row=row, column=1, value=k)
ws.cell(row=row, column=2, value=v)
row += 1
ew.save(filepath)
print('保存成功')
if __name__ == '__main__':
getdata()
"""
问题:纯文本文件 numbers.txt为城市信息, 里面的内容(包括花括号)如下所示:
[
[1, 82, 65535],
[20, 90, 13],
[26, 809, 1024]
]
请将上述内容写到 numbers.xls 文件中,如下图所示:
"""
from openpyxl.workbook import Workbook
from openpyxl.writer.excel import ExcelWriter
def getdata():
f = open('d://numbers.txt').read()
d = list(eval(f))
savefile(d)
def savefile(data):
wb = Workbook()
ew = ExcelWriter(workbook=wb)
filepath = 'd://numbers.xlsx'
ws = wb.worksheets[0]
row = 1
for i in range(len(data)):
linedata = data[i]
c = 1
for vi in range(len(linedata)):
ws.cell(row=row, column=c, value=str(linedata[vi]))
c += 1
row += 1
ew.save(filepath)
print('保存成功')
if __name__ == '__main__':
getdata()