Android Question Help on excel library

[apty]

I have an excel worksheet with the following fields:

Name  Address Date  Amount
A      ABC      XX    1253
B      BHCN     IJ    2156

I would like to select only name and amount and display on labels (I treat name as the primary key in this case). Is this possible in basic4android? Kindly assist

 

[apty]

Can anyone help me please

 

[DonManfred]

I dont think that you can read xls or the newer versions....

But you can export your sheet as CSV. That file can be easily parsed and getting the infos you need/want...

 

[DonManfred]

If you are familar with php then you could use
https://code.google.com/p/php-excel-reader/
to parse and extract the data

1. Upload xls (not xlsx) from you app to your webserver
2. call the php-script from your app which reads the xls and response the data as jsonstring back to your app

 

[apty]

I can easily convert the file to CSV..how will I select only the columns I want if the file is CSV?

 

[NJDude]

Read the StringUtils library documentation, especially the LoadCSV part.

 

[apty]

The stringutils loads the entire CSV file. I need only specific columns

 

[NJDude]

Well, parse it.

 

[apty]

How can I parse it?

 

[DonManfred]

Read the file line for line
split one line (with Regex.split) on each "," to get the values of this line...
iterate through all lines to get the values you need.

But i prefer to suggest to read the beginners guide. Do your first steps and then you use the forum search to find examples of how to do the above...

 

[NJDude]

Regex Split is not the right way to parse a CSV, using StringUtils will load the CSV into a List and the rows are an array, there are samples posted on the forums.

There's also the Excel library.

 

[Erel]

As NJDude wrote you can use the Excel library to open XLS files and read any cell you like.

 

[apty]

Hi Erel,
Please help with a sample code to read a cell. The example code for excel library reads entire file. I need only specific cells

 

[Erel]

Dim workbook1 As ReadableWorkbook
Dim moviesSheet As ReadableSheet
workbook1.Initialize(Dir, FileName)
moviesSheet = workbook1.GetSheet(0)
Log(moviesSheet.GetCellValue(0, 0))
Log(moviesSheet.GetCellValue(0, 1))

 

[apty]

Thanks Erel, I will try this