Read data from Google Sheets
- By JoséeMallah
- Android Development
- 0 Replies
Hello everyone,
I have been trying since days to read data from Google Sheets into a list view. I was referring to tutorials from Crazy Coders Club. The write operation works well, however, the read operation either shows nothing or makes the app crash. I am adding below my codes, and I will be grateful if someone could help me figure out the problem.
Here are my spreadsheet link: https://docs.google.com/spreadsheets/d/1Bccu6dyOIV5lF-be_95LDYkdFEdqtBYKhNDE97nv_Ss/edit?usp=sharing
and Google Scripts link: https://script.google.com/d/1HdmpUP...1uOzcZclQNm0mlxDK1QeKlz-9KFo/edit?usp=sharing
XML:
XML (leaderboard_item):
Java Code:
I have been trying since days to read data from Google Sheets into a list view. I was referring to tutorials from Crazy Coders Club. The write operation works well, however, the read operation either shows nothing or makes the app crash. I am adding below my codes, and I will be grateful if someone could help me figure out the problem.
Here are my spreadsheet link: https://docs.google.com/spreadsheets/d/1Bccu6dyOIV5lF-be_95LDYkdFEdqtBYKhNDE97nv_Ss/edit?usp=sharing
and Google Scripts link: https://script.google.com/d/1HdmpUP...1uOzcZclQNm0mlxDK1QeKlz-9KFo/edit?usp=sharing
XML:
Code:
<?xml version="1.0" encoding="utf-8"?>
<androidx.constraintlayout.widget.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:app="http://schemas.android.com/apk/res-auto"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent">
<ListView
android:id="@+id/lv_items"
android:layout_width="0dp"
android:layout_height="0dp"
app:layout_constraintBottom_toBottomOf="parent"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toTopOf="parent" />
</androidx.constraintlayout.widget.ConstraintLayout>XML (leaderboard_item):
Code:
<?xml version="1.0" encoding="utf-8"?>
<androidx.constraintlayout.widget.ConstraintLayout xmlns:android="http://schemas.android.com/apk/res/android"
xmlns:tools="http://schemas.android.com/tools"
android:layout_width="match_parent"
android:layout_height="match_parent"
xmlns:app="http://schemas.android.com/apk/res-auto">
<LinearLayout
android:layout_width="350dp"
android:layout_height="90dp"
android:orientation="horizontal"
app:layout_constraintBottom_toBottomOf="parent"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toTopOf="parent"
app:layout_constraintVertical_bias="0.1">
<androidx.constraintlayout.widget.ConstraintLayout
android:layout_width="match_parent"
android:layout_height="80dp"
android:background="#EAE8E8">
<TextView
android:id="@+id/username"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginStart="50dp"
android:fontFamily="@font/league_spartan_bold"
android:text="TextView"
android:textColor="@color/colorPrimaryDark"
android:textSize="20sp"
app:layout_constraintBottom_toBottomOf="parent"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintHorizontal_bias="0.0"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toTopOf="parent" />
<TextView
android:id="@+id/score"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginEnd="20dp"
android:fontFamily="@font/sanchez"
android:text="TextView"
android:textColor="@color/colorTextDark"
app:layout_constraintBottom_toBottomOf="parent"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintHorizontal_bias="1.0"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toTopOf="parent" />
<TextView
android:id="@+id/rank"
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:layout_marginStart="20dp"
android:fontFamily="@font/sanchez"
android:text="1"
android:textColor="@color/colorTextDark"
android:textSize="20sp"
android:textStyle="bold"
app:layout_constraintBottom_toBottomOf="parent"
app:layout_constraintEnd_toEndOf="parent"
app:layout_constraintHorizontal_bias="0.0"
app:layout_constraintStart_toStartOf="parent"
app:layout_constraintTop_toTopOf="parent" />
</androidx.constraintlayout.widget.ConstraintLayout>
</LinearLayout>
</androidx.constraintlayout.widget.ConstraintLayout>Java Code:
Code:
package com.example.aquatricity;
import android.app.ProgressDialog;
import android.os.Bundle;
import android.widget.EditText;
import android.widget.ListAdapter;
import android.widget.ListView;
import android.widget.SimpleAdapter;
import android.widget.TextView;
import androidx.annotation.Nullable;
import androidx.appcompat.app.AppCompatActivity;
import com.android.volley.DefaultRetryPolicy;
import com.android.volley.Request;
import com.android.volley.RequestQueue;
import com.android.volley.Response;
import com.android.volley.RetryPolicy;
import com.android.volley.VolleyError;
import com.android.volley.toolbox.StringRequest;
import com.android.volley.toolbox.Volley;
import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;
import java.util.ArrayList;
import java.util.HashMap;
public class Leaderboard extends AppCompatActivity {
ProgressDialog loading;
ListView listview;
ListAdapter adapter;
@Override
protected void onCreate(@Nullable Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_leaderboard);
listview = (ListView) findViewById(R.id.lv_items);
getUsers();
}
private void getUsers() {
loading = ProgressDialog.show(this,"Loading","please wait",false,true);
StringRequest stringRequest = new StringRequest(Request.Method.GET, "https://script.google.com/macros/s/AKfycbzvfbIcBrm6UXpK3xphHor2azlk1dZxar28_6z8PFI7xDyNq4xnQ-m4Gs80A3Y8ZspT_Q/exec?action=getUsers",
new Response.Listener<String>() {
@Override
public void onResponse(String response) {
parseItems(response);
}
},
new Response.ErrorListener() {
@Override
public void onErrorResponse(VolleyError error) {
}
}
);
int socketTimeOut = 50000;
RetryPolicy policy = new DefaultRetryPolicy(socketTimeOut, 0, DefaultRetryPolicy.DEFAULT_BACKOFF_MULT);
stringRequest.setRetryPolicy(policy);
RequestQueue queue = Volley.newRequestQueue(this);
queue.add(stringRequest);
}
private void parseItems(String jsonResposnce) {
ArrayList<HashMap<String, String>> list = new ArrayList<>();
try {
JSONObject jobj = new JSONObject(jsonResposnce);
JSONArray jarray = jobj.getJSONArray("Users");
HashMap<String, String> user = new HashMap<>();
for (int i = 0; i < jarray.length(); i++) {
JSONObject jo = jarray.getJSONObject(i);
String displayName = jo.getString("displayName");
String email = jo.getString("emailAddress");
String pass = jo.getString("password");
String phoneNumber = jo.getString("phoneNumber");
String score = jo.getString("score");
String rank = jo.getString("rank");
String house = jo.getString("household");
user.put("displayName", displayName);
user.put("rank", rank);
user.put("score",score);
list.add(user);
}
} catch (JSONException e) {
e.printStackTrace();
}
adapter = new SimpleAdapter(this,list,R.layout.leaderboard_item,
new String[]{"displayName","rank","score"},new int[]{R.id.username,R.id.rank,R.id.score});
loading.dismiss();
}
}
)
