-
Notifications
You must be signed in to change notification settings - Fork 0
/
Excel_Parser
90 lines (75 loc) · 2.45 KB
/
Excel_Parser
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
public class Excel_Parser
{
public static ArrayList<Integer> str=new ArrayList<Integer>();
public static int excelgetcountofrow(String Path,String Sheet)
{
int row = 0;
try
{
FileInputStream file=new FileInputStream(new File(Path));
//get the workbook instance for XLSX File
XSSFWorkbook workbook=new XSSFWorkbook(file);
//Get first sheet from the workbook
XSSFSheet sheet=workbook.getSheet(Sheet);
row=sheet.getLastRowNum();
}
catch(Exception e)
{
System.out.print("Exception caught while finding row number");
}
return row;
}
public static ArrayList<Integer> excelRreader(String Path,String Sheet,int rownumber)
{
ArrayList<Integer> col=new ArrayList<Integer>();
try
{
FileInputStream file=new FileInputStream(new File(Path));
//get the workbook instance for XLSX File
XSSFWorkbook workbook=new XSSFWorkbook(file);
//Get first sheet from the workbook
XSSFSheet sheet=workbook.getSheet(Sheet);
//Iterator through each rows from first sheet
// Iterator<Row> rowIterator =sheet.iterator();
//For each row, iterate through each columns
// while(rowIterator.hasNext())
{
Row row=sheet.getRow(rownumber);
//For each row, iterate through each columns
Iterator<Cell> cellIterator = row.cellIterator();
while(cellIterator.hasNext())
{
//Getting the cell contents
Cell cell =cellIterator.next();
//add the values of the cell to the Array-list
col.add((int) cell.getNumericCellValue());
}
file.close();
//print the value of the cells which is stored in the the Array-list
for (int i = 0; i < col.size(); i++){
double item = (double) col.get(i);
System.out.println("Index " + i + " : " + item);
}
} //Try block closes
catch (FileNotFoundException e)
{
e.printStackTrace();
}
catch (IOException e)
{
e.printStackTrace();
}
str=col;
return col;
}
public static List retrieveValuesFromListMethod2(List col)
{
//Retrieving values from list
int size = col.size();
for(int i=0;i<size;i++)
{
System.out.println(col.get(i));
}
return col;
}
}