Sample to use Excel as Database

Harshit_jain · January 8, 2019, 2:14pm

Hi All,

Please find the sample project.
This project has all the Insert/Update/Select database queries on Excel file as Database.

You have to install the Database activities from the manage package.

This will be useful to update/Read a common file in case we are running multiple BOT’s without Orchestrator on multiple machine that file can be placed in the share drive.

ExcelAsDB_SampleCommands.zip (20.2 KB)

Hope this will be useful for all.

Regards
HJ

rahatadi · January 9, 2019, 5:35pm

Thnx buddy:blush:

g444ran · May 17, 2019, 12:03pm

I get the below error when i try to execute the above attached file.

Source: Select Query

Message: Object reference not set to an instance of an object.

Exception Type: System.NullReferenceException

An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:

System.NullReferenceException: Object reference not set to an instance of an object.

at UiPath.Executor.WorkflowRunner.EndExecute(IAsyncResult result)

at UiPath.Core.Activities.InvokeWorkflowFile.EndExecute(AsyncCodeActivityContext context, IAsyncResult result)

at System.Activities.AsyncCodeActivity.System.Activities.IAsyncCodeActivity.FinishExecution(AsyncCodeActivityContext context, IAsyncResult result)

at System.Activities.AsyncCodeActivity.CompleteAsyncCodeActivityData.CompleteAsyncCodeActivityWorkItem.Execute(ActivityExecutor executor, BookmarkManager bookmarkManager)

kindly help

sharathraju489 · November 28, 2019, 1:00pm

Here is a detailed article on that

Mansi_08 · February 10, 2020, 9:54am

i am getting this error while installing the db package

“Error: NuGet.Protocol.Core.Types.FatalProtocolException: The feed ‘https://www.myget.org/F/workflow/ [https://www.myget.org/F/workflow/]’ lists package ‘UiPath.Database.Activities.1.1.6660.26865’ but multiple attempts to download the nupkg have failed. The feed is either invalid or required packages were removed while the current operation was in progress. Verify the package exists on the feed and try again. —> NuGet.Protocol.PackageNotFoundProtocolException: Unable to find package ‘UiPath.Database.Activities.1.1.6660.26865’.
at NuGet.Protocol.FindPackagesByIdNupkgDownloader.d__6.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at NuGet.Protocol.RemoteV2FindPackageByIdResource.d__18.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at NuGet.Commands.SourceRepositoryDependencyProvider.d__22.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at NuGet.Commands.SourceRepositoryDependencyProvider.<>c__DisplayClass21_0.<b__0>d.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at NuGet.Commands.SourceRepositoryDependencyProvider.d__21.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at NuGet.DependencyResolver.ResolverUtility.d__2.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at NuGet.DependencyResolver.ResolverUtility.d__1.MoveNext()
— End of inner exception stack trace —
at NuGet.DependencyResolver.ResolverUtility.d__1.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
at NuGet.DependencyResolver.RemoteDependencyWalker.d__3.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
at NuGet.DependencyResolver.RemoteDependencyWalker.d__3.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at NuGet.Commands.ProjectRestoreCommand.d__10.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
at NuGet.Commands.ProjectRestoreCommand.d__8.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
at NuGet.Commands.RestoreCommand.d__47.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
at NuGet.Commands.RestoreCommand.d__32.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.NuGet.PackageManager.d__2.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.PackageExplorer.Core.Services.PackageInstaller.d__3.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
at UiPath.Studio.Core.Services.Packaging.PackageOperationBase.d__22.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Studio.Core.Services.Packaging.PackageOperationBase.<>c__DisplayClass21_0.<b__0>d.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Studio.Core.Services.Packaging.PackageOperationBase.d__21.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Studio.Core.Services.Packaging.PackageOperationUpdate.d__3.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Studio.Shell.Services.ProjectContextService.<>c__DisplayClass9_0.<b__0>d.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.Studio.Shared.Utilities.WindowCommandsExtensions.d__4`1.MoveNext()
— End of stack trace from previous location where exception was thrown —
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at UiPath.PackageExplorer.UI.ViewModels.PackageExplorerViewModel.d__151.MoveNext(), HResult -2146233088”

neda.moghadam · March 10, 2020, 6:52pm

Hello

I am trying to use a xlsx file as data source and execute a SQL query. I have Access Data engine installed. My computer is 64 bit. when I use the same connection string
I get Connect: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.",

I have the access data engine 64 bit installed and this connection string
{Provider=Microsoft.ACE.OLEDB.12.0;Data Source= Excel Path ;Extended Properties=“Excel 12.0 Xml;HDR=YES”; } is working for me in

Softomotive tool. I am trying to migrate my code to UiPath. I tried the connection string above and the one you have mentioned in your post but I will get The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine.",
Any comment or thought
?

Ashwini_Kumaran · June 11, 2020, 7:40am

Hi Harshit,

I have to insert a Datatable in to Excel Database for this I’m using Insert Query I have established the connection and provided the Datatable.In the place of Table Name i gave Sheet Name as String “Promo” and I also tried “[Promo$]”, I’m receiving below error for this

Insert: ERROR [42S02] [Microsoft][ODBC Excel Driver] The Microsoft Jet database engine could not find the object ‘Promo’. Make sure the object exists and that you spell its name and the path name correctly.

Any help to fix this issue.

Connected to - Microsoft Excel Driver “.xls”

Regards,
AK

ashok.p · June 29, 2020, 6:44am

Hi , did you find solution for this problem.
Please let me know. Thanks!!

abhinav.yadav · July 1, 2024, 11:07am

Today (July 1, 2024),
I encountered the same error. I resolved it by using the Excel Application Scope and then utilizing Write Range within it, instead of using Write Range Workbook.

Thanks

Topic		Replies	Views
Error : Object reference not set to an instance of an object Activities datatable , excel , database , activities , question	11	1431	November 12, 2020
Error running Project in UI Path Assistant / Working in Studio Studio studio , question , variables_management	9	827	December 13, 2022
Connect to MS Excel as Databse Help studio	3	1757	July 29, 2019
Error: Object reference not set to an instance of an object. 111 Help	5	3210	July 25, 2019
Getting Null reference error while executing sql query to read data from excel 2016 .xlsx file Academy Feedback	4	1746	June 24, 2020

Most Active Users - Yesterday
prashant1603765
ashokkarale
mively
anjasing
Yoichi
sonaliaggarwal47
lrtetala
V_Roboto_V
pikorpa
sharazkm32
More details...

Sample to use Excel as Database

Related topics