Export To excel

[Raman]

Hi,

In OWC Pivot Table I am displaying some columns and some columns I am hiding
using the command
objPivotTable.ActiveView.DataAxis.RemoveFieldSet("ColumnName").

It works fine but when I do export to excel in that case in the excel it
exports those columns also which I removed using the above syntax.

Could you please advice how I can export only those columns which I am
showing.

Regards
Raman

 

[vapor]

No real easy way around this one. But one option that works is to write some
script that fires after the export page loads (after the export from excel
fires) to remove the columns. In OWC Excel, when you hide a column, it does
not remove the column from the datasource, it just applies a filter. This is
the reason why you see it appearing after the export.

--
--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99