Andy,
I've tried what you said but it doesn't work :
>If that doesn't work, take another step backwards. Use POIFS to read
>all the data in and write it back out uninterperated (just like you
>found it). You should NOT have to create a record in the Workbook.
Let's take this basic example :
POIFSFileSystem fs = new POIFSFileSystem(new FileInputStream("in.xls"));
FileOutputStream out = new FileOutputStream("out.xls");
fs.writeFilesystem(out);
out.close();
If "in.xls" is a clean MS Excel 2000 file (without macro) I can open the
result file "out.xls" in Excel without problem.
But if "in.xls" is the same file with one macro added, I can't open
"out.xls" back in Excel, I get a weird error message : "...file cannot be
accessed... read only file..." !
But the "out" file size is exactly the same as the "in" file size !
Shouldn't the output file be written back exactly as the source file ??? I
mean at least with the same content ?
Because I did a diff on the output of POIFSViewer and BiffViewer for both
tests (with and without macro) and there are exactly the same !!!
There must be something screwed up somewhere when the source file contains
other stuff (like a macro) !
Christian
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>