You are viewing limited content. For full access, please sign in.

Question

Question

Write into Excel

asked on November 25, 2015 Show version history

Dears,

How possible to write into an excel file located into the Laserfiche Repository by the workflow without exporting the excel and then importing it to Laserfiche.

Thanks,

Dory Mina

 

 

0 0

Replies

replied on November 25, 2015

It is definitely possible! It would take some coding though using the SDK Script activity in workflow. I would also suggest NOT installing MS Office or using any of their interops on the workflow server. Instead, you can use a .Net open source library that manipulates Open XML spreadsheets. Here is a good/free one. Next, you will need the Laserfiche SDK Documentation to guide you in your quest. In the documentation, there is a class called "DocumentExporter" and "DocumentImporter" in the "Laserfiche.DocumentServices" namespace. The "DocumentExporter.ExportElecDoc" will get you the document into a "Stream" from which the "SpreadsheetLight" can load it, manipulate it, and then "DocumentImporter.ImportEdoc" can then import it back to the entry, replacing the document that was there previously. I would suggest not doing to much manipulation (iterate through a large spreadsheet) as you don't want to hang up Workflow for to long. This is very high level, but it is possible.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.