刚开始学习python,结合xlrd一些excel的库试着写了一个小的excel加发计算器。
xls文件加法计算器说明
1、仅可对.xls类型的excel文件进行加法计算;
2、excel文件内初始格式如下:为“1+2”的形式或者“1+2=”的形式;
3、双击exe文件运行,选择需要计算的excel文件路径,双击文件选择,然后程序运行结束并退出,得到计算结果
源码:
import os
import xlrd
from xlutils.copy import copy
import tkinter.filedialog
def plus_excel():
default_dir = "C:/"
fname = tkinter.filedialog.askopenfilename(title=u"选择文件",initialdir=(os.path.expanduser(default_dir)))
print(fname)
dictplus = {}
workbook = xlrd.open_workbook(fname)
workbooknew = copy(workbook)
ws = workbooknew.get_sheet(0)
sheet_name = workbook.sheet_names()[0]
sheet = workbook.sheet_by_index(0)
print(sheet.name, sheet.nrows, sheet.ncols)
suanshi = sheet.col_values(0)
i = 0
while i < sheet.nrows:
print(suanshi[i])
a = suanshi[i]
print(a)
x = a.split('+')
print(x)
dictplus[i] = int(x[0]) + int(x[1])
print(dictplus)
ws.write(i, 1, dictplus[i])
i = i + 1
workbooknew.save(fname)
if __name__ == '__main__':
plus_excel()
print('读取成功')
print('求和成功')