Read from csv table

MIT App Inventor Help
1

I have a big list so I create
csv.aia (2.7 KB)
csv . Now I'm trying to read data from csv table but I cannot
I'm trying to seperate columns from table and read data from cells.

2
21384×846 153 KB

3
31344×718 292 KB

1

2

You have a poorly formed csv file, using ; instead of ,

AI2 does not understand csv files with ;

Either replace in the csv file itself, or replace all ; when you read the file, using the text replacement block, before trying to make a list

3

Thanks for reply.
I did create xlsx excel file and saved it as csv utf-8 (comma delimited)
Now how to convert it properly ?

4

Try this

csv_1a.aia (3.2 KB)

blocks - 2023-12-13T114612.733
blocks - 2023-12-13T114612.7331422×1402 205 KB

1 Like
5

Thank you for the quick and direct help . (TIMAI2 & Ria_Das)
Now if I create a big csv like calendar , add more collumns ..... when screen1 initialize , how I get the today day from csv table ? Connect it with clock somehow?

6

It would be much easier to include a date string in your csv table for each record in this format:

2023-12-05

(do not enter a date number in your spreadsheet, enter a string!)

Then you can generate this format using the clock blocks to match....

7

. Thank you TIMAI2 ..... thanks a lot