I have 100 excel data which i need to accumulate into one excel sheet. So i used read range activity (excel application scope) to take this 100 data one by one and then i used append range activity to accumulate into one excel sheet.
These 100 excel sheets are having some bold letters and different fonts. So same format i want in the accumulated excel sheet.
Note: i selected preserve format option while using read range activity. Still not working.
Can someone help me on this.