python - Saving data from SPSS to Excel - custom sheet name -

is possible, when exporting dataset spss excel, control name of worksheet data being saved ? "save translate outfile" command not allow this. have spss 21, python installed (although new python...)

yes. see weblink on ibm website details.

get file="c:\program files\ibm\spss\statistics\23\samples\english\employee data.sav".  save translate    /type=odbc   /connect='dsn=excel files;dbq=c:\daten\temp\employeedataexcelexport.xlsx;'   /encrypted   /missing=ignore   /replace   /table='employeedata'. 

edit:

the syntax provided in link on ibm website not work me below does:

save translate     /connect="dsn=excel files;dbq=c:\temp\employeedataexcelexport.xls;driverid=790;maxbuffersize=2048;pagetimeout=5;"     /table="employeedata"     /type=odbc /map /replace. 

---