excel - using "ws.cell(row = row, column = columnl).value = looprow" removes previous data saved in python -

can please me i'm new openpyxl.

when use "ws.cell(row = row, column = columnl).value = looprow" removes previous data saved.

here's code.

import openpyxl  wb = openpyxl.workbook() ws = wb.active  looprow = 1 in range(1 , 10):     writetocell = 3     ws.cell(row = looprow, column = writetocell).value = looprow     wb.save("/home/richard/desktop/sample.xlsx")     looprow += 1 

what i'm trying update sample.xlsx not overwrite. deletes data column , b add data column c, i'm trying retain data of column , b add data column c. in advance have pictures can't post lacking reputation

the problem not using same excel. creating new excel , replacing in old excel position .

in following program have read teh same excel made changes excel , have override excel new one

code:

from openpyxl.reader.excel import load_workbook wb=load_workbook("/home/richard/desktop/sample.xlsx") ws=wb.get_active_sheet() looprow = 1 in range(1 , 10):     writetocell = 3     ws.cell(row = looprow, column = writetocell).value = looprow     looprow += 1  wb.save("/home/richard/desktop/sample.xlsx")