android - Download Google spreadsheet data into App Inventor to display it as table -

i have got app posts lot of barcode scanned in data on google spreadsheet stores scanned id, id, firstname, secondname , email address. data being updated new barcodes being scanned in google sheet. data unto date in table form on click of button displaying on different screen within same app.

currently have tried many different ways of doing including downloading file having no luck getting open , manually inserting data not supposed do.

i not want make use of fusion tables don't understand how work.

i have done download csv file

but when run runtime error

can give advice on best way this.

update 2:

since making changes coding blocks this:

i don't information in form of table , information on next page not complete , not allowing me scroll downwards.

[![enter image description here][4]][4]

update 3:

i have managed make page scrollable still no html table working

update 4:

i have had file uploaded assets still not work have uploaded results screenshot of label1.text when clicking on download button

update 5:

i have made changes label says trying downloading , doesn't display table or data csv web viewer displaying html code.

you runtime error, because downloading file in csv format , in web.gotfile event assigning csv file image component, not possible.

instead of downloading file, download content of csv file instead!

to that, set web.saveresponse false, use web.gottext event receive response content, , use this solution display table in webviewer component.

edit: concerning problem asset table.html, see answer other question here.