[cfaussie] Re: Creating Excel files with multiple worksheets
http://wikipedlla.com/creating_excel_files_with_multiple_worksheets Making an Excel files come out of your CF pages is pretty straight forward with tables and CFContent. Is there any way to make an Excel file that has multiple worksheets? The solutions I've found involve calling COM objects for a server copy of Excel, but my server doesn't have Excel installed so I can't use that method. How would you make a second (or third) worksheet in an Ecel output file without having Excel installed on the server? Regards Darren --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Creating Excel files with multiple worksheets
CF8 is not an option on this project yet. On Mar 27, 3:52 pm, Andrew Scott [EMAIL PROTECTED] wrote: I suppose you don't have the luxury of running it under Coldfusion 8:-) Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd.www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Darren Tracey Sent: Thursday, 27 March 2008 4:40 PM To: cfaussie Subject: [cfaussie] Creating Excel files with multiple worksheets Making an Excel files come out of your CF pages is pretty straight forward with tables and CFContent. Is there any way to make an Excel file that has multiple worksheets? The solutions I've found involve calling COM objects for a server copy of Excel, but my server doesn't have Excel installed so I can't use that method. How would you make a second (or third) worksheet in an Ecel output file without having Excel installed on the server? Regards Darren- Hide quoted text - - Show quoted text - --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Creating Excel files with multiple worksheets
Ok, Any of these work for you? http://www.activexls.com/products/java_professional.aspx?gclid=CL6SsY_ZrJICF QkvgwodslwRQg http://poi.apache.org/hssf/index.html -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Darren Tracey Sent: Thursday, 27 March 2008 5:10 PM To: cfaussie Subject: [cfaussie] Re: Creating Excel files with multiple worksheets CF8 is not an option on this project yet. On Mar 27, 3:52 pm, Andrew Scott [EMAIL PROTECTED] wrote: I suppose you don't have the luxury of running it under Coldfusion 8:-) Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd.www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Darren Tracey Sent: Thursday, 27 March 2008 4:40 PM To: cfaussie Subject: [cfaussie] Creating Excel files with multiple worksheets Making an Excel files come out of your CF pages is pretty straight forward with tables and CFContent. Is there any way to make an Excel file that has multiple worksheets? The solutions I've found involve calling COM objects for a server copy of Excel, but my server doesn't have Excel installed so I can't use that method. How would you make a second (or third) worksheet in an Ecel output file without having Excel installed on the server? Regards Darren- Hide quoted text - - Show quoted text - --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Creating Excel files with multiple worksheets
http://poi.apache.org/hssf/index.html Ben Nadel has written a nice CFC wrapper for some POI functionality. It has methods to create sheets and write excel files, though I've only used it for reading (which works well). http://www.bennadel.com/blog/624-ColdFusion-POIUtility-cfc-Updates-And-Bug-Fixes.htm Mark --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Creating Excel files with multiple worksheets
I second Ryan's suggestion. We have done it for our site, and there is no need for Java or other server extensions, just write out a properly formated Excel 2003+ XML file. As a bonus you to multiple worksheets, you also get formatting, cell sizing, text wrapping, etc. On Mar 27, 4:48 pm, Ryan Sabir [EMAIL PROTECTED] wrote: Generate it as XML.. 1. Manually create the spreadsheet in Excel, with the multiple worksheets. 2. Save it as XML 3. Examine the XML in a text editor and use your mad CF skillz to recreate the content dynamically 4. Profit! -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Darren Tracey Sent: Thursday, 27 March 2008 4:40 PM To: cfaussie Subject: [cfaussie] Creating Excel files with multiple worksheets Making an Excel files come out of your CF pages is pretty straight forward with tables and CFContent. Is there any way to make an Excel file that has multiple worksheets? The solutions I've found involve calling COM objects for a server copy of Excel, but my server doesn't have Excel installed so I can't use that method. How would you make a second (or third) worksheet in an Ecel output file without having Excel installed on the server? Regards Darren --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Creating Excel files with multiple worksheets
Yeah I would agree with Brontojoris...I have used code written as per Ryan's post, to output in Excel and it was pretty neat. On Mar 27, 8:40 pm, Brontojoris [EMAIL PROTECTED] wrote: I second Ryan's suggestion. We have done it for our site, and there is no need for Java or other server extensions, just write out a properly formated Excel 2003+ XML file. As a bonus you to multiple worksheets, you also get formatting, cell sizing, text wrapping, etc. On Mar 27, 4:48 pm, Ryan Sabir [EMAIL PROTECTED] wrote: Generate it as XML.. 1. Manually create the spreadsheet in Excel, with the multiple worksheets. 2. Save it as XML 3. Examine the XML in a text editor and use your mad CF skillz to recreate the content dynamically 4. Profit! -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Darren Tracey Sent: Thursday, 27 March 2008 4:40 PM To: cfaussie Subject: [cfaussie] Creating Excel files with multiple worksheets Making an Excel files come out of your CF pages is pretty straight forward with tables and CFContent. Is there any way to make an Excel file that has multiple worksheets? The solutions I've found involve calling COM objects for a server copy of Excel, but my server doesn't have Excel installed so I can't use that method. How would you make a second (or third) worksheet in an Ecel output file without having Excel installed on the server? Regards Darren --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Creating Excel files with multiple worksheets
Darren, besides the options mentioned so far, I'll note that I did a blog entry a couple months ago where I tried to gather in one place all the various ways, with links to resources with still more details: How can I process Excel files in CFML? Let me count the ways http://carehart.org/blog/client/index.cfm/2008/1/12/coldfusion_excel_xls_pro cessing BTW, I realize you're asking specifically about creating a file with multiple sheets. I haven't used each of these to be able to say which supports that, but I have to believe at least one of them would. Hope that's helpful. /charlie -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Darren Tracey Sent: Thursday, March 27, 2008 1:40 AM To: cfaussie Subject: [cfaussie] Creating Excel files with multiple worksheets Making an Excel files come out of your CF pages is pretty straight forward with tables and CFContent. Is there any way to make an Excel file that has multiple worksheets? The solutions I've found involve calling COM objects for a server copy of Excel, but my server doesn't have Excel installed so I can't use that method. How would you make a second (or third) worksheet in an Ecel output file without having Excel installed on the server? Regards Darren --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Creating Excel files with multiple worksheets
Generate it as XML.. 1. Manually create the spreadsheet in Excel, with the multiple worksheets. 2. Save it as XML 3. Examine the XML in a text editor and use your mad CF skillz to recreate the content dynamically 4. Profit! -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Darren Tracey Sent: Thursday, 27 March 2008 4:40 PM To: cfaussie Subject: [cfaussie] Creating Excel files with multiple worksheets Making an Excel files come out of your CF pages is pretty straight forward with tables and CFContent. Is there any way to make an Excel file that has multiple worksheets? The solutions I've found involve calling COM objects for a server copy of Excel, but my server doesn't have Excel installed so I can't use that method. How would you make a second (or third) worksheet in an Ecel output file without having Excel installed on the server? Regards Darren --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---
[cfaussie] Re: Creating Excel files with multiple worksheets
I suppose you don't have the luxury of running it under Coldfusion 8:-) Andrew Scott Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 9015 8628 Mobile: 0404 998 273 -Original Message- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Darren Tracey Sent: Thursday, 27 March 2008 4:40 PM To: cfaussie Subject: [cfaussie] Creating Excel files with multiple worksheets Making an Excel files come out of your CF pages is pretty straight forward with tables and CFContent. Is there any way to make an Excel file that has multiple worksheets? The solutions I've found involve calling COM objects for a server copy of Excel, but my server doesn't have Excel installed so I can't use that method. How would you make a second (or third) worksheet in an Ecel output file without having Excel installed on the server? Regards Darren --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups cfaussie group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~--~~~~--~~--~--~---