Hide columns in excel export which are excluded in Grid

[VK_10159720]

Hi Developers,

I have a grid which I am exporting into a csv file via Data Export widget. I am using ThingWorx 8.5.

There is a column (OEE) which I have excluded in Grid Configuration and I am not showing it on the screen.

However, on exporting that grid data, it is coming in the excel file.

I need to remove OEE column, kindly suggest how to exclude it from excel.

Thanks in Advance.

[nmutter · Accepted solution]

The Grid shows data provided from an Infotable.

The Data export widget also takes the same Infotable data.

There is no connection between Grid-configuration and the DataExport widget. If you don't want to export a specific column, the column must not be in the infotable. Maybe you can use https://www.ptc.com/en/support/article/CS180324 to remove the column in the service providing the Infotable?

[jensc]

Hello @VK_10159720 ,

Where are you getting the data from?

If it is an SQL query, it might be simplest to just write a new query, leaving out the columns you do not want.

I tried finding some snippet that could do this, but couldn't really find any, so @nmutter's way with removing the field for each row might be the best way

Regards,

Jens