Tuesday 17 January 2012

Reading and writing data from Excel sheet using JExcel API

Using Java we can read the data from Excel sheets by creating type1 driver , but here we are taking help of JExcelapi we can able to read data directly from the Excel sheets.
Steps to be follow:
Step 1:
download JExcel api from here

Step2:
after downloading extract the zip file.
make jxl.jar available to your class path.

Step 3:
create a Excel sheet with some data

Step 4:
in this step we are reading data from the Excel sheet.
use the below java code:

package com.vaani.excel.jexcel;

import java.io.File;

import java.io.IOException;

import java.util.Date;

import jxl.*;

import jxl.read.biff.BiffException;
import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;
import jxl.write.WriteException;
import jxl.write.Number;

public class ReadWriteInExcel {


 public static void readExcelFile() throws IOException, BiffException {

  Workbook workbook = Workbook.getWorkbook(
    new File("---/././file.xls"));

  // my excel sheet name is contacts, iam given the complete path.
// iam reading data from the sheet1

  Sheet sheet = workbook.getSheet(0); 

  // here iam reading the data of 1st column data up three cells

  Cell a1 = sheet.getCell(0,0);
  Cell b2 = sheet.getCell(0,1);
  Cell c2 = sheet.getCell(0,2);

  //getting  the data from cells
  String stringa1 = a1.getContents();
  String stringb2 = b2.getContents();
  String stringc2 = c2.getContents();

  //printing the data
  System.out.println("a1–>"+stringa1);
  System.out.println("b2–>"+stringb2);
  System.out.println("c3–>"+stringc2);


 }

 public static void writeInExcelFile(String args[]) 
throws IOException, WriteException
 {
  // STEP 1:
  // the first step is to create a writable workbook using the 
factory method on the Workbook class.
  WritableWorkbook workbook = Workbook.createWorkbook(
new File("/some file.xls"));
  //test.xls is my work book
  // STEP 2:
  //// sheet name 
WritableSheet sheet = workbook.createSheet("First Sheet",0); 
  //STEP 3:
  //adding(inserting) name to the sheet at location (0,2)
  Label label = new Label(0,2,"A label record");
  sheet.addCell(label);
  //adding number to the sheet at location (1,2)
  Number number = new Number(1,2,3.1459);
  sheet.addCell(number);
  //Step 4:
  //close the all opened connections
  workbook.write();
  workbook.close();
 }


}



No comments:

Post a Comment