How to create excel file from json response

[Srini84 (Srinivas)]

@Namrata_Butch

Check below link for your reference

Convert database BLOB (excel/word/..) for saving to local file system

I created a ticket in the UiPath techical support and got this solution, that works splendidly! Create a memory stream variable (Variable type System.IO.MemoryStream), call it memoryStreamdoc. Then, connect to DB and execute query that returns a datatable, where one column is of type BLOB. Loop through each myRow (row) in the datatable Within the loop: Create an assign: memoryStreamdoc=new memoryStream(CType(myRow.item(1),System.Byte())). You need to replace the myRow.item(1) with t…

Hope this helps you

Thanks