Python Win32, how to save an XLS as a CSV?

Question

I'm loading up a .xlsx with win32com and would like to save the results as a csv when I'm done.

myworkbook.SaveAs('results.csv')

gives me an xlsx file with a csv extension. How do I save as an actual CSV?

Daniel Haley · Accepted Answer · 2011-05-31 17:02:29Z

4

I think that if you add the type after the filename, it should work. (Can't test right now.)

I think the type for CSV (DOS) is 24.

myworkbook.SaveAs('results.csv', 24)

answered May 31, 2011 at 17:02

Daniel Haley

53.1k7 gold badges75 silver badges97 bronze badges

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

1 Comment

JAB Over a year ago

I thought the value for xlCSV is 6.

Gerrat · Accepted Answer · 2011-05-31 17:19:16Z

4

Here are the docs for saveAs: http://msdn.microsoft.com/en-us/library/bb214129.aspx

from win32com.client import constants as c
myWorkBook.SaveAs('results.csv', c.xlCSV)

answered May 31, 2011 at 17:19

Gerrat

29.9k9 gold badges78 silver badges104 bronze badges

2 Comments

rleelr Over a year ago

If the file already exists, then Excel will show a pop-up window. Is there a way to deal with this, or direct the function to always overwrite?

rleelr Over a year ago

You can set xl.DisplayAlerts = False beforehand and Excel will just overwrite the file.

circus · Accepted Answer · 2011-05-31 17:23:07Z

3

You have to specify the type after the filename.

For CSV the following modes are available:

xlCSV = 6         # Comma separated value.
xlCSVMac = 22,    # Comma separated value.
xlCSVMSDOS = 24,  # Comma separated value.
xlCSVWindows =23, # Comma separated value.

Available file formats can be fond here, the spec of the saveAs method can be found here. Even as there is no example for python, the parameters and values should be the same.

answered May 31, 2011 at 17:23

circus

2,6403 gold badges23 silver badges25 bronze badges

Comments

Wes McKinney · Accepted Answer · 2011-05-31 16:58:20Z

1

I have not used this library but it might be worth giving a shot:

http://pypi.python.org/pypi/ooxml

answered May 31, 2011 at 16:58

Wes McKinney

106k32 gold badges146 silver badges109 bronze badges

1 Comment

Jason Goldstein Over a year ago

I need to load a plugin, so a regular xlsx parsing library is no-go. win32com does what I need, the problem is the SaveAs method docstring is unclear.

Collectives™ on Stack Overflow

Python Win32, how to save an XLS as a CSV?

4 Answers 4

1 Comment

2 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related