Revision history [back]
 | 1 | initial version |
I use PSSe v33.12 + Excel 2013 on a Win7 pc. When using the module excelpy with overwritesheet=True, mode='w' I do not have the problem that you experienced. Excel remains in memory (maybe a microsoft thing) but the xls file created is not locked so I can even delete it. I use the following test code:
import excelpy
x1 = excelpy.workbook(overwritesheet=True, mode='w')
x1.worksheet_rename('LINEAS', 'Sheet1', overwritesheet=True)
x1.set_active_sheet('LINEAS')
x1.save('prueba.xlsx')
x1.close()
x1.close_app()
print 'done.'
