import different arrays from different sheets of an excel file

[Mayur_VIenthusiast]

Hi

The task is to get multiple arrays(different) that are in different sheets of an excel file. I have tried using the report generation toolkit, Excel get worksheet, Excel get data functions. but the problem there is that the Excel get worksheet function requires a report input. but i only have an excel file as input and i cant feed that. Is there any alternative to this?

[crossrulz · Accepted solution]

Just create a report using New Report.  Wire in the path to your Excel file as the "template".  Also, be sure to dispose of the report when you are done with it.