HSSF is for the Excel stuff. The Macros are outside the excel stuff. If you can't write this code (its really simple just takes maybe 30 minutes of research that I don't have cycles for) maybe you should contract to SuperLink? If you take a macro containing file and run the POIFS viewer and look at the code I pointed to this is very simple. You'll only require expanding your knowledge minimally assuming you understand the function of an archive (which is all the outer OLE 2 CDF file is).
On 11/19/03 4:59 AM, "Rizzo, Mike" <[EMAIL PROTECTED]> wrote: > Thanks, it doesn't make sense to me yet, but that's because I need to become > more familiar with POI and the Excel file format. What I'm really trying to > do is write a servlet that will scan an office doc and let us know if there > is any kind of VB, VBA, Macros (or whatever else can be in an office doc > that can cause a dialog box to be instantiated when the doc is opened). I'd > really like to not have to write an active x control in vb or vc++ and set > up some M$ servers -- and any chance I get to use an open source solution is > one that I will pursue. But as you can tell, I'm very new to the office > document file structure and to POI -- but luckily not to Java. > > I have the event api example from the HSSF website working, could this just > be another record type that I put in the switch statement? Or is it not that > easy? > > > > > > -----Original Message----- > From: Andrew C. Oliver [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 18, 2003 4:08 PM > To: POI Users List > Subject: Re: How to Determine if a Spreadsheet Contains Macros or VBA > > > Yes. Use the (org.apache.poi.poifs.dev.)POIFSViewer to get a more specific > name -- however if I recall you can look for a node in the POIFS document > tree called "VBA_MACRO". You can look at the > (o.a.p.h.usermodel.)HSSFWorkbook source to see how we walk the tree to copy > the macros. > > Does that Make sense? > > On 11/18/03 12:10 PM, "Rizzo, Mike" <[EMAIL PROTECTED]> wrote: > >> Hi, >> >> I would like to use POI to determine if a spreadsheet contains macros or >> VBA. Is this possible with POI? If so, how? >> >> Thanks, >> >> Mike Rizzo >> >> >> >> Please do not transmit orders or instructions regarding a UBS account by >> email. The information provided in this email or any attachments is not an >> official transaction confirmation or account statement. For your > protection, >> do not include account numbers, Social Security numbers, credit card >> numbers, passwords or other non-public information in your email. Because >> the information contained in this message may be privileged, confidential, >> proprietary or otherwise protected from disclosure, please notify us >> immediately by replying to this message and deleting it from your computer >> if you have received this communication in error. Thank you. >> >> UBS Financial Services Inc. >> UBS International Inc. >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Excel, Got POI? The views expressed in this email are those of the author and are almost definitely not shared by the Apache Software Foundation, its board or its general membership. In fact they probably most definitively disagree with everything espoused in the above email. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
