Programmatically Refresh Excel Data Connections Without Interop

Asked May 01 '23 at 13:57

Active May 01 '23 at 13:57

Viewed 56 times

I need to programmatically refresh Excel data connections without Interop in VB.Net code. I am somewhat familiar with Open XML and how to create or modify spreadsheets, but I can't figure out how to just refresh the data (from SQL-Server) using code.

I tried looking through the Open XML Spreadsheet documentation, but I couldn't figure out how to do it.

asked May 01 '23 at 13:57

rspiet

Have you ever found a solution for this problem? Wondering about this myself. – Kevin Suppan Aug 24 '23 at 13:29
No, I never did. This is a shame as it should be an easy thing to do. – rspiet Aug 25 '23 at 14:06

Programmatically Refresh Excel Data Connections Without Interop

0 Answers0