Post date: Jul 7, 2015 3:47:58 PM

***********************************************

Read Any File With Apache Tika - tika-app-1.4.jar

import java.io.File;

import java.io.FileInputStream;

import java.io.FileNotFoundException;

import java.io.InputStream;

import java.io.IOException;

import org.apache.tika.*;

import org.apache.tika.exception.TikaException;

import org.apache.tika.metadata.Metadata;

import org.apache.tika.parser.AutoDetectParser;

import org.apache.tika.parser.ParseContext;

import org.apache.tika.sax.BodyContentHandler;

import org.xml.sax.*;

class ReadAnyFilewithTika {

public static void main(String[] args) throws FileNotFoundException, IOException, org.xml.sax.SAXException, TikaException {

File file = new File("test.xls");

InputStream is = new FileInputStream(file);

Metadata metadata = new Metadata();

BodyContentHandler ch = new BodyContentHandler();

AutoDetectParser parser = new AutoDetectParser();

String mimeType = new Tika().detect(file);

metadata.set(Metadata.CONTENT_TYPE, mimeType);

parser.parse(is, ch, metadata, new ParseContext());

is.close();

for(int i = 0; i < metadata.names().length; i++){

String item = metadata.names()[i];

System.out.println(item + " -- " + metadata.get(item));

}

System.out.println(" -- ");

System.out.println(ch.toString());

}

}

******************************************************

******************************************************

Read/Write Excel File With ApachePOI - poi-bin-3.9-20121203

import java.io.*;

import java.util.Iterator;

import javax.xml.transform.TransformerException;

import org.apache.poi.hssf.eventusermodel.examples.XLS2CSVmra;

import org.apache.poi.hssf.extractor.ExcelExtractor;

import org.apache.poi.hssf.usermodel.*;

import org.apache.poi.poifs.filesystem.POIFSFileSystem;

import org.apache.poi.ss.usermodel.*;

public class ReadExcel {

public static void main(String[] args) throws IOException, TransformerException {

try {

FileInputStream file = new FileInputStream(new File("test.xls"));

//Get the workbook instance for XLS file

HSSFWorkbook workbook = new HSSFWorkbook(file);

//Get first sheet from the workbook

HSSFSheet sheet = workbook.getSheetAt(0);

//Iterate through each rows from first sheet

Iterator<Row> rowIterator = sheet.iterator();

while (rowIterator.hasNext()) {

Row row = rowIterator.next();

//For each row, iterate through each columns

Iterator<Cell> cellIterator = row.cellIterator();

while (cellIterator.hasNext()) {

Cell cell = cellIterator.next();

switch (cell.getCellType()) {

case Cell.CELL_TYPE_BOOLEAN:

System.out.print(cell.getBooleanCellValue() + "\t");

break;

case Cell.CELL_TYPE_NUMERIC:

System.out.print(cell.getNumericCellValue() + "\t");

break;

case Cell.CELL_TYPE_STRING:

System.out.print(cell.getStringCellValue() + "\t");

break;

}

}

System.out.println("---");

}

file.close();

System.out.println("\n---------Easy Method 1 Now----------------\n");

InputStream inp = new FileInputStream("test.xls");

HSSFWorkbook wb = new HSSFWorkbook(new POIFSFileSystem(inp));

ExcelExtractor extractor = new ExcelExtractor(wb);

extractor.setFormulasNotResults(false);

extractor.setIncludeSheetNames(true);

extractor.setIncludeCellComments(true);

String text = extractor.getText();

System.out.println(text);

System.out.println("\n---------Easy Method 2 Now----------------\n");

XLS2CSVmra xls2csv = new XLS2CSVmra("test.xls", 0);

xls2csv.process();

System.out.println(xls2csv.toString());

} catch (FileNotFoundException e) {

e.printStackTrace();

} catch (IOException e) {

e.printStackTrace();

}

}

}

***************************************************************