how to save a excel file using POI

2007-05-18 Thread Raghav
Hi Experts, I am reading a excel file from my file system (E:/myFile.xls) using the POIFS package. Using the POI package for excel, I modify the contents of this file. My question here is, how do I save back this same file to the file system. I am not able to get the writing stream to this

Want to save a excel file after opening it

2007-05-18 Thread Raghav
Hi Experts, I am reading a excel file from my file system (E:/myFile.xls) using the POIFS package. Using the POI package for excel, I modify the contents of this file. My question here is, how do I save back this same file to the file system. I am not able to get the writing stream to this

Re: how to save a excel file using POI

2007-05-18 Thread Rajeshwar Mothe
Hi raghava just write it into an out put stream and use request.getOutputStream(); it will give an option to save then save it if it is not still clear then reply me with u r entire code snippet i will help u cheers RAJESHWAR VALUE LABS , INDIA

Re: how to save a excel file using POI

2007-05-18 Thread Raghav
Rajeshwar, I was able to modify the file and save it back. Thanks for your help Raghav - To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi

Re: Want to save a excel file after opening it

2007-05-18 Thread Nick Burch
On Fri, 18 May 2007, Raghav wrote: My question here is, how do I save back this same file to the file system. I am not able to get the writing stream to this because it is still open by POIFS. Call write on your workbook:

Re: how to save a excel file using POI

2007-05-18 Thread Raghav
Rajeshwar Mothe rajkishan.m at gmail.com writes: Hi raghava just write it into an out put stream and use request.getOutputStream(); it will give an option to save then save it if it is not still clear then reply me with u r entire code snippet i will help u cheers

Re: how to save a excel file using POI

2007-05-18 Thread Rajeshwar Mothe
hey raghav is it the thing u did if not send me u r code snippet and thanks for sending intresting querys and where r u working now and how the culture in u r company import java.io.*; import org.apache.poi.hssf.usermodel.HSSFWorkbook; import org.apache.poi.hssf.usermodel.HSSFCell; import

Re: how to save a excel file using POI

2007-05-18 Thread Rajeshwar Mothe
hey raghav its intresting i think u did with overriding output stream i suppose. just send the code snippet just to watch and good work keep it up u rock it Cheers RAJESHWAR

Re: reading MS word file

2007-05-18 Thread Henry Lu
Where do i download the org.textmining package? -Henry Dmitry Goldenberg wrote: Henry, There are a few things you can try. 1. Take a look at org.textmining's Word text extractor: org.textmining.text.extraction.WordExtractor All you have to do is this: new

Re: reading MS word file

2007-05-18 Thread Henry Lu
Can somwone tell me where to download the svn package for POI? -Henry - To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project:

Re: reading MS word file

2007-05-18 Thread Nick Burch
On Fri, 18 May 2007, Henry Lu wrote: Can somwone tell me where to download the svn package for POI? You can either do a svn checkout yourself, and build it with ant: http://jakarta.apache.org/site/cvsindex.html Or download nightly builds from:

RE: reading MS word file

2007-05-18 Thread Dmitry Goldenberg
http://textmining.org/ From: Henry Lu [mailto:[EMAIL PROTECTED] Sent: Fri 5/18/2007 7:22 AM To: POI Users List Subject: Re: reading MS word file Where do i download the org.textmining package? -Henry Dmitry Goldenberg wrote: Henry, There are a few

Also getting Coding Error: Expected ExpPtg to be converted from Shared to Non-Shared Formula exception

2007-05-18 Thread Karr, David
I would have responded to the original chain on this, but I already deleted that from my email. I just noticed a new exception in my POI-based application: Coding Error: Expected ExpPtg to be converted from Shared to Non-Shared Formula I tried downloading the latest release (the ftp

Re: Shared formulas

2007-05-18 Thread dkarr
kix wrote: Hi, I use POI to import quite large and complex Excel files having a lot of formulas. Some of these formulars are stored as shared formulas. I can open the file, but when I try to call HSSFFormulaEvaluator.evaluate() I get a RecordFormatException on some cells: