Have taken up this small side project at work to keep my .NET skills sharp. Do any of you guys work in VSTO? I was looking for samples of reading ListObject (this is the VBA/VSTO representation of an Excel 2007/2010 table) data into a .NET DataTable or DataSet.
There's quite a bit of haphazard crap on MSDN, but nothing coherent. It would be nice to look at a succinct example of reading data, importing it in Excel, and then exporting changes back to the source, all programmatically.
At this point, the VBA code I have in some of my sheets is getting uglier and uglier by the day. Either that or I just miss the niceties of the Visual Studio environment. I know eventually I'll figure this out myself, but doesn't hurt to throw this out there... no point in redoing stuff that's already been done.
There's quite a bit of haphazard crap on MSDN, but nothing coherent. It would be nice to look at a succinct example of reading data, importing it in Excel, and then exporting changes back to the source, all programmatically.
At this point, the VBA code I have in some of my sheets is getting uglier and uglier by the day. Either that or I just miss the niceties of the Visual Studio environment. I know eventually I'll figure this out myself, but doesn't hurt to throw this out there... no point in redoing stuff that's already been done.