That is the fella yeah.
-Original Message-
From: Phill B [mailto:[EMAIL PROTECTED]
Sent: 14 September 2005 17:31
To: CF-Talk
Subject: Re: Create Excel file
Is this what you are referring to?
http://jakarta.apache.org/poi/
On 9/14/05, Robertson-Ravo, Neil (RX)
[EMAIL PROTECTED] wrote
Does CFREPORT use POI?
-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 15 September 2005 01:39
To: CF-Talk
Subject: Re: Create Excel file
You can use CFREPORT to create formatted Excel files very easily, using
query data but we don't
No.
Does CFREPORT use POI?
-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 15 September 2005 01:39
To: CF-Talk
Subject: Re: Create Excel file
You can use CFREPORT to create formatted Excel files very easily, using
query data but we don't
Didn't think so, but POI is available in CF7 yeah? So you could do multiple
tabbed sheets in CF7 easily via that.
-Original Message-
From: [EMAIL PROTECTED] [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 15 September 2005 11:59
To: CF-Talk
Subject: Re: Create Excel file
No.
Does
I had no idea I could use XML. Thanks for the info.
Phil
On 9/13/05, HOFLee _ [EMAIL PROTECTED] wrote:
You mean using just plain html/xml/cfoutput? If I remember correctly, you can
use XML schema for excel to create separate sheets. There are also other
options like POI, COM, etc. if you
Yep, I would certainly recommend using POI if you can.
-Original Message-
From: Phill B [mailto:[EMAIL PROTECTED]
Sent: 14 September 2005 16:27
To: CF-Talk
Subject: Re: Create Excel file
I had no idea I could use XML. Thanks for the info.
Phil
On 9/13/05, HOFLee _ [EMAIL PROTECTED
To: CF-Talk
Subject: Re: Create Excel file
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try
Check out this blog entry form Ray Camden:
http://ray.camdenfamily.com/index.cfm/2005/9/12/Ask-a-Jedi-Working-with-Excel
On 9/13/05, Phill B [EMAIL PROTECTED] wrote:
Is there a way to create an Excel spreadsheet with multiple tabs using
html and CF?
--
Phil
Is this what you are referring to?
http://jakarta.apache.org/poi/
Yes, that is POI. It is very good, but not quite as simple to use initially as
the html technique.
*As far as I know*, using the XML schema is the only way to create multiple
sheets with basic HTML. Other than that, as I said
You can use CFREPORT to create formatted Excel files very easily, using query
data but we don't currently support multi-tabbed Excel spreadsheets.
HTH
Damon
~|
Logware (www.logware.us): a new and convenient web-based time
Is there a way to create an Excel spreadsheet with multiple tabs using
html and CF?
--
Phil
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a
You mean using just plain html/xml/cfoutput? If I remember correctly, you can
use XML schema for excel to create separate sheets. There are also other
options like POI, COM, etc. if you are not limited to basic html/cf.
Is there a way to create an Excel spreadsheet with multiple tabs using
Hi,
Could you explain a little more on how u used these?
Thanks
I have used POI with great success - http://jakarta.apache.org/poi/ -
to read and write excel files. I've also used
http://jexcelapi.sourceforge.net/ on a couple of cf projects and it
worked well too. Both are pure java and allow
I found this rather helpful in showing how to use it. Although somethings I
never got to work as I expected them to.
http://www.d-ross.org/index.cfm?objectid=9C65ECEC-508B-E116-6F8A9F878188D7CA
On Apr 12, 2005 2:00 PM, Neelima Kaja [EMAIL PROTECTED]
wrote:
Hi,
Could you explain a little
Sure - I only have code right here that uses the jexcelapi one (the
POI is at home, but they basically work the same)
You add the jar to your cfmx classpath (google if you dont know) then
you do have access to the java libraries. For example to read an excel
file:
!--- create the excel java
I have used POI with great success - http://jakarta.apache.org/poi/ -
to read and write excel files. I've also used
http://jexcelapi.sourceforge.net/ on a couple of cf projects and it
worked well too. Both are pure java and allow you to create binary
versions xls files
Cheers
On Apr 4, 2005 7:57
G'day Scott
We are looking to use XML to generate Excel and Word files using CF. Your
example is great - thanks! Do you know of any other resources that would
assist us with doing this sort of thing? Have you run into any limitations or
problems?
We have an app that uses COM generate Excel
I would advise don't use com method if you can, com means that
you always have to use windows for your server. Also The process that
runs coldfusion on your server needs access to the registery to view
the com object, so potentially opens up more paths for hacking.
If you use have office xp ,
You could use CFX_ExcelQuery which is available at OpenXCF
(http://sourceforge.net/projects/openxcf). It allows you to read XLS
files as CF queries and write XLS files using CF queries.
-Matt
On Apr 16, 2004, at 10:07 PM, Johnny Le wrote:
I follow the article How to transfer records from SQL
I follow the article How to transfer records from SQL to Excel -- the better way from cfcomet.com and I got this error.What do I do?Please help.
An exception occurred when accessing a Com object field.
The cause of this exception was that: coldfusion.runtime.CfJspPage$ComplexObjectException:
20 matches
Mail list logo