How to refresh (Refresh All button in excel sheet) the excel sheet using openXML in C#

0
votes

I have an Excel Sheet in which while Clicking Data->RefreshAll dynamically update the cells and values after giving credentials.I need to done the functionality of Refresh All button Via c# code using openXml .

1
c#excelrefreshopenxml

1 Answers

0
votes

So you would have to open the workbook with Excel object model and then call the Workbook.RefreshAll method.