-
大小: 8.33MB文件類型: .rar金幣: 2下載: 0 次發(fā)布日期: 2023-10-16
- 語(yǔ)言: Python
- 標(biāo)簽: 記賬系統(tǒng)??excel導(dǎo)出??python??便捷錄入??
資源簡(jiǎn)介
為家里人做的一個(gè)簡(jiǎn)單的錄入生成小工具,錄完之后自動(dòng)生成excel,附帶編譯好的exe文件,代碼也公開,歡迎相互學(xué)習(xí)指導(dǎo)

代碼片段和文件信息
#?-*-?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ǐng)輸入\‘q\‘,否則請(qǐng)輸入時(shí)間:“)
????????else:
????????????print(“退出請(qǐng)輸入\‘q\‘,否則輸入時(shí)間,如果時(shí)間和之前相同,請(qǐng)輸入?\‘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(“輸入數(shù)據(jù):“)
????????input_num?=?input()
????????print(“-----------------------------------------------------“)
????????print(“請(qǐng)確認(rèn)輸入的數(shù)據(jù)是否準(zhǔn)確:Y?or?N“)
????????print?(“\n\n\n\n“)
????????print(“******************************************************“)
????????print(“|時(shí)間:“?+?date?+?“??|?種類:“?+?data_kind[int(chose_num)?-?1]?+?“?|?數(shù)量:“?+?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(‘?。。。。ARNING:剛才的數(shù)據(jù)沒(méi)有保存,請(qǐng)注意?。。。?!‘)
????????????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(“是否繼續(xù)之前的數(shù)據(jù)進(jìn)行操作?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
?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----
?????文件?????????45??2020-05-14?11:10??python記賬小工具\(yùn)price.txt
?????文件???????5316??2020-05-25?10:22??python記賬小工具\(yùn)scratch_1.py
?????文件????8956009??2020-05-25?10:26??python記賬小工具\(yùn)賬單錄入小工具V1.4.exe
?????目錄??????????0??2020-07-10?11:26??python記賬小工具
-----------?---------??----------?-----??----
??????????????8961370????????????????????4
評(píng)論
共有 條評(píng)論