xls文件加法计算器（文件夹下多文件读取改善）

最新推荐文章于 2023-06-10 12:38:06 发布

Henchyoung

最新推荐文章于 2023-06-10 12:38:06 发布

阅读量274

点赞数 1

分类专栏：学习笔记文章标签： python

本文链接：https://blog.csdn.net/qq_39540224/article/details/102234780

版权

学习笔记专栏收录该内容

21 篇文章 17 订阅

订阅专栏

import os
import xlrd
import xlwt
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)

    path = "C:\\Users\\Administrator\\Desktop\\excel"
    default_dir = "C:/"
    fname = tkinter.filedialog.askdirectory(title=u"选择文件", initialdir=(os.path.expanduser(default_dir)))
    print(fname)
    filenames = os.listdir(path)
    print(filenames)
    for i in filenames:
        if i.find('.xls') > 0:
            print(i)
            excel_path = path + '\\' + i
            print(excel_path)
            fname = excel_path

            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]
                a = a.replace("=","")
                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('求和成功')