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

Help Studio
1

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

2

@deepika.garg

You can try using excel as db and reqd it …

Cheers

3

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

4

@deepika.garg

please check this…this is the full tutorial

to create connectionstring use this

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

cheers

5

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.
image

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

image
image554×523 33.1 KB

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

Please advise if anything else is needed.

6

@deepika.garg

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

Cheers