The PDF option looks to be the most ideal (especially if I can just convert html to PDF from CFDocument.) I wasn't sure where to even begin on that side of things.
I'll dig around and see what I can scrounge up, thank you so much for the direction & assistance! Matthew R. Nicholson SolTech, Inc. www.soltech.net <http://www.soltech.net/> (p) 404.601.6000, Ext 233 (c) 770.833.5326 Yes. We can get you there. From: [email protected] [mailto:[email protected]] On Behalf Of Jason Delmore Sent: Tuesday, October 11, 2011 5:09 PM To: [email protected] Subject: Re: [ACFUG Discuss] PDFs / Excel Shenanigans I am not aware of a good way to merge in sheets from multiple workbooks. I know you can loop through the whole sheet and copy cell by cell. I suppose if your format were the same between every sheet you could make that work. You would need to copy formatting from the original sheet and then overlay the copied cells which will only have data. I suppose you could programmatically copy all the formatting cell by cell, but that might be painful. If PDF is an option, you could just use CFDocument to convert the HTML to PDF and then use CFPDF to append. I'm not sure exactly what you're looking for. Jason ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
