[prev in list] [next in list] [prev in thread] [next in thread] 

List:       poi-user
Subject:    RE: Use POI to call Excel macro
From:       "Chaudhary, Harsh" <HCHAUDHA () amfam ! com>
Date:       2006-07-28 17:02:53
Message-ID: 9184F901B9329343B15CA661D1009B0504BFAD28 () NHQ1ACCOEX02VS1 ! corporate ! amfam ! com
[Download RAW message or body]

The macro copies over some relevant data form the actuary sheets in addition to other \
stuff. We use this data as reference data. But the actuary sheet is a peice of crap, \
i.e. not coded by a programmer. For example, it updates certain values only when you \
click on a certain cells etc. So, from time to time, you have to open up the sheets \
and click on certain cells to update the data, particularly date based data. This is \
what the macro did. Since our servers are AIX, we can't open sheets there. No, we \
cannot get the actuary to change his coding. End of rant, LOL
Harsh.

-----Original Message-----
From: Anthony Andrews [mailto:pythonaddict@yahoo.com] 
Sent: Friday, July 28, 2006 11:34 AM
To: POI Users List
Subject: RE: Use POI to call Excel macro


Which IDE do you use? If you use Eclipse and are lucky enough to have the SWT package \
installed - I think that it is a part of the core distribution - then you have access \
to a full set of classes that make it possible to use OLE to automate Excel and no \
worries about getting approval from aonywhere else. That could be one answer to your \
problem.

Just as an aside, how is the macro used to validate the results during testing? It is \
possible to create macros that will run when you open a workbook using Excel for \
instance. That may be one possible solution to your problem; create the worksheet \
using POI then have it validate itself when it is opened using Excel. Messy but it \
may work for you.

"Chaudhary, Harsh" <HCHAUDHA@amfam.com> wrote: Thanks for the link. Unfortunately, I \
don't think I will be able to use it as we have these blessed jars which have to get \
past SW Engg. before they can be added to the code base. Oh well, I guess I will have \
to make my local box point to the other tiers for testing them. Harsh.

-----Original Message-----
From: Oytun Askin (GMail) [mailto:oytun12@gmail.com] 
Sent: Friday, July 28, 2006 11:22 AM
To: POI Users List
Subject: Re: Use POI to call Excel macro


Hey there, try JaCob , they seem to have a good way of communicating with
most MS products from Java.
They are also mutli-thread aware.
The website is http://www.sourceforge.net/projects/jacob-project  i beileve.


Good luck, hope this helps.

On 7/28/06, Chaudhary, Harsh  wrote:
> 
> OK, I will take your word for it. I need to call a macro every time I run
> a jUnit test as my reference data comes from an Excel spreadsheet from an
> actuary. But the codebase itself is installed on a UNIX machine.
> Harsh.
> 
> -----Original Message-----
> From: KHZ (SAW) [mailto:karl-heinz.zengerle@sawag.com]
> Sent: Friday, July 28, 2006 11:15 AM
> To: 'POI Users List'
> Subject: AW: Use POI to call Excel macro
> 
> 
> Hi Harsh.
> 
> POI interpretes (read)/emulates (write) the physical structures of an
> Excel
> file.
> 
> Excel macros are COM programming on a higher level not having to take care
> for several COM details.
> 
> Being able to call Excel macros would mean that POI would reimplement all
> that things. Otherwise POI without having installed Office would be
> useless.
> 
> So I'm quite sure that such things are rather unlikely to be implemented
> at
> all.
> 
> Even things like OOo (Open Office) aren't able to call the VB macros.
> 
> Regards,        Karl-Heinz.
> 
> 
> -----Urspr�ngliche Nachricht-----
> Von: Chaudhary, Harsh [mailto:HCHAUDHA@amfam.com]
> Gesendet: Freitag, 28. Juli 2006 18:09
> An: POI Users List
> Betreff: Use POI to call Excel macro
> 
> Hi all,
> Is there a way I can use POI to call Excel macros?
> Harsh.
> 
> ---------------------------------------------------------------------
> 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/
> 
> ---------------------------------------------------------------------
> 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/
> 
> 


-- 
Oytun A�k�n
oytun12@gmail.com

---------------------------------------------------------------------
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!?
 Next-gen email? Have it all with the  all-new Yahoo! Mail Beta.

---------------------------------------------------------------------
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/


[prev in list] [next in list] [prev in thread] [next in thread]