OLEDB Connection String for Excel integration .NET Component Bizagi 11.1
Does anyone have an OLEDB connection string that works
successfully in a .NET component for connecting to Excel in Bizagi 11.1?
I have built a .NET Class Library DLL component following
for component logic and registration, respectively.
From a separate .NET console application, I can invoke my
class library to return the desired XML string representing the contents of an
Excel workbook. I am successful using
different OLEDB connection strings. However,
when I register the class library in Bizagi I am receiving different errors
depending on the connection string I try to use.
Using the following, I have traced the execution to the connExcel.Open()
statement where Bizagi hangs. In the
work portal, I just see the spinning cube that goes on forever. This is being tested with a .XLSX Excel
Has anyone had any success with the Microsoft.Jet.OleDb.4.0
provider? If so, could you share your
Thanks in advance for anyone who can help me with this.