From: baskark on
hi MikerRoo,
my first row is my header instead of excel cell header.but i overcome this
problem by skkiping the first row. this is fine .
[b] Problem [/b]
i got 3 rows each row contains 4 columns
in 2nd row 2nd column is null. instead of displaying null. it takes the next
column value and displays it (2nd row 3rd column value) and the last column
becomes null
i use this command
[b]
<cfx_ExcelQuery action = "read" file="#file_url#" sheet="0" variable="myExcel"
/>
<cfoutput>
<cfdump var = "#myExcel#">
</cfoutput>
[/b]

is there any possible solution .
thanks for you valuable information

From: MikerRoo on
Yes, I see that this is a design flaw in the cfx_ExcelQuery code.

If you can wait few days, I will fix this, and some other bugs, in that CFX.

Can you provide me a link to (You can PM me if needed) to the kind of files
you wish to read?



From: baskark on
hi mike
please post your email id .
i will send my excel files to you...


thanks and regards
baskar k
From: MikerRoo on
Ok. PM'd you with my email address.

From: di_wakar on
Hi every one,
to read a excel i am using cfx_ExcelQuery tag, but it doesn't support blank cell..any idea?