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 pivot table which will have two columns; productname and sum(cost) in sheet2. After that i want to copy that pivot table from sheet2 into .net data table.
plz reply soon it is urgent...
Advance thank you...