Convert blob to Excel

Hi, I have a workflow which is extracting Excel documents from a Document Repository as blobs. Is there a way to convert these blobs to their original document type (.xlsx or xls) automatically?

Attached is the workflow producing the blob outputs.

Many thanks,

Sheila.

getDocument.yxmc

Workflow

Macros

Transformation

Accepted answers

Aguisande

Hi Sheila:

I got your files.

What I did was:

- Use a Blob Input Tool to get the original file:

-Add a Formula Tool (Just to create a "Dummy" field for the next tool:

-Use a Blob Output Tool to write the Excel to the disk:

- Finally, here is the Result:

Hope this helps.

Best,

_AG_

All comments

Aguisande

Hi Sheila,

I can't access the URL from my environment. Maybe you can post filestream blob (in a yxdb or text input), so I can see the results?

Thanks

Sheila29

Hi, I have attached some examples of the blobs - is that what you are looking for please?

I had to zip the files, as otherwise this forum did not accept the file format.

IH.7z

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703