tl  tr
  Home | Tutorials | Articles | Videos | Products | Tools | Search
Interviews | Open Source | Tag Cloud | Follow Us | Bookmark | Contact   
 Excel > JExcel API > How to Fill a Form in Excel Spreadsheet

How to Fill a Form in Excel Spreadsheet 

Java Excel API is an open source java library to read, write and modify Excel spread sheets. This requires the library jxl-2.6.12.jar to be in classpath. The following example shows how to fill a form by copying an existing Excel Workbook template.

form-template.gif

File Name  :  
com/bethecoder/tutorials/jexcelapi/modify/FillAFormTest.java 
Author  :  Sudhakar KV
Email  :  [email protected]
   
package com.bethecoder.tutorials.jexcelapi.modify;

import java.io.File;
import java.io.IOException;

import jxl.Workbook;
import jxl.format.Alignment;
import jxl.format.Border;
import jxl.format.BorderLineStyle;
import jxl.format.VerticalAlignment;
import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableCellFormat;
import jxl.write.WritableFont;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;

public class FillAFormTest {

  /**
   @param args
   @throws IOException 
   @throws WriteException 
   @throws BiffException 
   */
  public static void main(String[] argsthrows IOException, WriteException, BiffException {
    //Creates a writable workbook with the given file name
    Workbook template = Workbook.getWorkbook(new File("C:/JXL/Form-template.xls"));
      WritableWorkbook wbCopy = Workbook.createWorkbook(
          new File("C:/JXL/Form-result.xls"), template);
      
    WritableSheet sheet = wbCopy.getSheet("Form");
    
    String candidateName = "Venkata Sudhakar";
    String interviewType = "Telephonic";
    String interviewerName = "Sriram";
    
    /**
     * Create cell formats
     */
    WritableFont cellFont = new WritableFont(WritableFont.TAHOMA, 10);
    WritableCellFormat labelFormat = new WritableCellFormat(cellFont);
    labelFormat.setAlignment(Alignment.LEFT);
    labelFormat.setVerticalAlignment(VerticalAlignment.CENTRE);
    labelFormat.setBorder(Border.ALL, BorderLineStyle.THIN);
    
      /**
       * Add cells
       */
    sheet.addCell(new Label(11, candidateName, labelFormat));
    sheet.addCell(new Label(13, interviewType, labelFormat));
    sheet.addCell(new Label(15, interviewerName, labelFormat));
    
    //Writes out the data held in this workbook in Excel format
    wbCopy.write()
    
    //Close and free allocated memory 
    wbCopy.close()
  }

}
   

It gives the following output,
form-result.gif


 
  


  
bl  br