read a excel file into java array list

[anvi kon]

Can anyone give me some examples to read an excel file and store the contents of excel file into arraylist?

[Henry Wong]

There is an open sourced project specifically for this... It may be a good idea to start there.

http://poi.apache.org/

Henry

[anvi kon]

Is it possible iwth jxl?

I don't see any examples?

I am reading a excel file like bleow.

Workbook book = Workbook.getWorkbook(file.getInputStream());

Sheet sheet = book.getsheet(0);

Bean b = new Bean();
ArrayList list = new ArrayList();

for(in t i=1; i< sheet.getRow(); i++)
{

String name = sheet.getCell(0, i).getContents();

and so on.....


//add to a bean.

b.setName(name);

and so on...

}

I want to add a ArrayList..

Is that possible.?

Please let me know...

Thanks









}

[Rob Spoor]

Please UseCodeTags. But yes, it's possible with JExcelAPI as well.

The trick is to create the bean instances inside the loop. In pseudo code

for all rows
{
    Bean b = new Bean();
    b.setName(cell 0);
    ...
    list.add(b);
}