Generating an excel sheet by click on website??

Discussion in 'Web Design and Development' started by i_never_existed, Sep 9, 2009.

  1. i_never_existed macrumors newbie

    i_never_existed

    Joined:
    Sep 23, 2005
    Location:
    at the moment... Chile
    #1
    Hi there.

    I am trying to do the following on my website, and it is the first time I have attempted anything like this.

    I have a button on my site. When someone clicks on the button I can of course in Dreamweaver tell it to mailto: or open another webpage...

    ... but what I NEED is that it opens up an invoice made in Excel.

    Think that they are going to buy a book online, I need that when they click on the BUY ME button... that it generates an excel Invoice sheet to be sent to me.

    Any ideas on how to go about this... please. I've lost 2 days trying to figure this out.


    Thanks
     
  2. Ride9650 macrumors 6502

    Joined:
    Jun 29, 2007
    #2
    thats not possible.

    The only thing that you can really do is generate a page with all the buyer's info, etc, however nothing can be done to integrate that into excel.

    ---------
    EDIT:

    I apologize, there is apparently a solution! However its not automatic and requires that you have a basic understanding of how web servers work. But there are instructions and its usually pretty straightforward.

    http://www.zen-cart.com/

    when used with this

    http://www.zen-cart.com/index.php?main_page=product_contrib_info&products_id=170
     
  3. design-is macrumors 65816

    design-is

    Joined:
    Oct 17, 2007
    Location:
    London / U.K.
    #3
    I've not done anything like it before but a google for "export HTML table to csv" came up with some interesting results which may be of use...

    Will post back if I find anything else :)

    /Doug
     
  4. i_never_existed thread starter macrumors newbie

    i_never_existed

    Joined:
    Sep 23, 2005
    Location:
    at the moment... Chile
    #4
    Thanks.

    I mean, it doesn't have to generate an Excel exactly... but somekind of Invoice sheet or page. That they can see after clicking the BUY button. Once they have seen that, THEN I need it to generate an excel being sent to the reciever.

    BUTTON--> Online Excel/page showing purchase--> Email being sent to company email with (hopefully) excel attached.
     
  5. kedruff macrumors newbie

    Joined:
    Jul 6, 2009
    #5
    Why an Excel file? What are you trying to accomplish with said Excel file? Is the Excel file an invoice? If it's an invoice, why not just a normal HTML file that they can print and submit with payment?
     
  6. design-is macrumors 65816

    design-is

    Joined:
    Oct 17, 2007
    Location:
    London / U.K.
    #6
    I know there are solutions which can produce PDFs - this could also be a better option. Though the above HTML email sounds best to me... Any reason why this wouldn't be appropriate?

    Don't good ecommerce solutions already email the recipient with an 'invoice' message?

    /Doug
     
  7. Cerebrus' Maw macrumors 6502

    Joined:
    Mar 9, 2008
    Location:
    Brisbane, Australia
    #7
    it is possible to make your browser support an excel sheet on its display page, so that it looks as if you user is looking at an excel document.

    You need a good understanding of the technologies behind it (PHP, HTML, MySQL, XML)

    But this page has en excellent tutorial that I used to implement an excel formatted accounts page for our accounting department.
     
  8. i_never_existed thread starter macrumors newbie

    i_never_existed

    Joined:
    Sep 23, 2005
    Location:
    at the moment... Chile
    #8
    Thanks guys... you've given me a lot to think about.

    Am looking into all the info you've given me.

    Thanks again!
     

Share This Page