Mailing-List: contact dev-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Developers List" <dev@poi.apache.org>
Received-SPF: pass (nike.apache.org: domain of blagerweij@gmail.com designates
 209.85.214.54 as permitted sender)
MIME-Version: 1.0
Date: Thu, 14 Mar 2013 20:54:12 +0100
Message-ID: 
 <CAPH4kPhemegLTbHhHMOvDUMLb-KW6MawsDSGkDqVvg05B2hCWA@mail.gmail.com>
Subject: [Bug 52949] New: How to extract VBA Macros code from Excel file by
 using POI?
From: Barry Lagerweij <blagerweij@gmail.com>
To: dev@poi.apache.org
Content-Type: multipart/mixed; boundary=20cf3033455d063f7c04d7e7e388

--20cf3033455d063f7c04d7e7e388
Content-Type: multipart/alternative; boundary=20cf3033455d063f7904d7e7e386

--20cf3033455d063f7904d7e7e386
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I've been looking for a way to extract the source-code of VBA Modules and
macros using POI. Since POI does not provide access to this, I've written a
class which allows you to extract the sourcecode as text.

The two attached classes can be used together with POI (I've tested with
3.8 and 3.9) to process the vbaProject.bin (for ooxml) and XLS file and
retrieve the sources.

The RLEDecompressingInputStream is an InputStream which can be used to
decompress the chunks as described in the MS-OVBA specification. It wraps
around a compressed inputstream (ussually a DocumentInputStream from the
POIFS) and decompresses on the fly to preserve memory.

The VBAMacroExtractor processes the OLE binary stream records, records the
CodePage (in order to convert byte-arrays to Strings) and will store the
ModuleOffset. This offset specifies the location in the MemoryStream where
the sourcecode starts. The VBAMacroExtractor has been written to
automatically detect XLSM or XLS, and uses POIFSReader to process the file
only once and preserve memory.

It might be worthwhile to enhance the POI workbook with classes which
provide access to the VBA modules, see Andrey Yesyev's contributions to the
Nabble mailinglist.

I hope it's useful, feel free to use the sources under Apache2 license.

With kind regards,

Barry

--20cf3033455d063f7904d7e7e386
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<div><br></div><div style>I&#39;ve been looking for a w=
ay to extract the source-code of VBA Modules and macros using POI. Since PO=
I does not provide access to this, I&#39;ve written a class which allows yo=
u to extract the sourcecode as text.</div>
<div style><br></div><div style>The two attached classes can be used togeth=
er with POI (I&#39;ve tested with 3.8 and 3.9) to process the vbaProject.bi=
n (for ooxml) and XLS file and retrieve the sources.</div><div style><br>
</div><div style>The RLEDecompressingInputStream is an InputStream which ca=
n be used to decompress the chunks as described in the MS-OVBA specificatio=
n. It wraps around a compressed inputstream (ussually a DocumentInputStream=
 from the POIFS) and decompresses on the fly to preserve memory.</div>
<div style><br></div><div style>The VBAMacroExtractor processes the OLE bin=
ary stream records, records the CodePage (in order to convert byte-arrays t=
o Strings) and will store the ModuleOffset. This offset specifies the locat=
ion in the MemoryStream where the sourcecode starts. The VBAMacroExtractor =
has been written to automatically detect XLSM or XLS, and uses POIFSReader =
to process the file only once and preserve memory.</div>
<div style><br></div><div style>It might be worthwhile to enhance the POI w=
orkbook with classes which provide access to the VBA modules, see Andrey Ye=
syev&#39;s contributions to the Nabble mailinglist.</div><div style><br>
</div><div style>I hope it&#39;s useful, feel free to use the sources under=
 Apache2 license.</div><div style><br></div><div style>With kind regards,</=
div><div style><br></div><div style>Barry</div></div>

--20cf3033455d063f7904d7e7e386--

--20cf3033455d063f7c04d7e7e388
Content-Type: text/plain; charset=us-ascii


---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
--20cf3033455d063f7c04d7e7e388--