Java Apache Poi SXSSF with Excel Macros
<p>I have a excel template that has macros (.xlsm), I want to read it in, add a million rows to it and write it out.</p>

<p>I know that reading and re-writing files with POI that contain macros will preserve the macros. I need to write out the excel using SXSSF (ram limitations), but SXSSF doesn't read files.</p>

<p>Question: How can I read in an excel with macros using XSSF, and then write out the excel with macros using SXSSF?</p>