I do have requirement as below.
1. There is one simple excel sheet with 120 columns and trying to populate all 120 columns in certain order as per business(not alphabetical).
2. Also one of the column should be always in Yellow color.
3. Also trying to highlight entire row based on some condition.
I implemented this functionality by using both Table Object & Chart - Straight Table Object. But, I couldn't accomplish all three requirements as above.
Table Object: I cant implement any conditions, only first requirement is accomplished
Chart - Straight Table Object: This will accomplish all above 3 things, but there is lot of manual work. Like, trying to highlight entire row I' m applying condition for each 120 attributes manually. Is there any way to do by single command to do this?
Please, also suggest me which object is the best suit to us?
