Kód: Vybrať všetko

package com.ms.util;

//~--- non-JDK imports --------------------------------------------------------
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.xssf.usermodel.*;
//~--- JDK imports ------------------------------------------------------------
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.io.InputStream;
import java.util.Scanner;
import java.util.Iterator;
import java.io.File;
import java.io.FileWriter;
import java.io.IOException;
import java.io.PrintWriter;


/**
 * This java program is used to read the data from a Excel file and display them
 * on the console output.
 */
public class POIExcelReader {

	/** Creates a new instance of POIExcelReader */
	public POIExcelReader() {
	}

	/**
	 * This method is used to display the Excel content to command line.
	 * 
	 * @param xlsPath
	 */
	@SuppressWarnings("unchecked")
	public void displayFromExcel(String xlsPath) {
		InputStream inputStream = null;
		try {
			inputStream = new FileInputStream(xlsPath);
		} catch (FileNotFoundException e) {
			System.out.println("File not found in the specified path.");
			e.printStackTrace();
		}

		try {

			XSSFWorkbook workBook = new XSSFWorkbook(xlsPath);
			XSSFSheet sheet = workBook.getSheetAt(0);
			Iterator<Row> rows = sheet.rowIterator();

			while (rows.hasNext()) {
				XSSFRow row = (XSSFRow) rows.next();

				// display row number in the console.
				// System.out.println ("Row No.: " + row.getRowNum ());

				// once get a row its time to iterate through cells.
				// Iterator<XSSFCell> cells = row.cellIterator ();
				Iterator cells = row.cellIterator();

				while (cells.hasNext()) {
					XSSFCell cell = (XSSFCell) cells.next();

					// System.out.println ("Cell No.: " + cell.getCellNum ());

					/*
					 * Now we will get the cell type and display the values
					 * accordingly.
					 */
					switch (cell.getCellType()) {
					case XSSFCell.CELL_TYPE_NUMERIC: {

						// cell type numeric.
						// System.out.println ("Numeric value: " +
						// cell.getNumericCellValue ());
						System.out.println("" + cell.getNumericCellValue());

						break;
					}

					case XSSFCell.CELL_TYPE_STRING: {

						// cell type string.
						XSSFRichTextString richTextString = cell
								.getRichStringCellValue();

						// System.out.println ("String value: " +
						// richTextString.getString ());
						System.out.println("" + richTextString.getString());

						break;
					}

					default: {

						// types other than String and Numeric.
						System.out.println("Type not supported.");

						break;
					}
					}
				}
			}
		} catch (IOException e) {
			e.printStackTrace();
		}
	}

	/**
	 * The main executable method to test displayFromExcel method.
	 * 
	 * @param args
	 */
    public static void createFile(String name) {
    	   
        File file;
        try {
            file = new File(name);
            file.createNewFile();
        } catch(IOException vyjimka) {
            System.err.print(vyjimka);
        }
    }
	
	public static void main(String[] args)throws IOException {
		System.out.println("Specify fillepath.");
		String path = "";
		Scanner input = new Scanner(System.in);
		path = input.next();
		
		if (path.endsWith("xls")) {
			System.out.println("File not suported");				
		}
		else
		{
		
		System.out.println("______________________");
		POIExcelReader poiExample = new POIExcelReader();
		String xlsPath = path;
		poiExample.displayFromExcel(xlsPath);
		}
		
		String file = "novySoubor.xml";
        createFile(file);
        PrintWriter vystup = new PrintWriter(new FileWriter(file));
        vystup.println("Text, ktery se zapise do naseho souboru " + file +".");
        
        vystup.close();
	}
}