transfer data between Excel sheets

[m sandeep]

Hi ,

i am having an excel sheet say excel1 annd i am having another excel sheet excel2 .I need to transfer the data of excel1 to excel2.Now my problem is whenever i am tring to do it the data present in excel2 is getting lost and new data rom excel1 is getting in excel2 .


Please suggest me with some code to do this .I NEED TO THIS ONLY WITH JXL NOT POI.

REPLY SOON

Thanks
sandeep
MY COde is BELOW

package Excel;   
import jxl.*;   
import jxl.Workbook;   
import jxl.read.biff.*;   
import java.io.File;   
import java.io.IOException;   
import jxl.write.WriteException;   
import java.util.Locale;   
import jxl.write.WritableSheet;   
import jxl.write.WritableWorkbook;   
import jxl.write.Label;    
    
public class CreateExcel {   
 /**  
  * @param args  
  */  
 public static void main(String[] args) throws IOException, WriteException, BiffException{   
  // TODO Auto-generated method stub   
  
final File  outputWorkbook;   
        try  
        {   
           
         File f1=new File("c:/sandeepNew/sandy1.xls");                                               //the excel sheet which contains data   
         WorkbookSettings ws=new WorkbookSettings();   
         ws.setLocale(new Locale("er","ER"));   
         Workbook workbook=Workbook.getWorkbook(f1,ws);    
            
         Sheet readsheet=workbook.getSheet(0);   
         System.out.println(readsheet.getName());     
         outputWorkbook = new File("c:/sandeepNew/sandy2.xls");                            // the excel sheet where data is to copied   
         WritableWorkbook workbook1=Workbook.createWorkbook(outputWorkbook,workbook);   
          WritableSheet sheet1 = workbook1.getSheet("mysheet");   
         int i=0,j=0;                                                                                               //following code copies the data from sandy1 to sandy2.xls   
  
         for(j=0;j<(readsheet.getColumns());j++){           
         for(i=0;i<readsheet.getRows();i++)  {             
              
          if(readsheet.getCell(j,i).getType()==(CellType.LABEL))       
          {   
              
           Label Name=new Label(j,i,readsheet.getCell(j,i).getContents());   
            sheet1.addCell(Name);   
               
               System.out.println(readsheet.getCell(j,i).getContents());    
          }   
          if(readsheet.getCell(j,i).getType()==(CellType.NUMBER)) {      
                    
              s=readsheet.getCell(j,i).getContents();         
         Label Name1=new Label(j,i,s);   
         sheet1.addCell(Name1);   
          System.out.println(readsheet.getCell(j,i).getContents());   
         }                  
            }   
         }   
         workbook1.write();   
      workbook1.close();   
            
         
        }   
        catch(IOException e)   
        {   
         e.printStackTrace();   
        }   
           
        catch(BiffException e)   
        {   
         e.printStackTrace();   
        }   
}   
}