I am creating a Python script where it does a bunch of tasks and one of those tasks is to launch and open an instance of Excel. What is the ideal way of accomplishing that in my script?
Opening files To open a file using the Python OS module, you need to import the OS module, then call the system() method and pass it the path of your file. It's important to recognize that the system() command doesn't open a file behind the scenes for reading or writing (file I/O).
While the Popen
answers are reasonable for the general case, I would recommend win32api
for this specific case, if you want to do something useful with it:
It goes something like this:
from win32com.client import Dispatch
xl = Dispatch('Excel.Application')
wb = xl.Workbooks.Open('C:\\Documents and Settings\\GradeBook.xls')
xl.Visible = True # optional: if you want to see the spreadsheet
Taken from a mailing list post but there are plenty of examples around.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With