poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Amir Hossein Sharifzadeh" <amirsharifza...@gmail.com>
Subject Re: corrupt after rewriting
Date Tue, 26 Jun 2007 10:51:11 GMT
I never open my excel "project.xsl" by Microsoft Excel, First I read file
from Excel by FileInputStream , then I close that, and I rewrite by
FileOutputStream.
That is not problem, I told I corrupt some data.
Would you please show me sample code for rewriting.
Thanks a lot
-- Sharifzadeh


On 6/26/07, Dónal Doyle <Donal.Doyle@idiro.com> wrote:
>
> Should you be saving the file as project.xls and not project.xsl?
>
> Donal Doyle
> Idiro Technologies
> Synergy Centre, ITT Dublin,
> Tallaght, Dublin 24, Ireland
>
> T +353.1.657.2956
> M+353.86.876.1952
> F +353.1.443.0582
> E: donal.doyle@idiro.com
>
>
> -----Original Message-----
> From: Amir Hossein Sharifzadeh [mailto:amirsharifzadeh@gmail.com]
> Sent: 26 June 2007 11:38
> To: user@poi.apache.org
> Subject: corrupt after rewriting
>
> Dear Sir/ Madam
> I need to read from Excel, change some data and rewrite in same excel like
> these codes:
> ==============================================================
> // reading
> .....
> POIFSFileSystem poifsFileSystem;
> ........
> hssfWorkbook = new HSSFWorkbook(poifsFileSystem, false);
>
> // change data from some cells in hssfWorkbook
> ....
> ....
>
>
> //  Rewriting:
> ......
>                FileOutputStream outputStream =
>                    new FileOutputStream(CONFIG_PATH);
>                hssfWorkbook.write(outputStream);
>                outputStream.close();
> ==============================================================
>
> after writing, when I open again this file, I see this file was damaged
> and
> many content of my data have lost. I get this warning:
> Excel file unreachable content in 'project.xsl'. Do you want to recover
> the
> content of this workbook?......
> please help me how can I rerwrite to Excel file without these problems.
> Thanks a lot
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message