python关于#excel#的问题，如何解决？

Question

调试程序
a.py

import sys
from tkinter import *
from tkinter import filedialog


def select():
    filename = filedialog.askopenfilename()
    if filename != '':
        path.set(filename)


def bring():
    global b1, b2, b3
    b1 = inp1.get()
    b2 = inp2.get()
    b3 = inp3.get()
    print(b1)
    print(b2)
    print(b3)
    return None


def end():
    sys.exit(0)


# 图形化界面
root = Tk()
root.title('明源云客报备')
root.geometry('500x400')
path = StringVar()
a1 = StringVar()
a2 = StringVar()
b1, b2, b3 = None, None, None
lb1 = Label(root, text='账号', relief=RAISED)
lb1.place(relx=0.05, rely=0.1, relwidth=0.4, relheight=0.1)
inp1 = Entry(root, textvariable=a1)
inp1.place(relx=0.5, rely=0.1, relwidth=0.4, relheight=0.1)
lb2 = Label(root, text='密码', relief=RAISED)
lb2.place(relx=0.05, rely=0.25, relwidth=0.4, relheight=0.1)
inp2 = Entry(root, textvariable=a2)
inp2.place(relx=0.5, rely=0.25, relwidth=0.4, relheight=0.1)
inp3 = Entry(root, textvariable=path)
inp3.place(relx=0.5, rely=0.4, relwidth=0.4, relheight=0.1)
btn1 = Button(text='请选择源文件', command=select)
btn1.place(relx=0.05, rely=0.4, relwidth=0.4, relheight=0.1)
btn2 = Button(root, text='开始', command=bring)
btn2.place(relx=0.05, rely=0.55, relwidth=0.4, relheight=0.1)
btn3 = Button(root, text='结束', command=end)
btn3.place(relx=0.5, rely=0.55, relwidth=0.4, relheight=0.1)
msg1 = Message(root, relief=SUNKEN)
msg1.place(relx=0.05, rely=0.7, relwidth=0.85, relheight=0.25)
root.mainloop()

b.py

import time
import pandas as pd
from front import *
from pandas import DataFrame
from selenium import webdriver
from selenium.webdriver.common.by import By

# 读取excel
df: DataFrame = pd.read_excel(b3)
print(df)

b.py 传递a.py的值 打印出文件内容

Answer 1

a:

import sys
from tkinter import *
from tkinter import filedialog
import subprocess
 
def select():
    filename = filedialog.askopenfilename()
    if filename != '':
        path.set(filename)
 
 
def bring():
    global b1, b2, b3
    b1 = inp1.get()
    b2 = inp2.get()
    b3 = inp3.get()
    print(b1)
    print(b2)
    print(b3)
    subprocess.Popen(['python', 'b.py', b3])
    return None
 
 
def end():
    sys.exit(0)
 
 
# 图形化界面
root = Tk()
root.title('明源云客报备')
root.geometry('500x400')
path = StringVar()
a1 = StringVar()
a2 = StringVar()
b1, b2, b3 = None, None, None
lb1 = Label(root, text='账号', relief=RAISED)
lb1.place(relx=0.05, rely=0.1, relwidth=0.4, relheight=0.1)
inp1 = Entry(root, textvariable=a1)
inp1.place(relx=0.5, rely=0.1, relwidth=0.4, relheight=0.1)
lb2 = Label(root, text='密码', relief=RAISED)
lb2.place(relx=0.05, rely=0.25, relwidth=0.4, relheight=0.1)
inp2 = Entry(root, textvariable=a2)
inp2.place(relx=0.5, rely=0.25, relwidth=0.4, relheight=0.1)
inp3 = Entry(root, textvariable=path)
inp3.place(relx=0.5, rely=0.4, relwidth=0.4, relheight=0.1)
btn1 = Button(text='请选择源文件', command=select)
btn1.place(relx=0.05, rely=0.4, relwidth=0.4, relheight=0.1)
btn2 = Button(root, text='开始', command=bring)
btn2.place(relx=0.05, rely=0.55, relwidth=0.4, relheight=0.1)
btn3 = Button(root, text='结束', command=end)
btn3.place(relx=0.5, rely=0.55, relwidth=0.4, relheight=0.1)
msg1 = Message(root, relief=SUNKEN)
msg1.place(relx=0.05, rely=0.7, relwidth=0.85, relheight=0.25)
root.mainloop()

b:

import time
import pandas as pd
from pandas import DataFrame
from selenium import webdriver
from selenium.webdriver.common.by import By
import sys

if len(sys.argv) != 2:
    print("Usage: python b.py [Excel file path]")
    sys.exit(1)

# 读取excel
df: DataFrame = pd.read_excel(sys.argv[1])
print(df)