資源簡介
為家里人做的一個簡單的錄入生成小工具,錄完之后自動生成excel,附帶編譯好的exe文件,代碼也公開,歡迎相互學習指導

代碼片段和文件信息
#?-*-?coding:?utf-8?-*-
import?xlsxwriter
import?time
price_all?=?{}
data_kind?=?[]
data_all?=?{}
line_total?=?0
price_filename?=?‘price.txt‘
before_date_filename?=?‘before_date.txt‘
with?open(price_filename?‘r‘?encoding=‘UTF-8‘)?as?f:
????for?line?in?f:
????????date_temp?=?line.split(“:“?1)
????????price_all[date_temp[0]]?=?int(date_temp[1])
print(price_all)
def?dump_kinds():
????j?=?0
????print(“選擇種類:“)
????for?kind?in?price_all:
????????data_kind.append(kind)
????????j?=?j?+?1
????????print(str(j)?+?“:“?+?kind)
date_before?=?‘‘
def?write_data():
????global?data_all?date_before
????while?True:
????????print(“--------------賬單錄入中-----------------“)
????????if?date_before?==?‘‘:
????????????print(“退出請輸入\‘q\‘,否則請輸入時間:“)
????????else:
????????????print(“退出請輸入\‘q\‘,否則輸入時間,如果時間和之前相同,請輸入?\‘s\‘:“)
????????date?=?input()
????????if?date?==?‘q‘:?break
????????if?date?==?‘‘:?continue
????????if?date?==?‘s‘:
????????????date?=?date_before
????????date_before?=?date
????????print(“-----------------------------------------------------“)
????????dump_kinds()
????????chose_num?=?input()
????????print(“-----------------------------------------------------“)
????????print(“輸入數據:“)
????????input_num?=?input()
????????print(“-----------------------------------------------------“)
????????print(“請確認輸入的數據是否準確:Y?or?N“)
????????print?(“\n\n\n\n“)
????????print(“******************************************************“)
????????print(“|時間:“?+?date?+?“??|?種類:“?+?data_kind[int(chose_num)?-?1]?+?“?|?數量:“?+?input_num?+?“|“)
????????print(“******************************************************“)
????????print?(“\n\n\n\n“)
????????sure_flag?=?input()
????????data_num_temp?=?0
????????if?sure_flag?==?‘y‘?or?sure_flag?==?‘Y‘:
????????????if?date?in?data_all:
????????????????if?chose_num?in?data_all[date]:
????????????????????data_num_temp?=?data_all[date][chose_num]
????????????????data_info?=?{chose_num:?eval(input_num)?+?data_num_temp}
????????????????data_all[date].update(data_info)
????????????else:
????????????????data_all[date]?=?{chose_num:?eval(input_num)}
????????else:
????????????print?(“\n“)
????????????print(‘######################################################‘)
????????????print(‘!!!!!WARNING:剛才的數據沒有保存,請注意?。。。。 ?br/>????????????print(‘######################################################‘)
????????????print?(“\n“)
????????print(data_all)
????????with?open(before_date_filename?‘w‘?encoding=‘UTF-8‘)?as?f:
????????????f.write(str(data_all))
????????????f.close()
def?continue_check():
????try:
????????f?=?open(before_date_filename)
????????f.close()
????except?IOError:
????????return
????while?True:
????????print(“是否繼續之前的數據進行操作?Y?or?N“)
????????continue_flag?=?input()
????????if?continue_flag?==?‘y‘?or?continue_flag?==?‘Y‘:
????????????global?data_all?line_total
????????????with?open(before_date_filename?‘r‘?encoding=‘UTF-8‘)?as?f:
????????????????lines?=?f.readline
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件?????????45??2020-05-14?11:10??python記賬小工具\price.txt
?????文件???????5316??2020-05-25?10:22??python記賬小工具\scratch_1.py
?????文件????8956009??2020-05-25?10:26??python記賬小工具\賬單錄入小工具V1.4.exe
?????目錄??????????0??2020-07-10?11:26??python記賬小工具
-----------?---------??----------?-----??----
??????????????8961370????????????????????4
評論
共有 條評論