Read Content of an Excel document from repository using workflow SDK

replied on August 14, 2016

The Workflow SDK is for interacting with the Workflow Server. You need the Laserfiche SDK to read documents from the repository. You'll need an ODBC or OLE driver or the Office SDK to process the contents of it.

0 0

replied on August 15, 2016

Thanks for reply, here you go what iI did

I am trying to build custom activity to read excel file from the repository as I mentioned, and I've added Interop.LFSO90Lib.dll, Laserfiche.RepositoryAccess.dll, & Laserfiche.DocumentServices.dll from SDK.

finally, I added this custom activity into Workflow designer and built small example;

1- Search for Document "Excel"

2- Rn the custom activity for each found document

3- this custom activity export document into Windows Temp folder and then I will do the required.

moreover, once I run it I got the below error;

15/08/2016 12:26:11 Tameen Custom Activity Unable to cast COM object of type 'System.__ComObject' to interface type 'Laserfiche.RepositoryAccess.IDocumentContents'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{0487007E-50D3-3C5C-BBDE-E6D876AFB254}' failed due to the following error: No such interface supported (Exception from HRESULT: 0x80004002 (E_NOINTERFACE)).

Platform version: Laserfiche Server, Laserfiche workflow, and Laserfiche SDK is 9.2

0 0

replied on August 15, 2016

I can't tell without seeing your code, but it looks like you're mixing and matching LFSO and RepositoryAccess calls. That's not expected to work. If you're running Workflow 9.2, stick with RA calls only.

0 0

Question

Question

Read Content of an Excel document from repository using workflow SDK

Replies

Sign in to reply to this post.