poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Anthony Andrews <pythonadd...@yahoo.com>
Subject RE: AW: can we convert excel 95 to excel 97
Date Tue, 25 Jul 2006 14:48:36 GMT
Ravi

Have tried a few times now but I cannot send the code successfully to you. It was originally
in a .zip archive that was rejected, so I unzipped it and attached just the .java code file
only to be told that was too large. So, I have uploaded the file to Rapidshare so that you
can download it if you wish; just follow this link

http://rapidshare.de/files/26967348/Excel_OLE.zip

and you can use the free option beacuse the file is so small. Once you have the arcive, unzip
it into a separate folder and then red the 'read-me.rtf' file.

Must admit that VB would be my preferred option. If I remember correctly, there are OLE controls
available in Visual Studio and it would be easy to use one of these to execute the correct
VBA code to automate the file copies.

Hope this helps.

ravi shankar <anupindi.shankar@oracle.com> wrote: Hi All,
     I am having the following requirement.
       1.We are having excel 95 sheets in database in BLOB column.
       2.I need to read those files and store it back into excel 97 format
so that we can use POI.
     So what I am looking for is.. to use some third party APIs through
which I can read the files from database
     and while saving the APIs should provide me the option to save it back
in 97 format.
     That is what I am looking for.

     Yesterday "Karl" has pointed to me OOo as one of the alternatives,which
can be used to accomplish this.


     Anthony,If you can share the code which you are talking of then it will
be well and good.
     Moroever I will try to use the code snippets which "Tom" has send in
the mean while.


     If there is any way I can do this from VB5 then it will be the best
option,so that we can simply run the exe and
     everything is done behind the progress bar.
Regards
Ravi


-----Original Message-----
From: KHZ (SAW) [mailto:karl-heinz.zengerle@sawag.com]
Sent: Monday, July 24, 2006 9:43 PM
To: 'POI Users List'
Subject: AW: AW: can we convert excel 95 to excel 97


Hi.

I assumed that the product shall be cost-free (as POI is). I also thought
the same.

In a newer Excel version you have the possibilities of Visual Basic. So you
also have database access etc and that all at the much simpler macro level.

Regards, Karl-Heinz.


-----Urspr�ngliche Nachricht-----
Von: Anthony Andrews [mailto:pythonaddict@yahoo.com]
Gesendet: Montag, 24. Juli 2006 18:06
An: POI Users List
Betreff: Re: AW: can we convert excel 95 to excel 97

Ravi,

This may sound stupid but why not use Excel to do the work for you? All you
need to do is open each document using Excel 97 and then save it again
making sure you select the correct version.

If you only have a few sheets, then you could do this manually, otherwise,
why not look at automating the process using OLE? There are classes
contained within the Eclipse SWT package that make it possible to use Java
to control OLE enabled applications. Of course, this means you would have to
get to grips with the Excel object model as you would need to execute 'macro
code' to control the process. However, you could use Excel's macro recorder
to help you out - record the commands necessary to open an Excel95 file and
then save it again in Excel97 format. Then use the classes within the OLE
package and control the whole process using Java - opening each file and
then saving in the required format all using Excel driven by Java code.

Somewhere, I do have some code that illustrates how to use these classes and
would be happy to e-mail it to you if you would like - and assuming I can
find it all of course. But remember, Microsoft advise against controlling an
OLE enabled application from third party code in this manner - Excel was not
designed to be used in a non-interactive manner; it often relies on human
intervention to solve problems.

Tom Schindl 
 wrote: KHZ (SAW) schrieb:
> Hi Ravi.
>
> There are code snippets which you find in the internet and in the
> documentation (some directory of the installation; as it's some time away
> don't ask me about the exact name).
>

http://codesnippets.services.openoffice.org/Office/Office.ConvertDocuments.s
nip

Tom

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/




---------------------------------
See the all-new, redesigned Yahoo.com.  Check it out.



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/



---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/



 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
Mime
  • Unnamed multipart/alternative (inline, 8-Bit, 0 bytes)
View raw message