hi, 
I am trying to write Excel file suing output from another software where the 
output comes as myturnlist.Show()

The first part is for the output from the software which is saved in the 
clipboard. 

The big middle part works to open Excel and save the data into excel file 
called "TurnData.xlsx". 

For some reason it doesn't save the file. 

Any idea?

Thanks in advance.


import VisumPy.excel

# Write to Excel

myturnlist.Show()
turnData = myturnlist.SaveToClipboard(59,0)

excel = win32com.client.Dispatch("Excel.Application")
wb = excel.Workbooks.Add()
exce.Visible = True
wb.WorkSheets[0].Paste()
excel.activeWorkbook.SaveAs ("c:\TurnData.xlsx")

myturnlist.Close()
-- 
https://mail.python.org/mailman/listinfo/python-list

Reply via email to