What's a CSV file? >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:210863 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