import java.util.*;
import java.io.*;
import jxl.*;
public class javaReadExcel
{
public static void main(String st[])
{
ArrayList a = javaReadExcel.readFile("testJava.xls");
}
public ArrayList readFile(String fileName)
{
ArrayList dataList=null;
try
{
dataList=new ArrayList();
Workbook workbook = Workbook.getWorkbook(new File("testJava.xls"));
String sheetName[]=workbook.getSheetNames();
Sheet sheet;
Cell xlsCell;
Cell[] cell;
for(int p=0; p<sheetName.length; p++)
{
sheet = workbook.getSheet(p);
for(int i=0; i<sheet.getRows(); i++)
{
cell = sheet.getRow(i);
for(int j=0; j<cell.length; j++)
{
xlsCell = sheet.getCell(j,i);
//dataList.add(xlsCell.getContents().toString());
System.out.println(xlsCell.getContents().toString());
}
}
}
}
catch(Exception exec)
{
System.out.print("Exception "+exec);
}
// return dataList;
}
}
Integer repArr = {1,2,3,2,4,5,6,2,6,1};
ArrayList<Integer> integerArrayList = new ArrayList<Integer>();
for( i=0; i<repArr.length;i++){
if(!integerArrayList.contains(repArr))
{
integerArrayList.add(repArr);
}
}
String[] refinedIntegerArray = {};
refinedIntegerArray = integerArrayList.toArray(new String[0]);
System.out.println("Array after removing Duplicate element: ");
for( i=0; i<refinedIntegerArray.length;i++){
System.out.println(refinedIntegerArray);
}
|
My Blog Title
|