working from my last question I've managed to get a good chunk of the way to get my system finished. Of course I've run across a problem.
I basically have a program that plays a game. Every correct answer adds 10 to the global variable 'points'. Then I want to add 'points' into an excel spreadsheet.
This is where I get very stuck. I'm running XLRD-0.8.0, XLUTILS-1.4.1 and XLWT-0.7.5.
Of course I've looked up different things but they don't seem to work for me.
This is a simplified version of my code:
import pygame, pygame.font, pygame.event, string, xlwt, xlrd, xlutils, socket
points = 0
def Uploadpoints(wbname):
global points
wb = xlrd.open_workbook(wbname)
# CODE TO FIND FIRST EMPTY CELL IN COLUMN 1 GOES HERE
wb.write(row,0,points)
wb.save()
Uploadpoints('workbook1.xls')
I thought of doing something like this but I'm not sure how I would go about it so I post pseudo-code.
Define worksheet: ws = 'sheet 1'
[Done]
Define column: col = 0 [column A]
[Done]
Search for first row in col that is empty: ??? [Not Done]
Define first row that is empty as row: row =
????? [Not Done]
Any help would be greatly appreciated. Thanks in advance.
My answer to this question a few days ago is very relelvant.
Basically whats going wrong is that
xlrd
andxlwt
are different modules with different objects. The object you read in withxlrd.open_workbook()
IS NOT the same object whichxlwt
knows how to write toTo get around this, theres the copy function in
xlutils
.