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

How to Insert a Row 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 insert a new row in Excel Spread sheet.

File Name  :  
com/bethecoder/tutorials/jexcelapi/write/InsertRowTest.java 
Author  :  Sudhakar KV
Email  :  kvenkatasudhakar@gmail.com
   
package com.bethecoder.tutorials.jexcelapi.write;

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

import jxl.Workbook;
import jxl.format.Border;
import jxl.format.BorderLineStyle;
import jxl.format.Colour;
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 InsertRowTest {

  /**
   @param args
   @throws IOException 
   @throws IOException 
   @throws WriteException 
   @throws BiffException 
   */
  public static void main(String[] argsthrows IOException, WriteException {
    //Creates a writable workbook with the given file name
    WritableWorkbook workbook = Workbook.createWorkbook(new File("C:/JXL/InsertRow.xls"));
    WritableSheet sheet = workbook.createSheet("My Sheet"0);
    
    // Create cell font and format
    WritableFont cellFont = new WritableFont(WritableFont.TIMES, 16);
    cellFont.setColour(Colour.BLUE);
    
    WritableCellFormat cellFormat = new WritableCellFormat(cellFont);
    cellFormat.setBackground(Colour.ORANGE);
    cellFormat.setBorder(Border.ALL, BorderLineStyle.THIN);
    
    Label lable = null;
    int insertRow = 2;
    
    for (int i = ; i < ; i ++) {
      sheet.insertRow(insertRow)//Insert new row at row 2 [Moves the row 2 to next row]
      lable = new Label(0, insertRow, "Cell in Row [i=" + i + "]", cellFormat);
      sheet.addCell(lable);
    }
    
    //Writes out the data held in this workbook in Excel format
    workbook.write()
    
    //Close and free allocated memory 
    workbook.close()
  }

}
   

It gives the following output,
insert-row.gif


                    Print

   



Books Recommendation

 
 
bl  br