Example usage for org.apache.poi.poifs.filesystem POIFSFileSystem POIFSFileSystem

Introduction

In this page you can find the example usage for org.apache.poi.poifs.filesystem POIFSFileSystem POIFSFileSystem.

Prototype


public POIFSFileSystem(InputStream stream) throws IOException

Source Link

Document

Create a POIFSFileSystem from an InputStream.

Usage

From source file:com.servoy.extensions.plugins.excelxport.ImportSelectFilePanel.java

License:Open Source License

public boolean isDone() {
    if (selectedFile == null)
        return false;
    try {/* ww  w.  j  ava 2 s  .  co  m*/
        POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream(selectedFile));
        HSSFWorkbook wb = new HSSFWorkbook(fs);
        state.setProperty("workbook", wb); //$NON-NLS-1$
        return true;
    } catch (Exception ex) {
        parent.reportError(Messages.getString("servoy.plugin.import.fileLoad.exception"), ex); //$NON-NLS-1$
        return false;
    }
}

From source file:com.sonicle.webtop.contacts.io.input.ContactExcelFileReader.java

License:Open Source License

private void readXlsContacts(File file, BeanHandler beanHandler) throws IOException, FileReaderException {
    POIFSFileSystem pfs = null;/*from www.j a  v a2 s  . c  o m*/
    InputStream is = null;
    HashMap<String, Integer> columnIndexes = listXlsColumnIndexes(file);

    try {
        pfs = new POIFSFileSystem(file);
        is = pfs.createDocumentInputStream("Workbook");
        XlsRowHandler rowHandler = new XlsRowHandler(this, columnIndexes, beanHandler);
        XlsRowsProcessor rows = new XlsRowsProcessor(is, headersRow, firstDataRow, lastDataRow, sheet,
                rowHandler);
        rows.process();

    } finally {
        IOUtils.closeQuietly(is);
        IOUtils.closeQuietly(pfs);
    }
}

From source file:com.sonicle.webtop.core.io.input.ExcelFileReader.java

License:Open Source License

public List<String> listXlsSheets(File file) throws IOException, FileReaderException {
    POIFSFileSystem pfs = null;/*from  w  ww. ja v  a 2 s .co m*/
    InputStream is = null;

    try {
        pfs = new POIFSFileSystem(file);
        is = pfs.createDocumentInputStream("Workbook");
        XlsSheetsProcessor processor = new XlsSheetsProcessor(is);
        processor.process();
        return processor.sheetNames;

    } finally {
        IOUtils.closeQuietly(is);
        IOUtils.closeQuietly(pfs);
    }
}

From source file:com.sonicle.webtop.core.io.input.ExcelFileReader.java

License:Open Source License

public HashMap<String, String> listXlsColumnNames(File file) throws IOException, FileReaderException {
    POIFSFileSystem pfs = null;//from   w  w w  . j av a 2s.co m
    InputStream is = null;

    try {
        pfs = new POIFSFileSystem(file);
        is = pfs.createDocumentInputStream("Workbook");
        XlsColumnsProcessor processor = new XlsColumnsProcessor(is, headersRow, firstDataRow, lastDataRow,
                sheet);
        processor.process();
        return processor.columnNames;

    } finally {
        IOUtils.closeQuietly(is);
        IOUtils.closeQuietly(pfs);
    }
}

From source file:com.sonicle.webtop.core.io.input.ExcelFileReader.java

License:Open Source License

public HashMap<String, Integer> listXlsColumnIndexes(File file) throws IOException, FileReaderException {
    POIFSFileSystem pfs = null;/*from w w  w  .j  a  v a2  s.  c  o m*/
    InputStream is = null;

    try {
        pfs = new POIFSFileSystem(file);
        is = pfs.createDocumentInputStream("Workbook");
        XlsColumnsProcessor processor = new XlsColumnsProcessor(is, headersRow, firstDataRow, lastDataRow,
                sheet);
        processor.process();
        return processor.columnIndexes;

    } finally {
        IOUtils.closeQuietly(is);
        IOUtils.closeQuietly(pfs);
    }
}

From source file:com.synct.report.bm10101_1.java

/**
 *<br>GX/* w  w w. ja va2  s  . com*/
 *<br>G L
 *<br>^Gboolean
 */
public synchronized boolean outXLS(String userid, String[] wherestring) throws Exception {
    try {
        separator = System.getProperty("file.separator");
        fs = new POIFSFileSystem(new FileInputStream(getPath() + "template" + separator + execlfilename));
        wb = new HSSFWorkbook(fs);
        sheet = wb.getSheetAt(0);
        sheet1 = wb.getSheetAt(1);
        sheet2 = wb.getSheetAt(2);
        sheet3 = wb.getSheetAt(3);
        ps = sheet.getPrintSetup();
        sheet.setAutobreaks(false);
        sheet1.setAutobreaks(false);
        sheet2.setAutobreaks(false);
        sheet3.setAutobreaks(false);
        execOut(userid, wherestring);
    } catch (Exception e) {
        throw new Exception(e);
        //System.err.println("outXLS error is "+e);
        //return false;
    }
    return true;
}

From source file:com.synct.report.bm10101_2.java

/**
 *<br>GX/*from w  w  w.j av  a  2s  . c o m*/
 *<br>G L
 *<br>^Gboolean
 */
public synchronized boolean outXLS(String userid, String[] wherestring) throws Exception {
    try {
        separator = System.getProperty("file.separator");
        fs = new POIFSFileSystem(new FileInputStream(getPath() + "template" + separator + execlfilename));
        wb = new HSSFWorkbook(fs);
        sheet = wb.getSheetAt(0);
        sheet1 = wb.getSheetAt(1);
        sheet2 = wb.getSheetAt(2);
        sheet3 = wb.getSheetAt(3);
        ps = sheet.getPrintSetup();
        sheet.setAutobreaks(false);
        sheet1.setAutobreaks(false);
        sheet2.setAutobreaks(false);
        sheet3.setAutobreaks(false);

        execOut(userid, wherestring);
    } catch (Exception e) {
        throw new Exception(e);
        //System.err.println("outXLS error is "+e);
        //return false;
    }
    return true;
}

From source file:com.synct.report.bm10104.java

/**
 *<br>GX/*from   w  w  w . ja va  2s  .c  o m*/
 *<br>G L
 *<br>^Gboolean
 */
public synchronized boolean outXLS(String userid, String[] wherestring) throws Exception {
    try {
        separator = System.getProperty("file.separator");
        fs = new POIFSFileSystem(new FileInputStream(getPath() + "template" + separator + execlfilename));
        wb = new HSSFWorkbook(fs);
        sheet = wb.getSheetAt(0);
        ps = sheet.getPrintSetup();
        sheet.setAutobreaks(false);
        execOut(userid, wherestring);
    } catch (Exception e) {
        throw new Exception(e);
        //System.err.println("outXLS error is "+e);
        //return false;
    }
    return true;
}

From source file:com.synct.report.cm40101.java

/**
 *<br>//from  w  w w. jav  a2s  .co  m
 *<br>
 *<br>
 */
public synchronized boolean outXLS(String userid, String[] wherestring) throws Exception {
    try {
        separator = System.getProperty("file.separator");
        fs = new POIFSFileSystem(new FileInputStream(getPath() + "template" + separator + execlfilename));
        wb = new HSSFWorkbook(fs);
        sheet = wb.getSheetAt(0);
        sheet2 = wb.getSheetAt(1);
        sheet3 = wb.getSheetAt(2);
        ps = sheet.getPrintSetup();
        sheet.setAutobreaks(false);

        execOut(userid, wherestring); //
    } catch (Exception e) {
        throw new Exception(e);
        //System.err.println("outXLS error is "+e);
        //return false;
    }
    return true;
}

From source file:com.tacitknowledge.util.migration.jdbc.loader.ExcelFileLoader.java

License:Apache License

/**
 * Obtains a database connection, reads a file assumed to be in Excel
 * format based on the name provided <code>getName()</code>.  Calls the
 * abstract method <code>processWorkbook()</code>
 *
 * @param ctx the <code>JdbcMigrationContext</code>
 * @throws MigrationException if an unexpected error occurs
 */// w  w w  .ja  v  a  2  s  . c  o  m
public void migrate(MigrationContext ctx) throws MigrationException {
    DataSourceMigrationContext context = (DataSourceMigrationContext) ctx;
    FileLoadingUtility utility = new FileLoadingUtility(getName());
    Connection conn = null;

    try {
        conn = context.getConnection();
        POIFSFileSystem fs = new POIFSFileSystem(utility.getResourceAsStream());
        HSSFWorkbook wb = new HSSFWorkbook(fs);
        processWorkbook(wb, conn);
        context.commit();
    } catch (IOException e) {
        log.error("An IO Exception occurred while trying to parse the Excel file.", e);
        context.rollback();
        throw new MigrationException("Error reading file.", e);
    } catch (SQLException e) {
        log.error("Caught a SQLException when trying to obtain a database connection");
        context.rollback();
        throw new MigrationException("Error obtaining database connection", e);
    } finally {
        SqlUtil.close(conn, null, null);
    }
}