poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Oliver Hirschi" <ohirs...@pm-medici.ch>
Subject setSheetOrder
Date Wed, 20 Apr 2005 06:42:58 GMT
Hi

Either there is a bug in setSheetOrder or I have done something wrong.
I have test it with POI 2.0RC2 and 2.5.1, but there is the same
behavior.

I have an excel-file (workbook.xls) containing three sheets:
Sheet-Pos    Name        Content of cell(0,0)
----------------------------------------------
0            AdFS2       "AdFS2"
1            Tabelle2    "Tabelle2"
2            Tabelle3    "Tabelle3"
----------------------------------------------

and the following code:
-----------------------
try {

  POIFSFileSystem fs = new POIFSFileSystem(new
FileInputStream("workbook.xls"));
  HSSFWorkbook wb = new HSSFWorkbook(fs);
  HSSFSheet sheet = wb.getSheet(sSheetName);

  if(sheet != null) {
    wb.removeSheetAt(wb.getSheetIndex(sSheetName));
  }
  sheet = wb.createSheet(sSheetName);
  wb.setSheetOrder(sSheetName, 0);

  if(sheet != null) {
    // Write the output to a file
    FileOutputStream fileOut = new FileOutputStream("workbook1.xls");
    wb.write(fileOut);
    fileOut.close();
  }
} catch(FileNotFoundException fnfe) {
  System.err.println(fnfe.getMessage());
} catch(IOException ioe) {
  System.err.println(ioe.getMessage());
}
-----------------------

I expect due to the code an excel-file (workbook1.xls) like:
Sheet-Pos    Name        Content of cell(0,0)
----------------------------------------------
0            AdFS2       ""
1            Tabelle2    "Tabelle2"
2            Tabelle3    "Tabelle3"
----------------------------------------------

But the excel-file (workbook1.xls) is:
Sheet-Pos    Name        Content of cell(0,0)
----------------------------------------------
0            Tabelle2    "Tabelle3"
1            Tabelle3    ""
2            AdFS2       "Tabelle2"
----------------------------------------------

Is there a bug in both versions (2.0RC2 and 2.5.1) or have I done a
mistake in the code?
I am really confused!?!?

By the way: I know, in this simple example I could also make "HSSFRow
row = sheet.getRow(0); if(row != null) sheet.removeRow(row);", to get
the expected result, but this is not the solution in my really
functionality.

Thanks, Kind Regards
-- 
Oliver Hirschi
http://www.FamilyHirschi.ch



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/


Mime
View raw message