Member Avatar for tj_amarnath

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 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...

  • 2 Contributors
  • 1 Reply
  • 106 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by kvprajapati
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.