Hi,

windows 7 64 bits

jdk-7u60-windows-x64

netbeans-8.0-windows

 

My class is :

 

package com.test.ca.ti.tools.excel;
import java.io.BufferedInputStream;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.util.Iterator;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.hssf.usermodel.HSSFRow;
public class ExcelReader {
    public static void main(String[] args) {
        try {
            InputStream input = new BufferedInputStream(new FileInputStream("c:\\1.xlsx"));
            POIFSFileSystem fs = new POIFSFileSystem(input);
            HSSFWorkbook wb = new HSSFWorkbook(fs);
            HSSFSheet sheet = wb.getSheetAt(0);
            Iterator rows = sheet.rowIterator();
            while (rows.hasNext()) {
                HSSFRow row = (HSSFRow) rows.next();
                System.out.println("\n");
                Iterator cells = row.cellIterator();
                while (cells.hasNext()) {
                    HSSFCell cell = (HSSFCell) cells.next();
                    if (HSSFCell.CELL_TYPE_NUMERIC == cell.getCellType()) {
                        System.out.print(cell.getNumericCellValue() + " ");
                    } else if (HSSFCell.CELL_TYPE_STRING == cell.getCellType()) {
                        System.out.print(cell.getRichStringCellValue().getString() + " ");
                    } else if (HSSFCell.CELL_TYPE_BOOLEAN == cell.getCellType()) {
                        System.out.print(cell.getBooleanCellValue() + " ");
                    } else if (HSSFCell.CELL_TYPE_BLANK == cell.getCellType()) {
                        System.out.print("BLANK ");
                    } else {
                        System.out.print("Unknown cell type");
                    }
                }
            }
        } catch (IOException ex) {
            System.out.print(ex.getMessage());
        }
    }
}

 

My pom.xml is :

 

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.test.ca.ti.tools</groupId>
    <artifactId>Test</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>jar</packaging>
    <dependencies>
        <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.10-FINAL</version>
            <type>jar</type>
        </dependency>
    </dependencies>
    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <maven.compiler.source>1.7</maven.compiler.source>
        <maven.compiler.target>1.7</maven.compiler.target>
    </properties>
</project>

 

 

I get these errors hhen running my program :

 

at org.apache.poi.poifs.storage.HeaderBlock.<init>(HeaderBlock.java:131)
  at org.apache.poi.poifs.storage.HeaderBlock.<init>(HeaderBlock.java:104)
  at org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:128)
  at com.keurig.ca.ti.tools.excel.ExcelReader.main(ExcelReader.java:29)

 

the 29th line in my program is

POIFSFileSystem fs = new POIFSFileSystem(input);

 

Any help please!

 

Best regards!

FacebookTwitterLinkedin
Pin It
Joomla Tutorials for Beginners