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]
