Google Sheets


#1

Hi Makeblock,

I can’t use the Google Sheets.

it does not work : File


#2

Is it because the name of the sheet is in French ???
2020-06-28%2010_39_01-Microsoft%20Store

Maybe you need a very specific sheet name?
2020-06-28%2010_43_19-
not work anymore…


#3

Hi Michel,

Here are the steps guiding use the google sheet with the mBlock 5 software:
Set up a new sheet in Google Sheets, click the Share button on the right corner, and click the arrow as shown in the picture.
image

Choose Anyone with the link can edit
image

Then click to Copy Link
image

And copy to mBlock
image

And then we can test by press the space button. Here’s how the result turned out:
image
image


#4

That’s exactly what I do … can you manually try to add a few things with the link I left. In this way, it would prove that the configuration of the file is correct.

it does not work : File


#5

Hi Michel,

Yes, I tested it, the configuration is correct.
I have tested the mBlock program with the link you shared and it works.


I have saved my program file and will send it to your email, please have a check


#6

heee … i don’t understand why it works so well. Your code works and so does my code ??? I will continue to test but it works, so thank you.


#7

Michel,

Glad to hear it works, welcome!