excelize icon indicating copy to clipboard operation
excelize copied to clipboard

Excel Refresh All function

Open JunghoonChoi81 opened this issue 3 years ago • 2 comments

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()

JunghoonChoi81 avatar Sep 23 '21 00:09 JunghoonChoi81

Thanks for your issue. Sorry, this library doesn't support OLEDB and OLAP data sources currently.

xuri avatar Sep 23 '21 14:09 xuri

Hi, some news ?

enzofoucaud avatar Nov 29 '22 13:11 enzofoucaud