Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Nov 20, 2012 01:05 AM by Mark - MSFT
Nov 14, 2012 12:32 AM|LINK
can anybody help me regarding this topic? when user click the export button, i have to export the data from my database to an excel file, which i managed to do. but now i have to create a pivot table in that excel file based on data in this table. how can
i achieve this?
what i tried so far, is to manipulate the sql query itself to pull out the data i want in the pivot table, but the presentation of the data is different from the actual pivot table that excel offers..
from my research for the past few days, i found out that we cant use Interop for this purpose. and the only other available methods i found are third party tool which i cannot afford. has anybody found a free solution? i cannot be the only one coming accross
Nov 14, 2012 01:37 AM|LINK
can anybody please advice?
Nov 20, 2012 01:05 AM|LINK
but the presentation of the data is different from the actual pivot table that excel offers..
I'm not sure you have refered this or not, maybe it can help.