CODEWITHSUNDEEP
python-3.xpandas
Mustafa Uçar
Mustafa Uçar

Reputation: 432

After insert data to column in pandas, deletes all other sheets

I want to insert a list to existing excel sheet and column. I insert the list to the column but after saving the changes it deletes all other sheets because I use to_excel:

mysel = [2000, 1, 1, 2018, 1, 1]
xl = pd.ExcelFile('C:\HT_Projeler\mm\HidrolojiModeli\proje.xlsx')
df = xl.parse("Sheet1")

df
   Model Giridisi  Değer
0  Başlangıç Yılı   nan
1  Başlangıç  Ayı   nan
2  Başlangıç Günü   nan
3      Bitiş Yılı   nan
4       Bitiş Ayı   nan
5      Bitiş Günü   nan

df["Değer"] = mysel
df.to_excel(xl)

How can I edit or insert list only specific column in specific sheet?

Upvotes: 0

Views: 196

Answers (1)

anky
anky

Reputation: 75110

Use:

mysel = [2000, 1, 1, 2018, 1, 1]
xl = pd.ExcelFile('C:\HT_Projeler\mm\HidrolojiModeli\proje.xlsx')
df = xl.parse("Sheet1")
df["Değer"] = mysel
import pandas
from openpyxl import load_workbook

book = load_workbook('C:\HT_Projeler\mm\HidrolojiModeli\proje.xlsx')
writer = pandas.ExcelWriter('C:\HT_Projeler\mm\HidrolojiModeli\proje.xlsx', engine='openpyxl') 
writer.book = book
writer.sheets = dict((ws.title, ws) for ws in book.worksheets)

df.to_excel(writer, "Sheetname",index=False)

writer.save()

Upvotes: 1

Related Questions