Intersoft Community - WebGrid Enterprise - WebGrid 7 - How Exclude Specific Columns From Export Process

WebGrid 7 - How Exclude Specific Columns From Export Process

andi@intersoftpt.com — Thu, 11 Mar 2010 22:52:00 GMT

Hi Yousif,

It will not be problem at all, Sir. Actually, you can ask the feature request at "Developer Networked -> Community Center -> Product FeedBack -> Feature Request". I hope it helps. Thank you and have a nice day.

Best Regards,

Andi Santoso

WebGrid 7 - How Exclude Specific Columns From Export Process

PRISMAY — Thu, 11 Mar 2010 08:11:29 GMT

Hi Andi,

No, you're right. I was incorrect, the columns are not set to hidden. Sorry about that. However, we would like to see the feature where a property specific to exporting would be available so we can include/exclude columns, for export, dynamically even if they're visible.

Our custom row checker/template columns is one example and our trailer column is another. Thanks Andi.

WebGrid 7 - How Exclude Specific Columns From Export Process

andi@intersoftpt.com — Wed, 10 Mar 2010 21:08:22 GMT

Hi Yousif,

Forgive me, but for your information, currently I am using WebGrid 7 build 401. In my end, any non-visible columns at the time of export is not included. So, if you have a hidden "trailer" column by setting the visible to false as well as if you set the column with a hidden data member, by default behavior, that particular column will be not included during the export process. I only need to make sure that you are having a same behavior like I had in the end before I ask to our developer team for a feature request.

I hope it helps. Thank you and have a nice day.

Best Regards,

Andi Santoso

WebGrid 7 - How Exclude Specific Columns From Export Process

PRISMAY — Wed, 10 Mar 2010 08:22:13 GMT

Please request this as a feature, i.e., any non-visible columns at the time of export should not be included in the export. Or, even better, would be to add a new property that can flag a column for export or not.

The columns being exported are already not visible, so I'm just removing them from the Columns collection prior to the base class.

WebGrid 7 - How Exclude Specific Columns From Export Process

andi@intersoftpt.com — Wed, 10 Mar 2010 01:55:39 GMT

Hi Yousif,

You can try to set the column's visible to false on your server handler of OnExport . It will exclude the column when we do the Exporting. Here is the snippet.

        e.Table.Columns.GetNamedItem("trailer").Visible = false;

I hope it helps. Thank you and have a nice day.

Best Regards,

Andi Santoso

WebGrid 7 - How Exclude Specific Columns From Export Process

PRISMAY — Tue, 09 Mar 2010 15:36:15 GMT

When using the "Export grid" icon in the lower right or the "Export Data" from the row context menu, how can we set up the grid columns so they're "flagged" to not be part of the export process?

We use a hidden "trailer" column to extend the row formatting beyond the right side and we don't want this column as part of the exported data. Thanks.

The way we're removing the columns we don't need right now is by using the OnExport handler and updating the table object before passing it to the base class.