Is it possible create pivot table and copy to data table using vb.net?

[VB.NET]

Hi friends, i want to query from excel data(sheet1) and create pivot table in sheet2 and copy that pivot table into .net data table. Is it possible? if yes, plz tell me how to do this? For example my query is "select productname, cost from sheet1" then from query output i need to create...