Article:		Excel Reports with Apache Cocoon and POI
Subject:		XML & Excel reporting
Date:		2003-02-12 08:18:40
From:		Leo Cohn
I use the Office web components, consuming an XML recordset, to build pivot tables on the web page with IIS. Can I do this with your approach? Can I host the page with Excel in a <<browser>> and not just on the desktop? Great project, by the way.

Previous Message

Next Message

• XML & Excel reporting
  2003-02-14 10:01:21 Steven Punte
  
  Leo:

  
  The primary rending pipeline can be
  rearranged to just consume XML instead
  of obtaing the data from a database.
  Then, you would need to perform the
  equivalent of your piviot transformation
  in XSL.

  
  The download demo I've provided DOES emitt
  the reults over HTTP into preferrably
  IE which results in MS Excel being brough
  alive IN the browser.

  
  Steve
  
  

  • XML & Excel reporting
    2003-08-12 11:10:20 Dhriti Dave
    
    Hello Steve,

    
    This article is really helpful.

    
    I have one xml file and I want to generate excel from that. I did email about this before and I also got a satisfied answer from Andrew Olivier.

    
    There is one line in this article:
    "XQuery statements could be used against an XML database or SOAP web services over the net"

    
    how can I use XQuery against XML? any example?
    I am confused.

    
    Thanks,
    Dhriti Dave
    Fidelity Investments
    PH: 617.392.0179