com.mycompany.devisetty_mavenlocalrepositorydemo.POIDriver.java Source code

Introduction

Here is the source code for com.mycompany.devisetty_mavenlocalrepositorydemo.POIDriver.java

Source

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package com.mycompany.devisetty_mavenlocalrepositorydemo;

import java.io.FileInputStream;
import java.io.IOException;
import org.apache.poi.hssf.extractor.ExcelExtractor;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

/**
 *
 * @author S525798
 */
public class POIDriver {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) throws IOException {
        // TODO code application logic here
        //Create POI file system object.
        POIFSFileSystem objPOIFileSystem = new POIFSFileSystem(new FileInputStream("sample.xls"));

        //Create a data extractor using file system object.
        ExcelExtractor datExtractor = new ExcelExtractor(objPOIFileSystem);

        //Extract data using extractor and print
        System.out.println(datExtractor.getText());

    }

}