Skip to main content
M
meensi
Inspiring
January 24, 2011
Answered

Displaying Excel Data

  • January 24, 2011
  • 1 reply
  • 2792 views

Hi,

I have one excel sheet, I want to display the data in that excel sheet after reading it.

Is there anyway to do this.

Using coldfusion 9, Apache

    This topic has been closed for replies.
    Correct answer Owainnorth

    What, precisely, is the error that you are getting?  Can you post some code of what you're trying to do?


    Well everyone who cares what I'm up to is out of the office, so might as well have a bash at this. As expected, it was this easy:

    <cfspreadsheet action="read" src="E:\CFusion\wwwroot\sstest\test.xls" sheet="1" query="data">

    <cfform>
        <cfgrid name="SomeGrid" query="data" />
    </cfform>

    And I get an Excel-stylee grid displaying my query data. Let us know what the issue is and I'll take a look if I've got nothing better to do, which is fairly likely  for the next three hours.

    1 reply

    Owainnorth
    Owainnorth
    Inspiring
    January 24, 2011

    You want to display the data where after reading it where?

    Check out the CFSPREADSHEET tag, that should do everything you need.

    M
    meensiAuthor
    Inspiring
    January 24, 2011

    Yes, I will check that.

    I want to display the output in the .cfm page.

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