In [1]:

    

import xlwt


    

In [2]:

    

wb = xlwt.Workbook()


    

In [3]:

    

print(type(wb))


    

    




<class 'xlwt.Workbook.Workbook'>

In [4]:

    

sheet = wb.add_sheet('sheet1')


    

In [5]:

    

print(type(sheet))


    

    




<class 'xlwt.Worksheet.Worksheet'>

In [6]:

    

sheet.write(0, 0, 'A')
sheet.write(0, 1, 'B')
sheet.write(1, 0, 10)
sheet.write(1, 1, 20)


    

In [7]:

    

# sheet.write(0, 0, 'A')
# Exception: Attempt to overwrite cell: sheetname='sheet1' rowx=0 colx=0


    

In [8]:

    

wb.save('data/dst/xlwt_sample.xls')


    

In [9]:

    

sheet2 = wb.add_sheet('sheet2')


    

In [10]:

    

def write_list_1d(sheet, l, start_row, start_col):
    for i, val in enumerate(l):
        sheet.write(start_row, start_col + i, val)


    

In [11]:

    

def write_list_2d(sheet, l_2d, start_row, start_col):
    for i, l in enumerate(l_2d):
        write_list_1d(sheet, l, start_row + i, start_col)


    

In [12]:

    

l_2d = [['A', 'B', 'C'], [1, 2, 3]]
write_list_2d(sheet2, l_2d, 1, 2)


    

In [13]:

    

wb.save('data/dst/xlwt_sample.xls')