Prev: coldfusion.runtime.CookieScope error in IE
Next: Web Service: Axis Fault??
From: baskark on 7 Dec 2006 04:24
hi everyone,
i got a form through with i upload the excel file.
these excel files are parsed through cfx_excel tags.

[b]is there any other instead of using cfx_excel query to read the values from
excel sheet?[/b]

thanks


From: Jibé on 7 Dec 2006 06:50
baskark a �crit :
> hi everyone,
> i got a form through with i upload the excel file.
> these excel files are parsed through cfx_excel tags.
>
> [b]is there any other instead of using cfx_excel query to read the values from
> excel sheet?[/b]
>
> thanks
>
>
You can do that witdh a datasource directly
(i don't know what cfx_excell is )

JiB�
From: MikerRoo on 7 Dec 2006 14:27
If the filename is constant, you can set up an odbc datasource and use that in
the CF administrator.
This requires Excel to be installed in the server which is a huge security
hole.

There is Apache POI, which you have been introduced to. With POI and a
little java skill, there is nothing you can't do with an excel file.

You can also set up an Access or MS SQL database to link to the excel file.

Finally, if the excel file is saved as CSV, it can be parsed by most DB's or
you can read it in and parse it yourself.

Anyway, cfx_excel works for many people's needs.
Why didn't it work for you?


From: baskark on 8 Dec 2006 01:34
Hi miker roo,
The cfx_excel tags is working fine.but iam unable to validate the header and
column values.
Is there any solution for this kind of problem.
Is there any sample solution for this please post it in the forum..

thanks for your valuable infofmation



From: MikerRoo on 8 Dec 2006 02:42
What do you mean you are unable to validate the header and column values?

Do you mean that you want the first row to become the query column name?

 |  Next  |  Last
Pages: 1 2 3 4
Prev: coldfusion.runtime.CookieScope error in IE
Next: Web Service: Axis Fault??