Forum
>
java code read xls file
Welcome, Guest

java code read xls file
Topic Normal java code read xls file
by Nitin on 07/18/2009 18:43

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;
     }

 }


Topic Normal Java code to remove repeated element from an array
by Charan on 07/21/2009 10:36

 

     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[i]))
              {
                  integerArrayList.add(repArr[i]);
              }
          }
          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[i]);
          }