Python的Excel文件和Txt文件的互转
PS: 也是从网上各个帖子中学习的Python,因此代码的格式以及内容有粘贴网上其他大神的代码,如有侵权请告知删除
Txt 2 Excel 示例图片
import xlwt
from tkinter import *
import tkinter.filedialog
root = Tk()
root.title('Txt To Excel')
root.geometry('300x200')
FileName1 = ""
FileName2 = ""
def Button1Anwser():
global FileName1
Path = Label(root, text='')
FileName1 = tkinter.filedialog.askopenfilename()
Path.config(text=FileName1)
Path.grid(row=1, column=0, sticky=W)
def Button2Anwser():
global FileName2
Path = Label(root, text='')
FileName2 = tkinter.filedialog.askopenfilename()
Path.config(text=FileName2)
Path.grid(row=3, column=0, sticky=W)
def Start():
Read_File = open(FileName1)
Write_File = xlwt.Workbook()
Table = Write_File.add_sheet('Value', cell_overwrite_ok=True)
Excel_Row = 0
Excel_Column = 0