Monthly Archives: June 2011

Android: ScotchApp – How to parse Excel data and display it using a ListView and Dialog.

Some time ago, I had come across some interesting data about Scotch Whiskey.  I soon, decided to parse it and display it in an android app.  The app can be downloaded for free at the Android Market https://market.android.com/details?id=Scotch.App

scotchapp

This Scotch data can be downloaded here below.

http://www.bio.umontreal.ca/casgrain/en/labo/scotch.html

This file being parsed : scotch.xls

To get this Excel Data into my android java application:  Using Microsoft Excel, I simply saved it as a *.csv, opened it using notepad, and copy and pasted it into a string variable (String scotchData).

For each row of different Scotch, parse the appropriate columns for their values.

I also added a tasty photograph taken by Kyle May.

Continue reading