Skip to main content
S
SushiSnacks
Participant
July 16, 2009
Question

Read from xlsx file.

  • July 16, 2009
  • 2 replies
  • 2050 views

Is it possible to read from an xlsx file in Coldfusion 8? Maybe turn the excel file into a query or something like that.

thanks!

    This topic has been closed for replies.

    2 replies

    -
    -__cfSearching__-
    Inspiring
    July 16, 2009

    SushiSnacks wrote:

    Is it possible to read from an xlsx file in Coldfusion 8? Maybe turn the excel file into a query or something like that.

    thanks!

    There is nothing built in. But you could use POI as Dan mentioned and there are also commericial products. The most popular POI component is Ben Nadel's POIUtility.cfc.  I do not know if it supports 2007 format, but it is definitely worth looking at.
    www.bennadel.com/projects/poi-utility.htm

    I have not tried this one, but it is based on the POIUtility.cfc and should support 2007
    http://rahulnarula.blogspot.com/.../coldfusion-and-excel-2007-integration.html

    D
    Dan_Bracuk
    Inspiring
    July 16, 2009

    Maybe.  There is a series of publicly available cfcs that read MS Office files with cf.  They work on office 2003 files but I don't know about 2007.

    To find these cfc's, google "coldfusion excel poi".

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices