excelize
excelize copied to clipboard
Excel Refresh All function
Could you please add the refresh all data (ctrl + alt + F5) ?
Please !!
ex) python code.
xlapp = win32com.client.DispatchEx("Excel.Application") wb = xlapp.Workbooks.Open(".book..xlsx") xlapp.Visible = False
wb.RefreshAll() xlapp.CalculateUntilAsyncQueriesDone()
xlapp.DisplayAlerts = False wb.Save() wb.Close() xlapp.Quit()
Thanks for your issue. Sorry, this library doesn't support OLEDB and OLAP data sources currently.
Hi, some news ?