CODEWITHSUNDEEP
excelopenxmlsql-server-openxml
rspiet
rspiet

Reputation: 11

Programmatically Refresh Excel Data Connections Without Interop

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.

Upvotes: 1

Views: 182

Answers (0)

Related Questions