RE: cffile: read in excel file
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
RE: cffile: read in excel file
OK CSV is some type of file format. I can export this file however I need to get the job done. I exported two ways: 1 - as a tab delimeted text file and 2 - as a CSV. They appear to be similar. Neither one of them seem to display line breaks on the web but they do break on rows when I view the files in a text editing program. Seem like I should be able to listtoarray() these if I could figure out the end-of-line and format the data first. While it would be nice to not have to export and make this a more general use tool, the important thing at the moment is to get the data in the db without typing it all again. All thoughts on this are welcome. 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 ~| 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:210864 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
RE: cffile: read in excel 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: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