采用pywin32在进行wps表格时如何实现另存为功能

Question

import win32com.client


et = win32com.client.Dispatch('ket.Application')
et.Visible = True  # 确定ET是否可见
wb = et.Workbooks.Add()
cell = wb.ActiveSheet.Cells(1,1)
cell.Value='one'
wb.SaveAs(r'E:\python\pythonsql\123.xlxs')

这里

SaveAs()功能如何实现

Answer 1

import win32com.client

et = win32com.client.Dispatch('ket.Application')

et.Visible = False  # 确定ET是否可见

wb = et.Workbooks.Add()

cell = wb.ActiveSheet.Cells(1, 1)

cell.Value = 'one2999ghghfgjhjjhjhj'


wb.Save()
wb.SaveAs(r'C:\Users\Administrator\Desktop\12jjjj2kkk2kkk.xlxs')
wb.Close()
et.Quit()