If you read an CSV file.. you can see directly the output
If you don't , you need to use one of the CFX_ tags to read excel
Using Java or COM Objects.
David Manriquez
[EMAIL PROTECTED]
(+56-2) 43 00 155
-----Mensaje original-----
De: Daniel Kessler [mailto:[EMAIL PROTECTED]
Enviado el: Martes, 28 de Junio de 2005 14:55
Para: CF-Talk
Asunto: cffile: read in excel file
I'm trying to read in an excel file and it does so, but the output is
crap. Well the data is in there, but there's alot of extraneous data
which shows up as unrecognizable characters. I thought that excel
was tab delimited with char returns at the end of each line. Maybe
I'm wrong for assuming this.
Is there a way to read this in where it just shows up in that way?
Should I export it differently first? Here's the code that I'm using.
<cftry>
<cffile
action="read"
file="#form.db_file#"
variable="file_contents">
<cfcatch type="Any">
#cfcatch.message#
</cfcatch>
</cftry>
file_contents:<br>#file_contents#
thanks!
--
Daniel Kessler
Department of Public and Community Health
University of Maryland
Suite 2387 Valley Drive
College Park, MD 20742-2611
301-405-2545 Phone
www.phi.umd.edu
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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 it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210798
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
