Skip to main content
D
ddks2
Participating Frequently
October 10, 2008
Question

MS Excel - File Uploads

  • October 10, 2008
  • 1 reply
  • 283 views
Hi there,
We are trying to improve the way users can upload xls documents. This is currently one of the show stoppers for our CF 8 migration (bad design). So is there any smart things out there to a) upload the xls to a specified directory (assume cffile can do this) and secondly load the xls into a recordset or something so we can do the validations. Maybe a custom tag or something?

Any experience, tips & tricks would be very helpful

Thanks,
Daniel
    This topic has been closed for replies.

    1 reply

    N
    Newsgroup_User
    Inspiring
    October 10, 2008
    ddks2 wrote:
    > a) upload the xls to a specified directory
    > (assume cffile can do this)

    Yes, <cffile...> will upload any file you allow through your system.

    > secondly load the xls into a recordset or
    > something so we can do the validations. Maybe a custom tag or something?
    >

    Three choices of which I know. There are probable custom tags out there
    that abstract one or more of these, but I do not personally know of them.

    1) The latest methodology makes use of POI libraries.
    http://www.bennadel.com/projects/poi-utility.htm

    2) I have seen documentation about creating a Data Source Name that
    connects to Excel files.
    http://www.intersuite.com/client/index.cfm/2006/12/5/ColdFusion-QD-Reading-Excel-Data

    3) If you are into pain, it is possible to use COM objects with
    ColdFusion to interact with MS Office tools.
    I'm not even going to try and find a link for this one.
    D
    ddks2Author
    Participating Frequently
    October 10, 2008
    Thanks,

    So the POI libraries look most appealing. Would these work in both CF6.1 and CF8? I think the link states CF6 and CF7 but i don't think there is any reason why this wouldn't work in CF8?!

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