help in reading file.
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
How did you read the first row. Show your attempt on that first.
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.