ColdFusion 9 uses the Apache POI project to create Excel spreadsheets. You can access all of the bits natively to create multiple sheets. You can find tons of info about POI here: http://poi.apache.org/
On Tue, Oct 11, 2011 at 3:50 PM, Matthew Nicholson < [email protected]> wrote: > Afternoon All!**** > > ** ** > > I’ve got a issue that I’ve been mulling over and curious if I’m just making > this more difficult on myself the necessary.**** > > ** ** > > To begin, I’ve got this delightfully (and obnoxiously) detailed HTML form > that is currently being piped out to an excel file for user consumption. > This whole system works perfectly until the client starts looking for > multiple sets of data to be displayed. **** > > ** ** > > I’d like to potentially pipe this information into a PDF (and then make > multiple pages)**** > > Or continue to pipe out the data to excel and use multiple sheets.**** > > ** ** > > On the code side of things I define:**** > > ** ** > > <cfcontent type="application/vnd.ms-excel">**** > > <cfheader name="Content-Disposition" value="filename=#time_cards.xls#">*** > * > > ** ** > > Now this handles my initial file load for a single data set swimmingly but > when multiple sets are needed, things begin to get less then desirable. ** > ** > > ** ** > > Thoughts? Suggestions?**** > > ** ** > > As always, thank you all for your time and expertise!**** > > ** ** > > *Matthew R. Nicholson* > > *SolTech, Inc.* > > *www.soltech.net* > > *(p) 404.601.6000, Ext 233* > > *(c) 770.833.5326* > > *Yes. We can get you there.* **** > > ** ** > > ------------------------------------------------------------- > 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 FusionLink <http://www.fusionlink.com> > ------------------------------------------------------------- -- Dawn
