https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78434#M30463 Do you have the actual data you need already in your Byte[] array, or the whole workbook as binairy data? If it is just the data you need, you can maybe try something like: My_data_string = System.Text.Encoding.ASCII.GetString(My_byte_array) I've never used this myself, so chances are that I misunderstood your question and/or point you in the wrong direction, but it is worty trying. ☺ Wed, 21 Mar 2018 11:11:00 GMT BastiaanBezemer 2018-03-21T11:11:00Z https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78433#M30462 Hi All, i have implemented one solution to read the data from an excel file using the URL to the file located on web using DownloadData(URI) method of the C# language. The data is getting generated but it is in form of Byte[] array and i need to convert it into BP collection but not able to do it. can someone here help me in doing this?   Tue, 20 Mar 2018 14:33:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78433#M30462 NilanshuSoni 2018-03-20T14:33:00Z https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78434#M30463 Do you have the actual data you need already in your Byte[] array, or the whole workbook as binairy data? If it is just the data you need, you can maybe try something like: My_data_string = System.Text.Encoding.ASCII.GetString(My_byte_array) I've never used this myself, so chances are that I misunderstood your question and/or point you in the wrong direction, but it is worty trying. ☺ Wed, 21 Mar 2018 11:11:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78434#M30463 BastiaanBezemer 2018-03-21T11:11:00Z https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78435#M30464 Hi,  Thanks for replying back. i have the whole workbook as byte[] array. I have used DownloadData() method to directly getting all the data from the workbook kept at an URI into the byte[] array. now i need to convert that byte[] array into the data table(blue prism collection).  excel workbook is having columns: Name, Amount and Date. Also, when i am writing the same binary data into another excel, i am getting the same data that was available in the initial excel.   Wed, 21 Mar 2018 17:35:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78435#M30464 NilanshuSoni 2018-03-21T17:35:00Z https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78436#M30465 So if you have the whole workbook in the byte array.... The easiest option is first saving it into a file with System.IO.File.WriteAllBytes(Your_Save_As_path, Your_Byte_Array) And then you can do the needed actions an manipulations with The MS Excel VBO With probably (after opening) the action Get worksheet as collection (fast) Wed, 21 Mar 2018 17:57:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78436#M30465 BastiaanBezemer 2018-03-21T17:57:00Z https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78437#M30466 Thanks, but that is something I know. there is a requirement to not keep any file on the system for loading data. I need to directly download data through code and convert it into a collection and use it in the process on run time. Wed, 21 Mar 2018 19:28:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78437#M30466 NilanshuSoni 2018-03-21T19:28:00Z https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78438#M30467 That's a pretty insane requirement.... I would try to re-negotiate that: Even windows and office apps itself often store temp files when working on remote files.... Can't you get the Data in an online google spreadsheet ? Then with API calls you can read out the data relatively easy... Wed, 21 Mar 2018 22:25:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78438#M30467 BastiaanBezemer 2018-03-21T22:25:00Z https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78439#M30468 it will be a kind of security breach keeping real time customer data on google spreadsheet even for a fraction of second. if i could use excel in any way, i would have used it on local machine. Fri, 23 Mar 2018 13:16:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78439#M30468 NilanshuSoni 2018-03-23T13:16:00Z https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78440#M30469 Can some one from Blue prism technical team comment on this?  Tue, 27 Mar 2018 10:45:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78440#M30469 NilanshuSoni 2018-03-27T10:45:00Z https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78441#M30470 A bit late reply - but if you need to read it in memory I would do it in C#. To load an excel workbook from a .Net memorystream I think you need a third party library, such as https://www.nuget.org/packages/ClosedXML/. Convert the byte array to a memory stream and initiate the XLWorkbook by passing it, such as: XLWorkbook excelWorkbook = new XLWorkbook(stream) You then need to iterate through it and create a DataTable which then can be assigned to a native Blue Prism collection. Again, I would recommend saving to a temporary file and using bastiaan's approach from above. Fri, 05 Oct 2018 01:45:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78441#M30470 OscarAagren 2018-10-05T01:45:00Z https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78442#M30471 If file is xlsx (openxml), you can unzip it in memory and read parse xml format yourself or use openxml sdk or many other 3rd party libs. If it is old excel format, then some libs still work afaik, but your mileage may vary. Sat, 06 Oct 2018 06:37:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-convert-Byte-into-a-BP-collection/m-p/78442#M30471 AndreyKudinov 2018-10-06T06:37:00Z