In [4]:
import xlrd

In [5]:
import xlwt
import random

In [6]:
shename = 'hello world'
thename = 'what number?'
savename = 'exfceldoc' 
fullsave = savename + '.xls'

In [7]:
#shename = raw_input('What to add: ')
#thename = raw_input('name of worksheet: ')
#savename = raw_input('save file as: ')
#fullsave = savename + '.xls'

In [8]:
whx = random.randint(5,10)

In [9]:
wb = xlwt.Workbook(encoding = 'ascii')
ws = wb.add_sheet(shename)
ws.write(whx, whx, label = thename)

for n in range(whx):
    ws.write(n, n, label=n)
wb.save(fullsave)

In [10]:
writebook = xlrd.open_workbook(fullsave)

print writebook.sheet_names()


[u'hello world']

In [11]:
firstsheet = writebook.sheet_names()[0]

In [12]:
writesheet = writebook.sheet_by_name(firstsheet)
num_rows = writesheet.nrows - 1
curr_row = -1

while curr_row < num_rows:
	curr_row += 1
	row = writesheet.row(curr_row)
	print row


[number:0.0, empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'']
[empty:'', number:1.0, empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'']
[empty:'', empty:'', number:2.0, empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'']
[empty:'', empty:'', empty:'', number:3.0, empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'']
[empty:'', empty:'', empty:'', empty:'', number:4.0, empty:'', empty:'', empty:'', empty:'', empty:'', empty:'']
[empty:'', empty:'', empty:'', empty:'', empty:'', number:5.0, empty:'', empty:'', empty:'', empty:'', empty:'']
[empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', number:6.0, empty:'', empty:'', empty:'', empty:'']
[empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', number:7.0, empty:'', empty:'', empty:'']
[empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', number:8.0, empty:'', empty:'']
[empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', number:9.0, empty:'']
[empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', empty:'', text:u'what number?']

In [13]:
test_rows = writesheet.number
print test_rows


0

In [14]:
writesheet.cell(6,5)


Out[14]:
empty:''

In [14]:


In [14]:


In [ ]:


In [ ]:


In [ ]: