Add new rows to existing column of excel in python

Question

I want to add new records every week to this existing file without creating a new one.

For example, Next I want to add record on date 6/13/2016

Randy->(13,23,13)

Shaw->(13,15,13)

and many such entries next two months. How do I do that? I am beginner so having trouble to put it in syntax.

I could do only this much

import xlrd

#Opening the excel file
file_location= "C:/Users/agodgh1a/Desktop/Apurva/EPSON.xlsx"
workbook= xlrd.open_workbook(file_location)
sheet=workbook.sheet_by_index(0)

Thank you!

keredson · Accepted Answer · 2017-07-05 20:43:06Z

2

The lib you're using looks like it only reads, not edits. Here's an example in openpyxl:

from openpyxl import Workbook, load_workbook

# create the file
wb = Workbook()
ws = wb.active
ws.append([1, 2, 3])
wb.save("sample.xlsx")

# re-open and append
wb = load_workbook("sample.xlsx")
ws = wb.active
ws.append([4, 5, 6])
wb.save("sample.xlsx")

Run that and you'll have a file sample.xlsx with both rows.

answered Jul 5, 2017 at 20:43

keredson

3,1071 gold badge20 silver badges21 bronze badges

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

Comments

Aman Raparia · Accepted Answer · 2017-07-05 20:48:24Z

1

xlrd

is for reading operations only. Since you want perform a write operation use xlwt python module.

Refer to xlwt docs for the same

answered Jul 5, 2017 at 20:48

Aman Raparia

5031 gold badge5 silver badges14 bronze badges

Collectives™ on Stack Overflow

Add new rows to existing column of excel in python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related