Base64 decoding for non-ascii characters

  • Goal: Upload/import an xlsx file written in hebrew into google sheets.

  • Steps: I decoded the base64 from the fileinput component and converted it to arrays for the upload into sheets, but the text only returns replacement characters instead of the original text.

  • Screenshots:

Hi @Nicole_Reiter! Thanks for reaching out.

Working with base64Data can definitely be a challenge, but I think I found a working solution:

Note that this utilizes the XLSX library, which you'll need to add to your app via its CDN:

I hope that helps! Let me know if you have any follow-up questions. :+1:

1 Like