DataTable to Excel range in one shot?

c#, datatable, excel, visual-studio-2008, vsto

Solution

you will first have to convert datatable to two dimensional array, and then assign 2d array to range

Problem

I've got some data in a `System.Data.DataTable` instance and want to put it an excel sheet range, directly, in one shot. I'm working with VS 2008 and my project is a C# Excel 2007 Workbook project. Thank you

Original source