Reading data from multiple excel files

Hi All,

Is there any way to read data from multiple excel files and the output can trigger in out look mail.
rather than using VBA macro and nested excel loop.
I have used nested excel loop but resultant output did not come.
Please suggest solution.
My requirement is I want read the data from multiple excel files and put the out put data in one table and send it in email activity as tabular format.

Thanks & Regards,
Veeresh M

Hi,

You can use Excel recorder activity or Excel Application to configure multiple excel apps and fetch data from a given cell.

In each iteration you can increment value of cell from which data needs to be fetched.

Regards,
Amit Anand