Invoke: no method named `ReadColumn' in class com.google.appinventor.components.runtime.Spreadsheet

[Jerome_Toutee]

Hi there, I am a newbie and trying to use Google Sheets. I can successfully read my whole sheet with .ReadSheet, I can also use .ReadWithExactFilter etc. but if I try to read a column with .ReadColumn, it always fails.

Here is my Google Sheet:

And here are my blocks:

And here is the error message:

invoke: no method named `ReadColumn' in class com.google.appinventor.components.runtime.Spreadsheet

I am using the Spreadsheet componant under Storage section in Designer:

Help apreciated. Brgds/Jerome

[Patryk_F]

Android or iOS?

[ewpatton]

Are you running companion version 2.66? When the Spreadsheet component came out in 2.65, the ReadColumn method was called ReadCol, but we decided that it wouldn't be appropriate in the long term to use the programmer abbreviated names for new users. If other operations work with the Spreadsheet but ReadColumn doesn't, you probably need to upgrade to the latest version.

[Jerome_Toutee]

This is Android and I am using the emulator with aiStarter. I am using :
Construction: March 21 2023 Version: nb192
Use Companion: 2.66 or 2.66u
Target Android SDK: 31 (Android 12.0)

Would that make a difference if I use AI Companion or if I compile an apk and install it ?

[ewpatton]

Note that this dialog only indicates the desired companion app version. This can be different from what you are actually running on your device or in the emulator. You should check the version number the emulator shows when it starts up (but before your app appears).

[ewpatton]

If you're unsure, once the emulator is connected you can always use the Help > Update the Companion menu item to request an update.

[TIMAI2]

If it helps, ReadColumn works OK on my Androidx86 emulator, which is running Android 9.This with companion 2.66

[Jerome_Toutee]

Well, when the emulator is starting, I see the following:

If I click on 'About this application', it shows the following:

If I use the vetival bar on the right of the emulator. ... then Help then About , it shows the following:

Emulator version: 30.3.5-7033400
Latest avaliable emulator version: 33.1.4-9936625 (Canary update channel)
Tomorrow will give a try with the Companion AI and not the Emulator.
Thanks for the help !

[ewpatton]

I'd still recommend using the Update the Companion option once the emulator has started to ensure you have the latest version.

[Jerome_Toutee]

Hi ewpatton,
Did not find on either the Enulatior or the AI Companion a way to update... I found it on the menu of the web AI Inventor

If I use it with the emulator running, I have this info box:

...but then , well nothing happens
If I use it while the AI Companion is running it says it is only for the emulator.

Anyway, 2 good news:

1. if I compile an install the apk, it works well I can get column.
2. now it works with AI Companion, issue is now only with the emulatir, which is not a big deal.

Thanks for the help.

[ABG]

You can side-load the latest downloaded .apk of the Companion app onto a running emulator, usually by dropping the file onto the emulator screen.

Some emulators have a control to pull in an .apk file from the emulator's host PC.

[Jerome_Toutee]

Thanks ABG. Indeed I can drag and drop the apk file to the emulator, it seems to work (it says installing APK) but then I can't find in the emulator GUI how to run the just installed APK. Sorry, I feel so dumb. Will dig further

[ABG]

@Jerome_Toutee

I can't find in the emulator GUI how to run the just installed APK

This is tricky.

Close whatever app is currently running, or look for the Android control that gets you to its 'desktop'.

Look for a ^ somewhere in the middle, and drag that up to see all installed apps.
Video at

Windows 64-bit Emulator Open Beta

For future reference, here are two short videos on how to identify the Companion version in the new emulator. (The aistarter command line window also identifies the version found as an integer.) Starting the Emulator (leftover app session still in progress in the Companion) Identifying the Companion Version ...

[Jerome_Toutee]

Thanks ABG ! Did not think to swipe bottom to up. Allowed me to long-richt-click on the MIT Ai" icon

and then get to App info

And the version is : 2.65u

[Jerome_Toutee]

Thanks to your link to video, I was finally able to run the APK that I just dropped into the emulatir, thanks a lot. And it works well with .GetColumn.