when i use the lib excelpy, does not save the excels automatically when i need to create more than one, even when i only create one.
import psspy
import excelpy
x1 = excelpy.workbook()
x1.worksheet_rename('LINEAS', 'Hoja1', overwritesheet=True)
x1.set_active_sheet('LINEAS')
x1.save('prueba.xlsx')
hi i fixit with
import psspy
import excelpy
x1 = excelpy.workbook()
x1.worksheet_rename('LINEAS', 'Hoja1', overwritesheet=True)
x1.set_active_sheet('LINEAS')
x1.show_alerts(False)
dir(x1)
x1.save('prueba.xlsx')
x1.show_alerts(True)
x1.close()
x1.close_app()
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.'
Asked: 2018-11-13 14:00:35 -0500
Seen: 627 times
Last updated: Nov 14 '18
whit loves you. Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
