4 Replies Latest reply: Dec 21, 2005 5:19 AM by 843844 RSS

    help in HSSF

    843844
      Hi,

      Can i use HSSF code inside my JSP? I have a JSP page which fetches data fom database(using servlet) and displays as HTML
      table in the same JSP page itself.
      Now i want to save this table as Excel by clicking a button.Can i include HSSF code in JSP itself may b in a function which gets called wen i click that button.
      Please hepl me out.
        • 1. Re: help in HSSF
          843844
          You can use the tag <@ page contentType = "application/vnd.ms-excel" %> for generating the excel sheets.
          Refer to this document for further information

          http://pdf.coreservlets.com/CSAJSP-Chapter11.pdf
          • 2. Re: help in HSSF
            843844
            You can use the tag <@ page contentType = "application/vnd.ms-excel" %> for generating the excel sheets.
            Refer to this document for further information

            http://pdf.coreservlets.com/CSAJSP-Chapter11.pdf
            • 3. Re: help in HSSF
              843844
              I have already tried that and i want solution using POI. Sorry i didnt mention it before.
              • 4. Re: help in HSSF
                843844
                You can use HSSF with JSP. See the following link on creating xls files using POI

                http://jakarta.apache.org/poi/hssf/quick-guide.html

                After creating the xls file give the URL of the xls as the href for an anchor tag.