强制python脚本不等待vba宏终止

Question

我从python脚本运行一个很长的excel VBA宏(大约10-15分钟)。我想为最终用户制作一个进度条。为了从宏到python脚本进行通信，我尝试在txt文件中写入来自VBA宏的进度百分比，并将该数字插入到我的.py中的progressBar (用Qt完成)中。问题是: py脚本等待宏完成读取.txt文件值。我正在寻找一种方法来强制Python转到下一个命令，而不是等待宏完成。下面是我用过的.py

from PyQt4 import QtGui, QtCore
import sys

import progress
import win32com.client

class Progress(QtGui.QDialog, progress.Ui_Progress):
    def __init__(self, parent=None):
        super(Progress, self).__init__(parent)
        self.setupUi(self)
        self.progressBar.setValue(0)

    def main(self):
        self.show()

    def evolution(self, a):
        self.progressBar.setValue(a)

if __name__=='__main__':
    app = QtGui.QApplication(sys.argv)
    progress = Progress()
    progress.main()
    xl=win32com.client.Dispatch("Excel.Application")
    xl.Workbooks.Open(Filename="filename",ReadOnly=1)
    xl.Application.ScreenUpdating = False
    xl.Application.Run("myscript")
    while a < 100
        file = open('newfile.txt', 'r')
        a = int(file.read())
        progress.evolution(a)
        file.close()
    app.exec_()


def main():
    pass

Answer 1

为什么不创建一个用户窗体作为进度条，您可以从Excel VBA代码中直接调用它？

http://www.ehow.com/how_7764247_create-progress-bar-vba.html

Answer 2

如果您不想像其他人建议的那样在VB脚本中创建进度条，则应该使用线程。我认为更改VBA是一个更好的主意，但如果您真的出于某些原因而反对，下面的更改应该会起作用：

import threading
import time
... # imports, progress class unchanged

# probably want to add arguments to make generic, but not required
def run_vba_script():
    xl=win32com.client.Dispatch("Excel.Application")
    xl.Workbooks.Open(Filename="filename",ReadOnly=1)
    xl.Application.ScreenUpdating = False
    xl.Application.Run("myscript")

if __name__=='__main__':
    app = QtGui.QApplication(sys.argv)
    progress = Progress()
    progress.main()

    vb_thread = threading.Thread(target=run_vba_script)
    vb_thread.start()

    while vb_thread.is_alive():
        file = open('newfile.txt', 'r')
        a = int(file.read())
        progress.evolution(a)
        file.close()
        # only check once a second to not eat your file system and processor alive
        time.sleep(1)
    app.exec_()