Hello all, This is my first post. I like the forums so far 😃 . Anyways I am by far not a n00b so please do not treat this topic like I am. 🙂

The question, I am working on a website (please do not bash about security it is being taken care of at a later time.) I have an XLS template. Here is a image of said template
http://img39.imageshack.us/img39/5549/imgnewj.jpg

I have that template in XLS and need to be able to export data from my website to that template. I am looking for either XLS or PDF or both. But I have no clue were to begin on setting up that template for use in exporting data.

Some info on the template, it is designed to fit landscape on a standard sheet of 8.5x11 piece of paper

The catch is I need to make it so a user can eventually click on a drop down menu and select the different template for each center. (This will be handled later) So anyone that could point me into the right direction so I can start setting up the export function(s)?

Thanks Jon

    Actually by far the easiest and most stable way is to make a HTML input/display form that is connected to a database - without caring about the Excel at that point.

    Then set up an Excel file that imports from that database. That works well and is pretty easy to setup.

    Bjom

      The only problem I would have with that, is excel 2007 doesn't support MySQL Db, along with multiple users having access to others data.

      Thus is why I am looking at creating at least a pdf output of the information, since it needs to be emailed to the center.

        Of course it does. Excel supports any datasource that it can connect to via ODBC.

        Get the ODBC driver for MySQL here right from the MySQL developers.

        along with multiple users having access to others data.

        I don't know what you mean? It's the database that supports the multiple users, the interface doesn't matter. HTML, Excel, PDF your own C# interface....all work equally well.

        Gist: You can use an Excel only solution with MySQL and it's even fairly easy.

        Bjom

          I must of not installed the connector right, I have it on my machine right now fully installed but only VS.Net 2008 sees it...

          I found TCPDF I am going to look at that, and I've also found a template script for that can use a PDF document so I can inject the data into it. I just need to measure the document out for placement of the data.

            Write a Reply...