hi all,
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 this problem?
...
Go to the complete details ...