def make_sheet(rows,book=None,name='test sheet',number=0):
if book is None:
book = DummyBook()
book._sheet_visibility.append(0)
sheet = Sheet(book,0,name,number)
book.add(sheet)
for rowx in range(len(rows)):
row = rows[rowx]
for colx in range(len(row)):
value = row[colx]
if isinstance(value,tuple):
cell_type,value = value
else:
cell_type=XL_CELL_TEXT
sheet.put_cell(rowx,colx,cell_type,value,0)
return sheet
def make_sheet(rows, book=None, name='test sheet', number=0):
if book is None:
book = DummyBook()
book._sheet_visibility.append(0)
sheet = Sheet(book, 0, name, number)
book.add(sheet)
for rowx in range(len(rows)):
row = rows[rowx]
for colx in range(len(row)):
value = row[colx]
if isinstance(value, tuple):
cell_type, value = value
else:
cell_type = XL_CELL_TEXT
sheet.put_cell(rowx, colx, cell_type, value, 0)
return sheet
