Hi,
I am converting BinaryData to text in then It is giving me gibbersish text like PK***
Hi Vivek,
That should be normal, depending what binary data that you convert to text.
I just converted some column to binary text.
Can you elaborate for "column" ?
Do you mean column data value, converted to binary ? if so, I think it is list converted to binary.
Yes It is column data value and after converting from Binary data to text then It is showing PK*** and coming more text
Yes that is expected. Because it is from List -> Binary -> Textif you want it to show Text, then convert List to Text (maybe using JSON serialize) then convert to Binary, then Text, this should return Text that you can read without gibberish text
When I upload excel then it is in binary data but then need to convert text so please tell me how I can convert to JSON and henceforth
Wait, better you inform us what is your requirement for this ?
I have one excel where I have two column where added some data in those column. When I upload this excel then need to take those values from that excel and need to update those records in database, hope so you are getting my issue.
I see, then you doing it wrong.
After you upload your excel, you can use ExcelToRecordList widget for convert excel to List, then you can insert the list into Entity (Database)
The example above, I user "User" entity
When we used Upload widget to upload excel then we have to pass two parameter one is Filecontent and Filename so Filecontent is binary data so How we can use excelto recordlist?
Yes, put the filecontent in exceltorecordlist file content parameter