Copying and renaming excel files with Python

Question

I am trying to copy an excel file and rename it. For example I have a file HI.xlsx and I want to copy it and rename it as BYE.xlsx.
My code to do this is below and when I run it, the file BYE.xlsx is created, but it is corrupted.

Here is what I am using:

fIn = open(r"HI.xlsx")
fOut = open(r"BYE.xlsx", "w")

http://stackoverflow.com/questions/123198/how-do-i-copy-a-file-in-python — crow_t_robot, Dec 18 '15 at 14:42

score 13 · Accepted Answer · edited Dec 18 '15 at 14:52

13

You should be using shutil.copy():

shutil.copy("HI.xlsx", "BYE.xlsx")

edited Dec 18 '15 at 14:52

Padraic Cunningham

176,452
29
245
321

answered Dec 18 '15 at 14:41

DeepSpace

78,697
11
109
154

Copying and renaming excel files with Python

1 Answers1