I have to write a value of MW of many lines to a particular cell in my csv file. I can see there is a csvwriter.writerow(row) method to write an entire row, but I am not seeing anything to write a value to a particular cell.
The csv.writer object is an improved version of this simple code:
data = [('Bus Number', 'MW'),
('3', '20.4'),
('4', '20.5')]
csvfile = open('generation.csv', 'wb')
for row in data:
line = ','.join(row)
csvfile.write(line + '\n')
See how it writes each row line by line? There isn't a way to change one character without re-writing the whole file.
The way to change a particular cell
Change the cell in your data variable. For example, you'd like to change B3 in the data variable above from '20.5' to '20.6'. Then re-write the file.
# row 3, column 2
data[2][1] = '20.6'
writer = csv.writer(open('generation.csv', 'wb'))
writer.writerows(data)
Comments