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

[deepika.garg]

Hi everyone,

Can anyone suggest what is the best way to read data from macro enabled and protected excel?
I can read it normally but it’s taking around 3 mins.

I was just wondering if there is any other way to make it bit quicker?

Thanks,
Deepika

[Anil_G (Anil Gorthi)]

@deepika.garg

You can try using excel as db and reqd it …

Using Excel As Database

How to connect with Excel as a database ? Perform the details mentioned in the Step by step guide, for connecting Excel as a database Open Excel file (Note - Excel file must remain open) In UiPath Studio Drag and drop Connect / Execute (Non) query activity Click Configure connection Open Connection Wizard Select Microsoft ODBC Data Source Use Connection String Click Build Go to Machine Data Source Click New Click Next Microsoft Excel Driver(.xls) Next Finish Give Some Data Source Name and Desc…

Cheers

[deepika.garg]

Hi @Anil_G ,

Thanks for quick response!!

I am not able to download the Xaml file and spreadsheet.
Is it possible for you to attach it in forum?

Thanks,
Deepika

[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

[deepika.garg]

Hi,

Thanks for tutorials!!

I am waiting for my IT team to install the Microsoft access database Engine 2010.

In my system ODBC admin app, i can’t see Excel Drivers. So according to tutorials, i need to install the later.

In studio, following the instructions to connect to excel…missing excel drivers:

Activity tried in studio:
Connect to database, Run Query, Run Command

Please advise if anything else is needed.

[Anil_G (Anil Gorthi)]

@deepika.garg

You need a odbc or oledb drivers which will help in connecting

Cheers