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 [ ]: