How to add data using python from one sheet to an existing sheet in another workbook without overwriting other sheet's data?

Question

I have an two excel files 'file1' and 'file2'. file1 has data filled in 3 sheets. I want to copy data from file2 and append it into sheet3 in file1 and save the same file. Can anyone help me do this using python?

score 2 · Answer 1 · edited May 23 '17 at 11:43

2

xlwt is used to write into existing files.

Here is the similar thread to your question. . .

writing to existing workbook using xlwt

edited May 23 '17 at 11:43

Community

1
1

answered May 30 '13 at 10:00

SaravanaKumar

739
1
7
17

score 0 · Answer 2 · answered May 30 '13 at 09:59

0

If you are using Windows, you can try PyWin32 to directly run Excel.

from win32com.client import Dispatch
xlApp = Dispatch("Excel.Application")
...

Some recipes here.

NOTE: You will need to install PyWin32 binary.

answered May 30 '13 at 09:59

Cyrille

13,905
2
22
41

How to add data using python from one sheet to an existing sheet in another workbook without overwriting other sheet's data?

2 Answers2