I am new to android application development and as well new to Java....I am currently doing my Masters Program in IT with Health Informatics, so i just completed my Java programming class, which is my first experience at learning Programming.
I have an excel sheet i use for reference at work, it consists of 4 columns and about 13,000 rows. so i want to make an android app of this file, i want to make the Interface to be searchable in such a way that if user type any word from column A, it should be able to give the values corresponding to the adjacent column. For example in the table below, i want user to be able to search either by Codes or by description, so if a user type migrate, or mig (from row 2 on the table) then he should get something like code= 34.9, it is MM, and kValue is 3..Likewise if the user decide to start searching by code, and decide to type 252.89 (see the last row in the table below) then he should get values from the corresponding cells as..description = garden, it is a DDD and kValue is 6.
i wish this to be my first android app and i do not have a clue on how to start, so please any idea and advice will be apreciated, i just started watching Bucky's video on android apps for beginners and i am just on the 5th video "Tour of the Interface".
please note the date i am planning to use is in excel file, just 1 sheet.
Thank you, please see the table sample below.
|Codes||Description||MM or DDD||kValue|