I guess I was wrong. I tried it myself and, as you know, you are correct. It
doesn't seem to work as you would expect it to.
---- [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]
