Here is how I did it, using an ad hoc odbc data source (no need for the tag)
var c = "";
var stmnt = "";
var rs = "";
var sql = "Select * from [#sheetName#$]";
var myQuery = "";
arguments.filename = expandPath(arguments.filename);
if(len(trim(arguments.filename)) and fileExists(arguments.file
On Friday 17 Jul 2009, John McSwishton wrote:
> I purchased a CFX from http://www.emerle.net/programming/, CFX_Excel2Query
> but I keep getting this error: java.lang.ClassNotFoundException:
> cfx_excel2query.jar, tags folder=classes/
> Is this a problem with the CFX or my installation?
Where did
Not exactly an answer to your question...but:
http://cflib.org/udf/parseExcel
On Fri, Jul 17, 2009 at 1:18 PM, John McSwishton wrote:
>
> I purchased a CFX from http://www.emerle.net/programming/, CFX_Excel2Query
> but I keep getting this error: java.lang.ClassNotFoundException:
> cfx_excel2quer
I purchased a CFX from http://www.emerle.net/programming/, CFX_Excel2Query
but I keep getting this error: java.lang.ClassNotFoundException:
cfx_excel2query.jar, tags folder=classes/
Is this a problem with the CFX or my installation?
TIA
~
Alan Rother wrote:
> I agree
>
> These tags are worth it.
I'll add my "me too" here, they work like a charm!
Used to be free though, but well worth the money in my opinion.
--
Met vriendelijke groet / Kind regards
Mingo J. Hagen.
E-Line Websolutions B.V.Herenweg 160
2101 MT Heemstede
I agree
These tags are worth it.
--
Alan Rother
Macromedia Certified Advanced ColdFusion MX 7 Developer
~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240490
Archives: http://www.houseoffusion.com/cf_lists/threa
Charles,
I use that cfx for importing 10,000+ recordsets into a db weekly. It works
great. It's fast and well worth the money. Go for it.
Emmet
-Original Message-
From: Charles Spersky [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 13, 2006 9:05 AM
To: CF-Talk
Subject: Excel2
Has anyone had any experience with these tags?
CFX_Query2Excel
http://www.emerle.net/programming/display.cfm/t/cfx_excel2query
CFX_Query2Excel
http://www.emerle.net/programming/display.cfm/t/cfx_query2excel
They seem really great for my needs. My client has several different Excel
files that ne
Hello Everyone,
Since many people have gotten use out of my custom tag CSV2Query, i
figured i would post this announcement that i have written a Java-based
CFX tag for bringing Excel worksheets into ColdFusion without the use of
COM. It's 100% java-based and free :)
You can grab a copy from he
9 matches
Mail list logo