How to open a csv file in Microsoft Excel in Python?

Question

base_path = os.path.dirname(os.path.abspath(__file__))          
_csvFilename = os.path.join(base_path, "bcForecasting.csv")
_csvFile = open (_csvFilename, 'wb')
_csvFile = csv.writer(_csvFile, quoting=csv.QUOTE_ALL)

_Header = self.makeIntoList (self.root.tss.series () [0].getAllTimes (), self.originalTimesteps + _futurePeriods)
_csvFile.writerow (_Header)

Now I want to open the created bcForecasting.csv file in Excel. How to do it in Python?

I know how to open a csv file in Excel, and how to open a csv file in Python, but what does it mean to open a csv file "in Microsoft Excel in Python"? Do you want Python to tell Excel (starting it up if it isn't running) to open the sheet? [Aside: you didn't close the file. It's usually a better idea to use the with statement.] — DSM
– DSM, Commented Aug 11, 2013 at 16:15
Hello DSM , yes actually I "want Python to tell Excel (starting it up if it isn't running) to open the sheet". Actually I am closing the file here I have not provided the full code. Thanks — curiousguy
– curiousguy, Commented Aug 11, 2013 at 16:19
Ah, then the linked question has the answer. The win32com module will work (I've used it myself to script PowerPoint.) — DSM
– DSM, Commented Aug 11, 2013 at 16:22
Hello I dont know why it is not opening for me , though I can see in the task manager that EXCEL.exe is running , also I cant delete the file as it is giving an alert "File is now available for editing" — curiousguy
– curiousguy, Commented Aug 11, 2013 at 17:46

Saullo G. P. Castro · Accepted Answer · 2013-08-12 12:22:27Z

8

Usually on Windows the .csv filetype is configured to be opened by Excel. In this case you can just do:

from subprocess import Popen
p = Popen('filename.csv', shell=True)

In case it does not work, try pointing the full path of the Excel application:

subprocess.Popen(r'C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE stack.csv')

answered Aug 12, 2013 at 12:22

Saullo G. P. Castro

59.4k28 gold badges191 silver badges244 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Noumenon Over a year ago

Beware that opening a CSV in Excel may drop leading 0s from numeric fields like zip codes. Import with Data > From Text to avoid this.

rajat · Accepted Answer · 2019-04-23 19:46:48Z

3

You can use the 'startfile' command from the os library.

import os
os.startfile('filename.csv')

Do make sure to specify the path of the file or to set the working directory to the path where the file is located.

answered Apr 23, 2019 at 19:46

rajat

311 bronze badge

2 Comments

ZF007 Over a year ago

As the correct answer was given almost a millennia ago.. you should let the reader know which version of python you refer with your answer and why you should this method instead of the Popen variant.

Andy Lynch Over a year ago

@rajat is right - this has been about since Python 2.0, it uses the Windows shell association to launch the file (has the same effect as double-clicking the file in Windows Explorer), and avoids the overhead/ security concerns of using Popen and cmd in this way (see docs.python.org/2/library/… )

tomglynch · Accepted Answer · 2020-11-11 03:31:20Z

0

On a mac, use the following:

import os
os.system('open filename.csv')

Make sure to specify the path of the file or to set the working directory to the path where the file is located.

answered Nov 11, 2020 at 3:31

tomglynch

1,8761 gold badge13 silver badges15 bronze badges

Collectives™ on Stack Overflow

How to open a csv file in Microsoft Excel in Python?

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related