Bugreport: Reading a special DOC file triggers a NullPointerException

2006-07-28 Thread Leimbach, Johannes
Hello, I think I've found a bug in the lastest PIO word file reader. I try to read a Word document: - Title Überblick über Open Source und DMS - Author: Heßler - Num pages: 10 - Contains some tables and some graphics - DOT is Studie.dot - Filesize 116 kb The stacktrace I

Re: Bugreport: Reading a special DOC file triggers a NullPointerException

2006-07-28 Thread Nick Burch
On Fri, 28 Jul 2006, Leimbach, Johannes wrote: I think I've found a bug in the lastest PIO word file reader. Try using hwpf rather than hdf to read your word files - you might well have more luck with it Nick - To

AW: Bugreport: Reading a special DOC file triggers a NullPointerException

2006-07-28 Thread Leimbach, Johannes
Hello Nick, thanks for your response. Unfortunately the only documentation about reading .DOC in PIO used HDF. Can you provide me with some information on how to use HWPF? I have found some other DOC files which trigger either a NegativeArrayIndexException or an ArrayOutOfBounds exception. I

Re: AW: Bugreport: Reading a special DOC file triggers a NullPointerException

2006-07-28 Thread Nick Burch
On Fri, 28 Jul 2006, Leimbach, Johannes wrote: Unfortunately the only documentation about reading .DOC in PIO used HDF. Can you provide me with some information on how to use HWPF? http://jakarta.apache.org/poi/hwpf/ http://jakarta.apache.org/poi/hwpf/quick-guide.html I have found some other

Use POI to call Excel macro

2006-07-28 Thread Chaudhary, Harsh
Hi all, Is there a way I can use POI to call Excel macros? Harsh. - To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project:

AW: Use POI to call Excel macro

2006-07-28 Thread KHZ (SAW)
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

RE: Use POI to call Excel macro

2006-07-28 Thread Chaudhary, Harsh
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:[EMAIL PROTECTED] Sent:

Re: Use POI to call Excel macro

2006-07-28 Thread Oytun Askin (GMail)
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 [EMAIL PROTECTED] wrote:

RE: Use POI to call Excel macro

2006-07-28 Thread Chaudhary, Harsh
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

RE: Use POI to call Excel macro

2006-07-28 Thread Anthony Andrews
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

RE: Use POI to call Excel macro

2006-07-28 Thread Chaudhary, Harsh
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