I've searched the site and this forum and surprisingly, I can't find anything about the implementation of this tag, except that HMS was kind enough to provide it for use.

I visited the creator's page for this--his support is zero and his details are not helpful with the error that I'm having.

My code has varied as I have experimented... I'm reaching the limits of infinity I think.

The errors are all the same, but on each parameter. I have removed parameters until I have nothing at all left except the only two parameters required by the tag and it STILL fails.

Example code (stripped to one of the slim/clean tries):


Note:
I've tried the formfield name with and without pound signs.
I've tried it with a filename hardcoded in rather than a formfield.
I've tried the custom tag in and out of a cfoutput tag.
I've rearranged the parameters.

for the code quoted above, I get this error:


For every parameter no matter what value is in there (for example, sheetName="MySources" or headerRow="1") I get this kind of error: UNKNOWN ATTRIBUTE: SHEETNAME null

It gives me a null error no matter what, on every parameter of the tag. This has got to be pretty simple I assume (despite how much time I've wasted on it...) but even google is failing me. Thanks a ton for any help.

PJ

This thread mentions the same problem.
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:54245#293229

In short, the poster says the correct attribute is "r_qResults", not "name".
<cfx_excel2query r_qResults="importthis" file="#form.importxls#">

Thank you so much!!

Got it to work with this code:



However, there are parameters that are SUPPOSED to work with this tag, that don't seem to, which is... well, most of them. All of them get a NULL error when used. (Perhaps the specific options supposed to be entered on that parameter are incorrect, but the coder's example does not say.) The main one I wanted being "headerRow" -- so you can specify (with row "1" in the spreadsheet) the name of your columns, rather than it defaulting to COLUMN1, COLUMN2 etc.

However, I'm very happy this is now resolved. (I wish the creator of this tag actually had code that worked on his website, gee, ya think? Wasted a lot of time on this!) Thanks for your help!

PJ

Yes, it does seem as if the author changed some of the attribute names. So there is a disconnect between the sample code and the actual jar version. You might email the author and mention this ..

Anyway, one of the README files mentions a FirstRowIsHeader parameter. If your header is in the first row, try the attribute: FirstRowIsHeader="true".

Update: This page seems to contain more accurate attribute names. Though I did not try all of them.

http://www.cftagstore.com/tags/cfxexcel2query.cfm

<cfx_excel2query
file="[path_to_xls_file]"
firstRowIsHeader="[true|false]"
sheet_name="[worksheet_name]"
sheet_num="[worksheet_number]"
startRow="[starting_row]"
maxRows="[max_rows]"
longNames="[true|false]"
r_qResults="[query_variable_name]">[/b]