PHPExcel with SwiftMailer

Jul 19, 2011 at 11:36 AM

I've been trying for the last few days to use PHPExcel to generate an excel sheet on the fly that I can throw into SwiftMailer. I think I need the PHPExcel object in a readable format for the swiftmailer attachment class to interpret but that's the part I'm kinda racking my brain at. I tried using the XML writer but that didn't quite go as planned. If I pass the whole object I get an error that the base64 encoder in SwiftMailer fails. Anyone have any experience of how to do that?