Does not support .xls files (HSSF) yet

[mercury1231]

Currently only support .xlsx files (XSSF). Should be very straightforward to support HSSF since its part of Apache POI's capabilities.

[heyunxia]

you can modify the constructor function Xcelite(File file) like this:
public Xcelite(File file) {
try {
this.file = file;
//workbook = new XSSFWorkbook(new FileInputStream(file));
workbook = create(new FileInputStream(file));

    } catch (FileNotFoundException e) {
        throw new RuntimeException(e);
    } catch (IOException e) {
        throw new RuntimeException(e);
    }
}

/**
 * handle exception : Package should contain a content type part [M1.13]
 * @param in
 * @return
 */
public static Workbook create(InputStream in) {
    try {
        if (!in.markSupported()) {
            in = new PushbackInputStream(in, 8);
        }
        if (POIFSFileSystem.hasPOIFSHeader(in)) {
            return new HSSFWorkbook(in);
        }
        if (POIXMLDocument.hasOOXMLHeader(in)) {
            return new XSSFWorkbook(OPCPackage.open(in));
        }
    } catch (InvalidFormatException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    }
    throw new IllegalArgumentException("sorry, your file are not support now...");
}

[mercury1231]

Thanks! I didn't know that trick. It'd be nice if the author can add that
too.

2016-01-13 17:46 GMT+12:00 He Yunxia notifications@github.com:

you can modify the constructor function Xcelite(File file) like this:
public Xcelite(File file) {
try {
this.file = file;
//workbook = new XSSFWorkbook(new FileInputStream(file));
workbook = create(new FileInputStream(file));

} catch (FileNotFoundException e) {
    throw new RuntimeException(e);
} catch (IOException e) {
    throw new RuntimeException(e);
}

}

/**

• handle exception : Package should contain a content type part [M1.13]
• @PARAM in
• @return
  */
  public static Workbook create(InputStream in) {
  try {
  if (!in.markSupported()) {
  in = new PushbackInputStream(in, 8);
  }
  if (POIFSFileSystem.hasPOIFSHeader(in)) {
  return new HSSFWorkbook(in);
  }
  if (POIXMLDocument.hasOOXMLHeader(in)) {
  return new XSSFWorkbook(OPCPackage.open(in));
  }
  } catch (InvalidFormatException e) {
  e.printStackTrace();
  } catch (IOException e) {
  e.printStackTrace();
  }
  throw new IllegalArgumentException("sorry, your file are not support now...");
  }

—
Reply to this email directly or view it on GitHub
#2 (comment).

[CyborTronik]

I there any updates on that?

[mercury1231]

Well, you could easily clone the repo and just modify the source code by
yourself. Nobody seems to be maintaining it currently.

2016-04-15 3:48 GMT-07:00 CyborTronik notifications@github.com:

I there any updates on that?

—
You are receiving this because you authored the thread.
Reply to this email directly or view it on GitHub
#2 (comment)

[perNyfelt]

Using the WorkbookFactory would take care of this for you and be an even simpler change, i.e.:
public Xcelite(File file) {
try {
this.file = file;
workbook = WorkbookFactory.create(file);
} catch (Exception e) {
throw new RuntimeException(e);
}
}

[iSnow]

It's in the forked version now