Question
Srinsoft Technology
IN
Last activity: 17 Aug 2022 0:17 EDT
How to remove Static Property Name from Export to Excel
Hi All,
I have a requirement, I am able to download the excel and displaying Tab wise details.
I have 3 check boxes like, A, B and C
If I click on A check box B and C Tab should not be visible, only I can see Tab A data.
But We are maintaining static format like attached excel, Is there possibility to remove Tab’s if I don’t check the check box.
***Edited by Moderator Marije to add Capability tags***
Lventur
IN
I am thinking in excel template file we will not be able to have visibility condition getting defined.
Alternatively what you could do is have a decision table which will take the user selected option value as input value and based on the input value it should return the excel template name conditionally.
When A option is selected return value should be - Webwb.A_Template.xlxs
When B option is selected return value should be - Webwb.B_Template.xlxs
In each template just have the tab which needs to be avail based on business need. If you are going for this approach, you could build reusable activity which will generate the excel based on user selection conditionally.
In future if any new option is getting added, then for the new option you need to create a new binary file and need to update the new option binary file information in decision table that alone would be enough..