I need to set the source data of a Pivot Table in vb .net.

Can I use a DataTable to do it?

Code:
DT As DataTable
...
xlApp = New Excel.Application
xlWorkBook = xlApp.Workbooks.Open(sPath)
xlApp.Workbooks(1).PivotCaches(1).SourceData = DT