How to read multiple excel columns in DataTable

[aksh1yadav (AKSHAY YADAV)]

@abskulkarni

I need some example of these activities

You can also give them a try by following info provided there. try and try then you will also get something

For your info just check the attachment:

Excel file with Chart Sheet as first sheet - Exception

Hi @Thiago Actually you are getting this error because your cast is wrong because you are using “Excel Activity Scope” with it. Namespace: Microsoft.Office.Interop.Excel Assembly: Microsoft.Office.Interop.Excel (in microsoft.office.interop.excel.dll) This interface only gives you worksheets - not charts. Go to Remark section On the other hand, if you will use “Workbook Activities” so it’s instance _Workbook.Sheets gives you a Sheets instance. Go to Remark section …

The attached Example is using Above activity.

Regards…!!
Aksh