Hi Experts,
I have requirement where i need to edit single sheet in excel.
Let us take an example, we have excel by name 'WEEK' and stored in predefined path.
The "WEEK" excel have multiple sheets called 'MONDAY', 'TUESDAY' and 'WEDNESDAY'. where as 'TUESDAY' and 'WEDNESDAY' has a predefined pivot table. Every time when I run a report the output should download only in 'MONDAY' Sheet , where as 'TUESDAY' and 'WEDNESDAY' should not be altered.
I tried transformation techinque but its affecting the 'TUESDAY' and 'WEDNESDAY' sheet as well.
Please suggest.
Thanks,
Naveen