Yes of course. Changing the sheet order is not the only thing I am doing on the workbook. But its the only thing that does not work. The suprising thing is that the inner representation which I inspected in debug mode does recognize the order modifications. The only (and most important) problem is that the generated XLS-file does not show the changes.
Best regards Matthias -----Ursprüngliche Nachricht----- Von: David Law [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 1. September 2007 08:18 An: POI Users List Betreff: Re: AW: Change sheet order in a workbook it worked fine for me. A stupid question: you are looking in the right directory for the files? (e.g. new FileInputStream("D:\\Temp\\apache.poi\\test.xls")) Regards from the Odenwald, DaveLaw [EMAIL PROTECTED] wrote: > That's the way I already tried it. But there is something I am doing wrong > because it still doesn't work. > > Let's assume I have an Excel-Workbook with three empty sheets called "aaa", > "bbb" and "ccc". > Now that is the code I use: > > HSSFWorkbook w = new HSSFWorkbook(new FileInputStream("test.xls")); > w.setSheetOrder("ccc", 0); w.setSheetOrder("bbb", 1); > w.setSheetOrder("aaa", 2); > > FileOutputStream fileOut = new FileOutputStream("test2.xls"); > w.write(fileOut); fileOut.close(); > > At the end there is a new Excel-Workbook named test2.xls with three sheets, > but still the order is "aaa", "bbb", "ccc". Why? > > Matthias > > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 28. August 2007 15:50 > An: POI Users List > Cc: Sondermann, Matthias > Betreff: Re: Change sheet order in a workbook > > It sounds like setSheetOrder is exactly what you need. Let's say you have > sheets named the following currently in the following order: > > Sheet1 > Sheet2 > Sheet3 > > You want them to be in the following order: > > Sheet2 > Sheet3 > Sheet1 > > You would make the following calls: > > workbook.setSheetOrder("Sheet2",0); > workbook.setSheetOrder("Sheet3",1); > workbook.setSheetOrder("Sheet1",2); > > ---- [EMAIL PROTECTED] wrote: > >> Hi, >> >> how can I order the sheets in a workbook? I found the method setSheetOrder >> and it changes something inside the workbook but the update is not visible. >> >> Greetings from Germany >> Matthias >> > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] For additional > commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
