QuestionAsk Questions?
saurabh nahata
how to read columns values of excel file in java and store in array list in java like col1 col2 2 3 1 7 7 9 then list1 have values of col1 and list2 have values of col2...
View Answers
March 21, 2012 at 1:57 PM
import java.io.*;
import java.util.*;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
public class ReadExcel{
public static void main(String[]args){
short a=0;
short b=1;
int i=0;
ArrayList list1=new ArrayList();
ArrayList list2=new ArrayList();
String value1="", value2="";//,value3=" ", value4="";
String filename ="C:/data.xls";
if(filename != null && !filename.equals("")){
try{
FileInputStream fs =new FileInputStream(filename);
HSSFWorkbook wb = new HSSFWorkbook(fs);
for(int k = 0; k < wb.getNumberOfSheets(); k++){
int j=i+1;
HSSFSheet sheet = wb.getSheetAt(k);
int rows = sheet.getPhysicalNumberOfRows();
for(int r = 1; r < rows; r++){
HSSFRow row = sheet.getRow(r);
int cells = row.getPhysicalNumberOfCells();
HSSFCell cell1 = row.getCell(a);
value1 = cell1.getStringCellValue();
HSSFCell cell2 = row.getCell(b);
value2 = cell2.getStringCellValue();
list1.add(value1);
list2.add(value2);
}
i++;
}
}catch(Exception e){
}
}
System.out.println("List1 values : ");
for(int j=0;j<list1.size();j++){
System.out.println(list1.get(j).toString());
}
System.out.println("List2 values : ");
for(int j=0;j<list2.size();j++){
System.out.println(list2.get(j).toString());
}
}
}
March 21, 2012 at 1:57 PM
import java.io.*;
import java.util.*;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFCell;
public class ReadExcel{
public static void main(String[]args){
short a=0;
short b=1;
int i=0;
ArrayList list1=new ArrayList();
ArrayList list2=new ArrayList();
String value1="", value2="";//,value3=" ", value4="";
String filename ="C:/data.xls";
if(filename != null && !filename.equals("")){
try{
FileInputStream fs =new FileInputStream(filename);
HSSFWorkbook wb = new HSSFWorkbook(fs);
for(int k = 0; k < wb.getNumberOfSheets(); k++){
int j=i+1;
HSSFSheet sheet = wb.getSheetAt(k);
int rows = sheet.getPhysicalNumberOfRows();
for(int r = 1; r < rows; r++){
HSSFRow row = sheet.getRow(r);
int cells = row.getPhysicalNumberOfCells();
HSSFCell cell1 = row.getCell(a);
value1 = cell1.getStringCellValue();
HSSFCell cell2 = row.getCell(b);
value2 = cell2.getStringCellValue();
list1.add(value1);
list2.add(value2);
}
i++;
}
}catch(Exception e){
}
}
System.out.println("List1 values : ");
for(int j=0;j<list1.size();j++){
System.out.println(list1.get(j).toString());
}
System.out.println("List2 values : ");
for(int j=0;j<list2.size();j++){
System.out.println(list2.get(j).toString());
}
}
}
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
