Thanks Jordan - Could you provide specific links / code ?
To be clear, I have a routine that iterates over a datatable and gets a string[,] multi-dimensional array, which i can bind. Thus I can't see what advantage converting to a recordset would be- it still has the 'copy from one structure to another' property
which I find ugly, and indicative that I'm not using the correct API (though, it works).
I am interested in a) going both directions - sheet to DataTable as well as DataTable to sheet b) having less to no iteration code c) having named ranges that dont have to be maintained. Something just like my code sample.
Without seeing code, I can't tell whether the solutions you describe depend on API's from the Microsoft.Office.Tools namespace (or the COM Microsoft.Office.Interop.Excel one ) I can't use the Tools.* APIs because I can't get the VSTO system to initialize
inside of ExcelDna (all the calls to .GetVstoObject() return null).. Unfortunately web searches like you suggest often return VSTO (Office.Tools.*) solutions with high frequency.
It seems likely that some API exists in Excel DNA or Interop.Excel, which has wrapped up the iteration and bidirectionality. But several days later, and I'm still searching !
PS Govert, I like the tip that I 'reimplement' what is done in the VSTO Office.Tools later - if I can get that approach to work, I'd gladly contribute it back. But naturally finding a pre-built solution is still my priority :)