Execute Non query Not working - Excel AS db

Help Studio
, , , , , ,
1

Hi All,

I am using execute non query (Excel as db) to update excel. It is updating the excel file when file is open, But if the excel file is closed its not getting updated.

Connection string -“Provider=Microsoft.ACE.OLEDB.12.0;Data Source=”“”+in_FileName+“”“; Extended Properties=‘Excel 8.0;HDR=YES;IMEX=0’;”

If excel is closed, I am not getting any error as well, its not updating the file.

Any suggestion on this,

Thanks in advance.

2

Hi @nithya ,

Please use a connection string like this:

"Dsn=ExcelAsDB;dbq=C:\USERS\MARIUS.PUSCASU\DOCUMENTS\UIPATH\TEST_202112\Forum\ExcelAsDB.xlsx;defaultdir=C:\USERS\MARIUS.PUSCASU\DOCUMENTS\UIPATH\TEST_202112\Forum;driverid=1046;fil=excel 12.0;maxbuffersize=2048;pagetimeout=5"

This is the helper .xaml file:
ExcelAsDB.xaml (5.2 KB)

Please check this video for a detailed explanation https://youtu.be/b9YoO6syw6Q?t=833

It works for me, with excel app closed.

Hope it helps!
Best regards,
Marius