Bug 58036 - [PATCH] XSSFWorkbook.setVBAProject()
Summary: [PATCH] XSSFWorkbook.setVBAProject()
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: unspecified
Hardware: PC Linux
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
Keywords: PatchAvailable
Depends on:
Reported: 2015-06-15 11:27 UTC by Chris Boyle
Modified: 2015-07-13 09:05 UTC (History)
1 user (show)

Patch to add XSSFWorkbook.setVBAProject() (16.20 KB, patch)
2015-06-15 11:27 UTC, Chris Boyle
Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Chris Boyle 2015-06-15 11:27:51 UTC
Created attachment 32822 [details]
Patch to add XSSFWorkbook.setVBAProject()

POI doesn't handle the binary format of VBA macros within an XSSF workbook, which is fair enough, but if you already have the bytes of such a macro file on hand, for example from an existing workbook, it would be nice if POI made it easy to insert those macros into a new workbook. The attached patch provides two new methods to address this.

  XSSFWorkbook.setVBAProject(InputStream vbaProjectStream)

  XSSFWorkbook.setVBAProject(XSSFWorkbook macroWorkbook)
  (convenience helper to obtain the stream from an existing workbook)
Comment 1 David North 2015-07-13 09:05:32 UTC
Patch applied. Fixed in r1690593