java - Can't read Excel 2010 file with Apache POI. First Row number is -1 -

-

i trying testfile apache poi api (current version 3-10-final). following test code 

import java.io.fileinputstream; import org.apache.poi.xssf.usermodel.xssfsheet; import org.apache.poi.xssf.usermodel.xssfworkbook;  public class exceltest {      public static void main(string[] args) throws exception {         string filename = "testfile.xlsx";         xssfworkbook wb = new xssfworkbook(new fileinputstream(filename));         xssfsheet sheet = wb.getsheetat(0);         system.out.println(sheet.getfirstrownum());     } }

results in first row number -1 (and existing rows come null). test file created excel 2010 (i have no control on part) , can read excel without warnings or problems. if open , save file version of excel (2013) can read expected.

any hints why can't read original file or how can highly appreciated.

the testfile.xlsx created "spreadsheetgear 7.1.1.120". open xlsx file software can deal zip archives , /xl/workbook.xml see that. in worksheets/sheet?.xml files notice row elements without row numbers. if put row number in first row-tag <row r="1"> apache poi can read row.

if comes question, blame this, answer both apache poi , spreadsheetgear ;-). apache poi because attribute r in row element optional. spreadsheetgear because there no reason not use r attribute if excel ever.

if cannot testfile.xlsx in format can apache poi read directly, must work underlying objects. following works testfile.xlsx:

import org.apache.poi.xssf.usermodel.*; import org.apache.poi.ss.usermodel.*; import org.apache.poi.ss.util.*; import org.apache.poi.openxml4j.exceptions.invalidformatexception;  import java.io.filenotfoundexception; import java.io.ioexception; import java.io.fileinputstream; import java.io.inputstream;  import org.openxmlformats.schemas.spreadsheetml.x2006.main.ctworksheet; import org.openxmlformats.schemas.spreadsheetml.x2006.main.ctsheetdata; import org.openxmlformats.schemas.spreadsheetml.x2006.main.ctrow;  import java.util.list;  class testfile {   public static void main(string[] args) {   try {     inputstream inp = new fileinputstream("testfile.xlsx");    workbook wb = workbookfactory.create(inp);     sheet sheet = wb.getsheetat(0);     system.out.println(sheet.getfirstrownum());     ctworksheet ctworksheet = ((xssfsheet)sheet).getctworksheet();     ctsheetdata ctsheetdata = ctworksheet.getsheetdata();     list<ctrow> ctrowlist = ctsheetdata.getrowlist();     row row = null;    cell[] cell = new cell[2];     (ctrow ctrow : ctrowlist) {     row = new myrow(ctrow, (xssfsheet)sheet);     cell[0] = row.getcell(0);     cell[1] = row.getcell(1);     if (cell[0] != null && cell[1] != null && cell[0].tostring() != "" && cell[1].tostring() != "")         system.out.println(cell[0].tostring()+"\t"+cell[1].tostring());    }    } catch (invalidformatexception ifex) {   } catch (filenotfoundexception fnfex) {   } catch (ioexception ioex) {   }  } }  class myrow extends xssfrow {  myrow(org.openxmlformats.schemas.spreadsheetml.x2006.main.ctrow row, xssfsheet sheet) {   super(row, sheet);  } }

i have used org.openxmlformats.schemas.spreadsheetml.x2006.main.ctworksheet, org.openxmlformats.schemas.spreadsheetml.x2006.main.ctsheetdata, org.openxmlformats.schemas.spreadsheetml.x2006.main.ctrow. part of apache poi binary distribution poi-bin-3.10.1-20140818 , there within poi-ooxml-schemas-3.10.1-20140818.jar

for documentation see http://grepcode.com/snapshot/repo1.maven.org/maven2/org.apache.poi/ooxml-schemas/1.1/

and have extend xssfrow, because can't use xssfrow constructor directly since has protected access.


Comments

Post a Comment

Popular posts from this blog

matlab - "Contour not rendered for non-finite ZData" -

-
i'm trying plot frequency characteristic equation using ezplot, matlab gives following warning, "contour not rendered non-finite zdata". have used command plot frequency equations warning , plot display empty , not change axis range well. can please help. appreciated. here's code i'm using. % transfer matrix case-i, thin rotor clear all; clc; ei = 1626; l = 0.15; m = 0.44108; = 2.178*10^-4; i_p = 2.205*10^-5; itr = 0.24; i_pr = 0.479; syms p n; f = [1 l*1i l^2/(2*ei)*1i l^3/(6*ei); 0 1 l/ei -l^2/(2*ei)*1i; 0 0 1 -l*1i; 0 0 0 l]; p = [ 1 0 0 0; 0 1 0 0; 0 -it*p^2+i_p*n*p 1 0; -m*p^2 0 0 1]; p_r = [1 0 0 0; 0 1 0 0; 0 -itr*p^2+i_pr*n*p 1 0; -m*p^2 0 0 1]; = f*p*f*p*f*p*f; b = p_r*f*p*f*p*f; r = a(1,2)/a(1,4); a12_p = 0; a22_p = a(2,2)-r*a(2,4); a32_p = a(3,2)-r*a(3,4); a42_p = a(4,2)-r*a(4,4); ap(2,2) = a22_p; ap(3,2) = a32_p; ap(4,2) = a42_p; ap(4,4) = 1; c = b*ap; m = [c(3,2) c(3,4); c(4,2) c(4,...
Read more

delphi - Indy UDP Read Contents of Adata -

-
i using indy udp server read string of data. however, not know how work adata parameter. can around converting binary using bytetobin function below , convert hex using bintohex1 . feel stupid , works slow. know how can directly results without 2 conversions? thanks!! here codes: procedure tform1.idudpserver1udpread(athread: tidudplistenerthread; const adata: tidbytes; abinding: tidsockethandle); var buf: tidbytes; buffer: string; data_received: string; begin if bytestostring(adata) <> 'hello' begin buffer := hextostring('00'); setlength(buf, length(buffer)); copytidstring(buffer, buf, 0); abinding.sendto(abinding.peerip, abinding.peerport, buf); data_received := bintohex1(bytetobin(adata[1]) + bytetobin(adata[2]) + bytetobin(adata[3]) + bytetobin(adata[4]) + bytetobin(adata[5]) + bytetobin(adata[6]) + bytetobin(adata[7]) + bytetobin(adata[8]) + bytetobin(adata[9]) + bytetobin(adata[10]) + bytetobin(adata[11...
Read more

javascript - Any ideas when Firefox is likely to implement lengthAdjust and textLength? -

-
any ideas when firefox implement lengthadjust andtextlength?..... working svg application. lengthadjust , textlength working fine in chrome not working in fire fox . <svg viewbox = "0 0 500 300" version = "1.1"> <defs> <path id="s3" d="m 10,90 q 100,15 200,70" /> </defs> <g> <text font-size = "20"> <textpath xlink:href="#s3" textlength="205"> short text</textpath> </text> <use xlink:href="#s3" fill="none" stroke="black" stroke-width="1"/> </g> </svg> this implemented in firefox text elements (not textpath or tspan) in case that's ok though can move attribute text element. <svg viewbox = "0 0 500 300" version = "1.1"> <defs> ...
Read more