help in reading file.

[wanw84]

Hi.

Here's my problem.

I want to read excel file. The size is 50 by 50.
Now the problem is i want to select a portion from the excel table.
How I want to select the first 10 row and 10 columns and put it in vector
[a b c d e f g h i j] => first row
[a b c d e f g h i j] => second row
[a b c d e f g h i j] => third row
.
.
.
[a b c d e f g h i j] => tenth row

thanks in advance

[Eranga]

How did you read the first row. Show your attempt on that first.

[jack239]

You can use Jakarta POI HSSF API to read or write any MS format excel sheet. See the code snippet below-

To get a row- HSSFRow excelrow = sheet.getRow(0);
To get a cell: HSSFCell cell = excelrow.getCell((short)1); etc.