How to run sql query on excel workbook?

S0024009236 — Tue, 22 Mar 2022 13:06:03 GMT

Hello experts,

How do we run SQL query on excel workbook in iRPA cloud studio.

Tried imitating this blog post which is meant for desktop studio with a little modification in code.

The following error is thrown. "ActiveXObject is not defined".

Please suggest if there is any solution.

        var cn = new ActiveXObject("ADODB.Connection");
 	var strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source = 'C:\\Users\\Administrator\\Downloads\\abc.xlsx';Extended Properties='Excel 12.0;HDR=Yes'";
	cn.Open(strConn);
	var rs = new ActiveXObject("ADODB.Recordset");
	var SQL = "select * from [Sheet1$] where [Group Indicator] is not null";
	rs.Open(SQL, cn);
	var index=0;
	 while(rs.EOF != true){
		rs.MoveNext();
		index++;
         }
	rs.Close();
	cn.Close();

Re: How to run sql query on excel workbook?

janv7306 — Tue, 22 Mar 2022 13:17:24 GMT

Hello Bhushan,

I am using Execute Macro feature in IRPA Excel SDK. And I keep all macros in a separated excel file. It allows me having all programming code separated.

Regards,

Jan

Question Re: How to run sql query on excel workbook? in Technology Q&A

How to run sql query on excel workbook?

Re: How to run sql query on excel workbook?