how to append particular excel cell value using python?

Question

cell (1,1) should have "Put me in same cell":

import xlwt
book = xlwt.Workbook()
sheet = book.add_sheet('Sheet1')
sheet.write(1, 1, "Put me")
n=10
if n>0: 
    sheet.write(1, 1, "in same cell")

What library is that? What does it write instead of the expected result? — bereal, Jun 18 '14 at 11:50
Exception: Attempt to overwrite cell: sheetname=u'sheet1' rowx=1 colx=1 — Rahul, Jun 18 '14 at 12:01

score 0 · Accepted Answer · edited May 23 '17 at 10:25

0

Thats the default xlwt behavior, you can either override that with

sheet = book.add_sheet('Sheet1', cell_overwrite_ok=True)

(taken from this answer) That will only overwrite the original value Put me, though.

You'll have to merge the values manually, like this:

from cStringIO import StringIO

sheet = book.add_sheet('Sheet1')
buf = StringIO()
buf.write('Put me')
if some_condition:
   buf.write(' in same cell')

sheet.write(1, 1, buf.getvalue())

edited May 23 '17 at 10:25

Community

1
1

answered Jun 18 '14 at 12:18

bereal

32,519
6
58
104

can you tell me how to add these two values with different formating. Like 'Put me' (in blue colour) and 'in same cell' (in red colour) – Rahul Jun 19 '14 at 07:38
could you be more specific? – bereal Jun 19 '14 at 07:39
i hv edited my comment above. did you got it or should i explain my question more? – Rahul Jun 19 '14 at 07:43
No, sorry, I don't know how to deal with colors in xlwt. – bereal Jun 19 '14 at 07:45
@Rahul Did you get any answers for your color related query in xlwt? – FRECEENA FRANCIS Jul 26 '21 at 11:45

score 0 · Answer 2 · answered Jun 18 '14 at 13:20

try openpyxl, this works for me:

from openpyxl import Workbook


def append_to_cell(location,text,sheet):
    new = sheet.cell(location).value+text
    sheet.cell(location).value=new

    return 

file_name='example.xlsx'
cell='A1'
wb = Workbook()
ws = wb.create_sheet()
ws.title = 'test Sheet'
ws.cell(cell).value = 'write this '
append_to_cell(cell,'in same cell',ws)
wb.save(filename=file_name)

how to append particular excel cell value using python?

2 Answers2