This project has moved. For the latest updates, please go here.

Create data connections programatically.

Mar 26, 2013 at 2:14 PM

I am working on a project wherein an Excel needs to be generated programatically and with a data connection (a web query) embedded - This is similar to the Data --> From Web feature available in excel.

A friend of mine referred me to this library and I am curious if it provides support for programatically creating the data connections.


Nakul Ringshia
Jun 6, 2013 at 6:57 AM
Yes, I too want to add/update the workbook connections like we do in Interop:

xlWorkBook.Connections["SomeConnection"].ODBCConnection.CommandText = "EXEC SP";

some help is truly appreciated
Oct 22, 2013 at 3:59 AM

Furthermore, PivotTable class need to support Connection as data source.