Hi All,
I have created xls using pyExcelerator. when i tried to open that xls sheet i'm getting this error message "File error: data may have been lost " ,
Please some one help me how to rectify the above.
my code is :
def fnwrite(Dictionary):
font0 = Font()
font0.name = 'Verdana'
font0.bold = True
font0.colour_index = 2
style0 = XFStyle()
style0.font = font0
wb = Workbook()
ws0 = wb.add_sheet('Summary')
for i, key in enumerate(LIST):
ws0.write(0, i, key, style0)
fnt = Font()
fnt.name = 'Verdana'
fnt.outline = True
style = XFStyle()
style.font = fnt
k = 0
for key, value in Dictionary.items():
k = k + 1
for det in value:
for i, elem in enumerate(LIST):
ws0.write(k, i, det[elem], style)
wb.save('out.xls')
regards,
amuven