Error retrieving XLSX using HTTP from a webserver

How To
,
1

I have an excel file sitting on a web server that I need to grab and convert to Google Sheets. I use the HTTP download module to retrieve and download the file. I get an error: “Unknown Exception: unsupported Unicode escape sequence” when trying to just save the scenario. Thanks in advance!

screencapture-us1-make-377211-scenarios-2070163-edit-2024-03-06-08_10_23-edit
screencapture-us1-make-377211-scenarios-2070163-edit-2024-03-06-08_10_23-edit1920×1014 111 KB

3

Hey @Kimsu

You can check this solution from @samliew

Hope this will help you

2 Likes
4

Thanks for this, but the source of my file is not Gmail. It is sitting on a web server. Going from Excel to Google sheets is the part I know how to do. It’s the error when trying to retrieve the XLSX file using HTTP from where it is sitting on a web server.

5

Hi @Kimsu,

Have you got a test file in a different location that causes the same error, something we can test with?

2 Likes
7

Hello,

It would seem that the file may be getting uploaded incorrectly.
Are you able to successfully download and open it using any other means?

2 Likes
8

@Kimsu

I think this will help you

3 Likes
9

Nice solution, hadn’t thought of this!

3 Likes
10

Thank you, I was able to get that test file to work with your recommendation, but I do think there was something wrong with my original XLSX files. Thanks so much!

3 Likes