Best way to read data from excel(xlsm) macro enabled and protected

[Anil_G (Anil Gorthi)]

@deepika.garg

please check this…this is the full tutorial

Use mysql to retrieve data from the Excel into a data table

Hi, In order to connect dynamically to Excel from UiPath I suggest you use OLEDB. Then you will be able to use mysql to retrieve data from the Excel into a data table. Here is a YouTube video how you can do it: [UiPath: Manipulate Excel with SQL]

to create connectionstring use this

Excel connection strings - ConnectionStrings.com

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcel2007file.xlsm;Extended Properties="Excel 12.0 Macro;HDR=YES";

Using Excel as a Database in UiPath

cheers