House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists 		Home /  Groups /  ColdFusion Talk (CF-Talk)

Reading from an Excel file through ColdFusion

  << Previous Post |  RSS |  Tree View |  Sort Oldest First |  Subscribe to this Group Next >> 

Reading from an Excel file through ColdFusion.

No worries dude. Ben Nadel 02/06/2007 06:12 PM
Ben, hussain shaikh 02/02/2007 01:45 AM
That's pretty cool...they should list that as a feature so we know about Eric Roberts 02/01/2007 10:48 PM
Hussain, Ben Nadel 02/01/2007 06:02 PM
Not sure there are any docs but it is in CF at the following location: it is Robertson-Ravo, Neil (RX) 02/01/2007 05:50 AM
Is there any docs on that...I never heard that before... Eric Roberts 01/31/2007 09:58 PM
One more thing Ben, hussain shaikh 01/31/2007 10:29 AM
You just need to give the permissions for that file to whatever user Peterson, Chris 01/31/2007 10:00 AM
Thanks Ben. hussain shaikh 01/31/2007 09:18 AM
It is indeed built in to ColdFusion, since 6.1 I think - maybe 7 but it is Robertson-Ravo, Neil (RX) 01/31/2007 02:56 AM
POI is built in?  Since when?  Last time I checked you had Eric Roberts 01/30/2007 10:32 PM
Even better...the Apache Jakarta project as a set of Java classes that can Eric Roberts 01/30/2007 10:28 PM
Mario, Ben Nadel 01/30/2007 02:00 PM
Ben, Ciliotta, Mario 01/30/2007 01:57 PM
Here is what we do in CF7. Jose Saenz 01/30/2007 12:36 PM
Hussain, Ben Nadel 01/30/2007 09:08 AM
Actually I finally found the link I was looking for. Forgot they changed Doug Brown 01/30/2007 08:48 AM
p.s Doug Brown 01/30/2007 08:38 AM
Here is a tag that will do just what you would like...hope it helps Doug Brown 01/30/2007 08:30 AM
Hi, hussain shaikh 01/30/2007 08:02 AM

02/06/2007 06:12 PM
Author: Ben Nadel Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268910 No worries dude. ..................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ Ben, It was a mistake on my part. Actually I implemented your code picked up from this link http://www.bennadel.com/index.cfm?dax=blog:472.view I guess the code present here is the older version with limited capabilities. I will try-out the stuff present in the link which you have posted here. Thanks, Hussain. ----- Excess quoted text cut - see Original Post for more -----
02/02/2007 01:45 AM
Author: hussain shaikh Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268409 Ben, It was a mistake on my part. Actually I implemented your code picked up from this link http://www.bennadel.com/index.cfm?dax=blog:472.view I guess the code present here is the older version with limited capabilities. I will try-out the stuff present in the link which you have posted here. Thanks, Hussain. ----- Excess quoted text cut - see Original Post for more -----
02/01/2007 10:48 PM
Author: Eric Roberts Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268403 That's pretty cool...they should list that as a feature so we know about it...thx Eric [mailto:Neil.Robertson-Ravo@csd.reedexpo.com] Sent: Thursday, 01 February 2007 04:46 To: CF-Talk Subject: RE: Reading from an Excel file through ColdFusion. Not sure there are any docs but it is in CF at the following location: it is being used by cfdocument (possibly other things) C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\lib\ Is there any docs on that...I never heard that before... Eric [mailto:Neil.Robertson-Ravo@csd.reedexpo.com] Sent: Wednesday, 31 January 2007 01:56 To: CF-Talk Subject: Re: Reading from an Excel file through ColdFusion. It is indeed built in to ColdFusion, since 6.1 I think - maybe 7 but it is still in the lib, as is iText. "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540.  It contains information which is confidential and may also be privileged.  It is for the exclusive use of the intended recipient(s).  If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.  If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.  The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com POI is built in?  Since when?  Last time I checked you had to add the java classes to CF... Eric Hussain, I have created a early beta for a ColdFusion component that wraps around a limited set of POI functionality for reading / writing Excel files. The best part of this is that POI is built into ColdFusion so there is nothing too sneaky going on here, nor does anything new need to be installed. Check it out: http://bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Rea d-And-Write-Excel-Files.htm OR http://www.bennadel.com/index.cfm?dax=blog:474.view Let me know if you have any questions. I am working on improving it as we speak, but this is what I have so far. .......................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ Hi, I want to read and parse through the excel files from coldfusion. Banged my head on the net but couldn't find anything :-( Even in CF documentation it's nowhere mentioned about reading an excel file from CF. This is the last hope of finding a solution. Thanks in advance. Hussain.
02/01/2007 06:02 PM
Author: Ben Nadel Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268366 Hussain, I am not sure why that would be erroring. I have tested with with multiple sheets and it seems to work nicely. It is, however, very early in the development stage, so it is bound to be buggy. If you send me the XLS file you are using, I can play around with it (ben [ .at. ] bennadel.com). ..................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ One more thing Ben, Why does your piece of code gives error when we have more than 1 sheet embedded in the excel file(Why the assumption that the excel should have a single sheet in it)? Hussain.
02/01/2007 05:50 AM
Author: Robertson-Ravo, Neil (RX) Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268301 Not sure there are any docs but it is in CF at the following location: it is being used by cfdocument (possibly other things) C:\JRun4\servers\cfusion\cfusion-ear\cfusion-war\WEB-INF\cfusion\lib\ Is there any docs on that...I never heard that before... Eric [mailto:Neil.Robertson-Ravo@csd.reedexpo.com] Sent: Wednesday, 31 January 2007 01:56 To: CF-Talk Subject: Re: Reading from an Excel file through ColdFusion. It is indeed built in to ColdFusion, since 6.1 I think - maybe 7 but it is still in the lib, as is iText. "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540.  It contains information which is confidential and may also be privileged.  It is for the exclusive use of the intended recipient(s).  If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.  If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.  The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com POI is built in?  Since when?  Last time I checked you had to add the java classes to CF... Eric Hussain, I have created a early beta for a ColdFusion component that wraps around a limited set of POI functionality for reading / writing Excel files. The best part of this is that POI is built into ColdFusion so there is nothing too sneaky going on here, nor does anything new need to be installed. Check it out: http://bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Rea d-And-Write-Excel-Files.htm OR http://www.bennadel.com/index.cfm?dax=blog:474.view Let me know if you have any questions. I am working on improving it as we speak, but this is what I have so far. ......................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ Hi, I want to read and parse through the excel files from coldfusion. Banged my head on the net but couldn't find anything :-( Even in CF documentation it's nowhere mentioned about reading an excel file from CF. This is the last hope of finding a solution. Thanks in advance. Hussain.
01/31/2007 09:58 PM
Author: Eric Roberts Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268291 Is there any docs on that...I never heard that before... Eric [mailto:Neil.Robertson-Ravo@csd.reedexpo.com] Sent: Wednesday, 31 January 2007 01:56 To: CF-Talk Subject: Re: Reading from an Excel file through ColdFusion. It is indeed built in to ColdFusion, since 6.1 I think - maybe 7 but it is still in the lib, as is iText. "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540.  It contains information which is confidential and may also be privileged.  It is for the exclusive use of the intended recipient(s).  If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.  If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.  The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com POI is built in?  Since when?  Last time I checked you had to add the java classes to CF... Eric Hussain, I have created a early beta for a ColdFusion component that wraps around a limited set of POI functionality for reading / writing Excel files. The best part of this is that POI is built into ColdFusion so there is nothing too sneaky going on here, nor does anything new need to be installed. Check it out: http://bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Rea d-And-Write-Excel-Files.htm OR http://www.bennadel.com/index.cfm?dax=blog:474.view Let me know if you have any questions. I am working on improving it as we speak, but this is what I have so far. ........................ Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ Hi, I want to read and parse through the excel files from coldfusion. Banged my head on the net but couldn't find anything :-( Even in CF documentation it's nowhere mentioned about reading an excel file from CF. This is the last hope of finding a solution. Thanks in advance. Hussain.
01/31/2007 10:29 AM
Author: hussain shaikh Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268202 One more thing Ben, Why does your piece of code gives error when we have more than 1 sheet embedded in the excel file(Why the assumption that the excel should have a single sheet in it)? Hussain.
01/31/2007 10:00 AM
Author: Peterson, Chris Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268196 You just need to give the permissions for that file to whatever user coldfusion is running as on your server.  I don't know about best practices in this, but I created a 'coldfusion' domain user with very specific permissions, and I run all my services as this user. Chris Peterson Thanks Ben. I am now able to parse through the excel file sucessfully. But how can I parse an excel file which is located in different server? Hussain.
01/31/2007 09:18 AM
Author: hussain shaikh Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268183 Thanks Ben. I am now able to parse through the excel file sucessfully. But how can I parse an excel file which is located in different server? Hussain.
01/31/2007 02:56 AM
Author: Robertson-Ravo, Neil (RX) Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268172 It is indeed built in to ColdFusion, since 6.1 I think - maybe 7 but it is still in the lib, as is iText. "This e-mail is from Reed Exhibitions (Gateway House, 28 The Quadrant, Richmond, Surrey, TW9 1DN, United Kingdom), a division of Reed Business, Registered in England, Number 678540.  It contains information which is confidential and may also be privileged.  It is for the exclusive use of the intended recipient(s).  If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful.  If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910.  The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions." Visit our website at http://www.reedexpo.com POI is built in?  Since when?  Last time I checked you had to add the java classes to CF... Eric Hussain, I have created a early beta for a ColdFusion component that wraps around a limited set of POI functionality for reading / writing Excel files. The best part of this is that POI is built into ColdFusion so there is nothing too sneaky going on here, nor does anything new need to be installed. Check it out: http://bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Rea d-And-Write-Excel-Files.htm OR http://www.bennadel.com/index.cfm?dax=blog:474.view Let me know if you have any questions. I am working on improving it as we speak, but this is what I have so far. ....................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ Hi, I want to read and parse through the excel files from coldfusion. Banged my head on the net but couldn't find anything :-( Even in CF documentation it's nowhere mentioned about reading an excel file from CF. This is the last hope of finding a solution. Thanks in advance. Hussain.
01/30/2007 10:32 PM
Author: Eric Roberts Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268165 POI is built in?  Since when?  Last time I checked you had to add the java classes to CF... Eric Hussain, I have created a early beta for a ColdFusion component that wraps around a limited set of POI functionality for reading / writing Excel files. The best part of this is that POI is built into ColdFusion so there is nothing too sneaky going on here, nor does anything new need to be installed. Check it out: http://bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Rea d-And-Write-Excel-Files.htm OR http://www.bennadel.com/index.cfm?dax=blog:474.view Let me know if you have any questions. I am working on improving it as we speak, but this is what I have so far. ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ Hi, I want to read and parse through the excel files from coldfusion. Banged my head on the net but couldn't find anything :-( Even in CF documentation it's nowhere mentioned about reading an excel file from CF. This is the last hope of finding a solution. Thanks in advance. Hussain.
01/30/2007 10:28 PM
Author: Eric Roberts Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268164 Even better...the Apache Jakarta project as a set of Java classes that can read/create/modify/delete office docs...including Excel.  It is called POI. In testing that I did at a former client, this process blows the pants off of using an Excel com object.  We testing this with the com object on a dual processor box and the POI code on a single processor box (the processors were all the same speed and both boxes had the same amount of memory and plenty of drive space and they were producing the same report).  The com object maxed out the processors for about 20 seconds...obviously stopping anything else from happening on the box.  The POI code blipped for about 4 seconds and was done.  If you do a search on CF and POI, you will find a site (d-ross.org I think) that shows you how to do this in CF. Eric Here is a tag that will do just what you would like...hope it helps http://www.emerle.net/programming/display.cfm/t/cfx_excel2query Doug B. > Hi, > I want to read and parse through the excel files from coldfusion. > Banged my head on the net but couldn't find anything :-( > Even in CF documentation it's nowhere mentioned about reading an excel file from CF. > This is the last hope of finding a solution. > > Thanks in advance. > Hussain. > >
01/30/2007 02:00 PM
Author: Ben Nadel Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268093 Mario, Thanks. I have no idea if it will work under Blue Dragon. I am guessing that it will not, but I cannot say for sure. ..................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ Cc: Ben Nadel Subject: RE: Reading from an Excel file through ColdFusion. Ben, This is a very impressive piece of coding.  Do you know if this will work under BlueDragon 6.2. Thanks Mario
01/30/2007 01:57 PM
Author: Ciliotta, Mario Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268092 Ben, This is a very impressive piece of coding.  Do you know if this will work under BlueDragon 6.2. Thanks Mario Hussain, I have created a early beta for a ColdFusion component that wraps around a limited set of POI functionality for reading / writing Excel files. The best part of this is that POI is built into ColdFusion so there is nothing too sneaky going on here, nor does anything new need to be installed. Check it out: http://bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Rea d-And-Write-Excel-Files.htm OR http://www.bennadel.com/index.cfm?dax=blog:474.view Let me know if you have any questions. I am working on improving it as we speak, but this is what I have so far. ...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ Hi, I want to read and parse through the excel files from coldfusion. Banged my head on the net but couldn't find anything :-( Even in CF documentation it's nowhere mentioned about reading an excel file from CF. This is the last hope of finding a solution. Thanks in advance. Hussain.
01/30/2007 12:36 PM
Author: Jose Saenz Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268075 Here is what we do in CF7. http://www.adobe.com/go/tn_18656 ----- Excess quoted text cut - see Original Post for more -----
01/30/2007 09:08 AM
Author: Ben Nadel Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268045 Hussain, I have created a early beta for a ColdFusion component that wraps around a limited set of POI functionality for reading / writing Excel files. The best part of this is that POI is built into ColdFusion so there is nothing too sneaky going on here, nor does anything new need to be installed. Check it out: http://bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Rea d-And-Write-Excel-Files.htm OR http://www.bennadel.com/index.cfm?dax=blog:474.view Let me know if you have any questions. I am working on improving it as we speak, but this is what I have so far. ..................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ Hi, I want to read and parse through the excel files from coldfusion. Banged my head on the net but couldn't find anything :-( Even in CF documentation it's nowhere mentioned about reading an excel file from CF. This is the last hope of finding a solution. Thanks in advance. Hussain.
01/30/2007 08:48 AM
Author: Doug Brown Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268043 Actually I finally found the link I was looking for. Forgot they changed cfcomets website. Anyhow Dain Anderson goes over this quite well. He was one of the co-authors of the advanced coldfusion books with Ben Forta http://cfregex.com/cfcomet/Excel/index.cfm?ArticleID=0239B2E5-5FED-11D3-B3E9004033E03EF9 Doug B. > Hi, > I want to read and parse through the excel files from coldfusion. > Banged my head on the net but couldn't find anything :-( > Even in CF documentation it's nowhere mentioned about reading an excel file from CF. > This is the last hope of finding a solution. > > Thanks in advance. > Hussain.
01/30/2007 08:38 AM
Author: Doug Brown Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268040 p.s http://www.houseoffusion.com/groups/CF-Talk/thread.cfm/threadid:49463 Doug B. > Hi, > I want to read and parse through the excel files from coldfusion. > Banged my head on the net but couldn't find anything :-( > Even in CF documentation it's nowhere mentioned about reading an excel file from CF. > This is the last hope of finding a solution. > > Thanks in advance. > Hussain.
01/30/2007 08:30 AM
Author: Doug Brown Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268038 Here is a tag that will do just what you would like...hope it helps http://www.emerle.net/programming/display.cfm/t/cfx_excel2query Doug B. > Hi, > I want to read and parse through the excel files from coldfusion. > Banged my head on the net but couldn't find anything :-( > Even in CF documentation it's nowhere mentioned about reading an excel file from CF. > This is the last hope of finding a solution. > > Thanks in advance. > Hussain.
01/30/2007 08:02 AM
Author: hussain shaikh Short Link: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:50081#268037 Hi, I want to read and parse through the excel files from coldfusion. Banged my head on the net but couldn't find anything :-( Even in CF documentation it's nowhere mentioned about reading an excel file from CF. This is the last hope of finding a solution. Thanks in advance. Hussain.
<< Previous Thread Today's Threads Next Thread >>

Search cf-talk

May 24, 2012

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
     1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31     

Designer, Developer and mobile workflow conference

Latest Fusion Authority Articles

Designer, Developer and mobile workflow conference

Want a number like 800-ColdFusion?

My Toll Free 800 Number provides a vanity phone number service to clients who want more than just digits. How would you like 800-coldfusion?

www.MyTollFree800Number.com