Small and medium business | Business Central, N...

Problem with Base64 conversion and Excel files

(0) Share

Report

Posted on by gtr2

Hello,

I have an application that gets Excel files encoded in Base64
I try to decode the Base64, put the obtained text into a blob to download it later with DownloadFromStream
But I get corrupted Excelfiles
I developped a little procedure (see link) to see if Base64-coding and Base64-decoding is altering the data.

procedure-ctrldl.jpg_2D00_640x480.jpg

The result of the procedure is :
Text File identical : True
Excel File identical : False
I tested the Base64 texts with https://base64.guru/converter/ and there seems to be no problem
Has somebody a hint to see where the problem comes from ?

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Nitin Verma 21,625 Moderator on at

Like (0)

Report

RE: Problem with Base64 conversion and Excel files

Hi,

Try with the below link might be it help you

www.j3ns.de/.../

Was this reply helpful? Yes No
gtr2 58 on at

Like (0)

Report

RE: Problem with Base64 conversion and Excel files

Hello Daniele Incalza : I already checked with https://base64.guru/converter/ and checking with https://www.base64decode.org/ confirmed my conclusions

Hello Nitin Verma : I had a look to the code example, its does not what I am trying to show, meaning that have a given Base64-encoded string and I want to decode correctly to get a file that is not corrupted

My little procedure is showing that for Base64 strings coming from an Excel files (after other testings for word and pdf files too) the decoding and re-encoding process alters the file.

Normally I suppose that decoding a base64 string and re-encoding again should give the same as the original base64 string

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,625 Moderator on at

Like (0)

Report

RE: Problem with Base64 conversion and Excel files

Get an idea from the below link

www.navwithnav.com/.../

Was this reply helpful? Yes No
Suggested answer

DAnny3211 11,282 on at

Like (0)

Report

RE: Problem with Base64 conversion and Excel files

hi

try this

https://www.base64decode.org/

DAniele

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

RE: Problem with Base64 conversion and Excel files

Hello,

We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

www.yammer.com/dynamicsnavdev

www.dynamicsuser.net/.../14

I will open this up to the community in case they have something to add.

Thanks.

Was this reply helpful? Yes No