-
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 Like