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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210795
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
