Using JXL to edit an existing excel sheet withe new data

[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();
        }
}
}

[Edit: added code tags, removed urgent from subject line, ignored shouting]

[Martijn Verburg]

Hi m sandeep and welcome to Javaranch!

I would look at your variables and where they are pointing to very carefully, perhaps splitting the read from sheet 1 and write to sheet 2 into separate methods will help clarify.

[m sandeep]

thanks for your reply.
Can you please elabourate on what you are saying ,If possible can you please paste a code of what you are exacting saying.

I cant lose data from excel 2 i just what even data from excel1 to excel2.

Suppose i have 10 names in excel 1 and 5 names in excel 2 .I want to add the 10 names of excel 1 to excel 2 and make it 25.But i am not sure that how many names will be in excel 2 .So i want to know how to find an empty cell in an excel???

[Bear Bibeault]

Please read: EaseUp

[patil kasinath]

File f1=new File("c:/sandeepNew/sandy1.xls");
can you please specify the code for path where my file is in server, so how can i read this file
i used ContextPath() method to get path and i mention like this
new File("path/files/test.xls");
im getting FileNotFoundException.
can you please help me, how can i mention path to get that file.

[patil kasinath]

patil kasinath wrote: File f1=new File("c:/sandeepNew/sandy1.xls");
can you please specify the code for path where my file is in server, so how can i read this file
i used ContextPath() method to get path and i mention like this
new File("path/files/test.xls");
im getting FileNotFoundException.
can you please help me, how can i mention path to get that file.