I have a straight table and am using macro to export it to excel along with some other objects.it is working fine. Now i need to exclude 2 columns from the straight table while exporting?? is that possible ??
It is possible. I will recommend you to use inbuilt actions of Qlik rather than using macro. Well you can use a coppy the same Straight table with condition of excluding that two columns and let that be Hidden.
Then you should use one more straight table excluding those two fields as Sujeeth suggested and that will be hidden. But the macro will export the hidden straight table which doesn't have those two fields.