When importing numbers, Google Sheets automatically adds an apostrophe (') before each number, really strange. Is there a workaround for that? Changing the format to “numbers” or find&replace does work, but I need something automatically.
I tried some combinations of parseNumber and formatNumber, but it’s still imported as a string. At some point (when I also switched to “Netherlands” and tried using a comma “,”) some values got recognized as string and some as number, but not all of them. (very strange!)
I found a workaround in sheets:
Sum function does not work:
Using + operator does work:
So I made a helper column to do (x+x-x), from that point, sheets makes a “number” of it:
When using the text aggregator the special characters are not escaped properly. You can use for free the makemarket.io Multi-Row Upload for Google Sheet / Excel, that will create the json structure automatically for your Goolge Make an api call.
Hi @EyalGershon, thank you for your video, it’s very clear and it works as expected on Google Sheet. I’m trying to do it on MS Excel, but it doesn’t seem like the “Add rows in worksheet” API documentation exists, they only have “add a row in table”.
Is there a way to do the batch update/add on Excel? Could you please advise? Thank you very much!
Close the session (even though I see this happening in the app, I am not able to reproduce it but the rows are being written.
Notice that when writing the rows you require an array inside the values key (similar to google sheets) but you will have to make sure when writing the rows, the URL needs to set the range of what you want to write.
For example if you are adding 100 rows starting at row 25 you need to set the range to A26:Z126.