Convert blob to Excel

[Sheila29]

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.

[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.

[Aguisande · Accepted solution]

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_

[rohit782192]

How we handle clob value from a Database.

[Jithendra]

Hi,

How can we read blob or varbinary data of a file from sql server.

[rohit782192]

Hi ,

You can check a BLOB convert tool in Alteryx.

You can try and convert to HD5 of binary data.