I'm looking for win32com alternative which will work on Linux. As win33com won't work in Linux. Now, we are using win32com but we are planning to move to Linux. We are using below script for refresh Excel pivot table. We need python script for same which will work on Linux.
Kindly advise
'''
import win32com.client
# Start an instance of Excel
xlapp = win32com.client.DispatchEx("Excel.Application")
# Open the workbook in said instance of Excel
wb = xlapp.workbooks.open(<path_to_excel_workbook>)
# Optional, e.g. if you want to debug
# xlapp.Visible = True
# Refresh all data connections.
wb.RefreshAll()
wb.Save()
'''
question from:
https://stackoverflow.com/questions/65904226/python-win32com-functions-for-linux 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…