I am pretty sure that the key is a listObject but I cannot figure out how to create one in code.
Here is my Setup:
Visual Studios 2008
Visual Studio Template: Excel 2007 Addin
Code Executed from a UserControl.
So far I have the code calling a webservice and returning a DataSet. I have the populated dataset but cannot get the data from that dataset into the active worksheet.
I have seen a few examples of how to do this but all of them seem to be from a different project type (Excel 2007 workbook from what I can tell) and the same commands do not seem to be available.
If someone could show me some sample code of a Dataset being bound in someway to an excel worksheet it would be greatly appreciated.