Question posted 2011 · +3 upvotes
I am using ‘xlwt’ to write into Excel files as part of my project in Python. I also need to actually open the Excel spreadsheet for display and also close it. I found a function:
import webbrowser
webbrowser.open('C:/Users/300231823/Desktop/GUI/simplenew4.xls')
This seems to open the .xls file. How do I close the file?
I am completely new to programming, and I started using Python 3 weeks ago.
Accepted answer +7 upvotes
from win32com.client import Dispatch
xl = Dispatch("Excel.Application")
xl.Visible = True # otherwise excel is hidden
# newest excel does not accept forward slash in path
wb = xl.Workbooks.Open(r'C:Users300231823DesktopGUIsimplenew4.xls')
wb.Close()
xl.Quit()
The win32com module is part of pywin32.
Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
.