I need someone to help me write an Excel page from a data base!!!

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • DWB
    Registered User
    • Jul 2003
    • 31779
    #1

    I need someone to help me write an Excel page from a data base!!!

    Anyone up for a little job?

    I need to pull the info from a mysql database and write it to an excel page. That page will automatically update as the site is updated.

    I had a guy who was going to do this for me but he is MIA and I needed this like yesterday.

    Anyone?
    Tags: None
    • Tempest
      Too lazy to set a custom title
      • May 2004
      • 10217
      #2
      What do you mean by an "excel page"?

        Comment

        • sarettah
          see you later, I'm gone
          • Oct 2002
          • 14353
          #3
          Originally posted by DirtyWhiteBoy
          Anyone up for a little job?

          I need to pull the info from a mysql database and write it to an excel page. That page will automatically update as the site is updated.

          I had a guy who was going to do this for me but he is MIA and I needed this like yesterday.

          Anyone?
          There is a real quick and easy way to do this.

          Write an html table with the data in it, save it with a file extension of .xls.

          And that is really all there is to it. You can write formulas in. etc and when it is open in excel excel automaically turns it into an excel sheet.

          I didn't believe it when someone showed me but it works.
          All cookies cleared!

            Comment

            • DWB
              Registered User
              • Jul 2003
              • 31779
              #4
              Originally posted by Tempest
              What do you mean by an "excel page"?
              .xls page

                Comment

                • brizzad
                  holla
                  • Jul 2003
                  • 11769
                  #5
                  Originally posted by sarettah
                  There is a real quick and easy way to do this.

                  Write an html table with the data in it, save it with a file extension of .xls.

                  And that is really all there is to it. You can write formulas in. etc and when it is open in excel excel automaically turns it into an excel sheet.

                  I didn't believe it when someone showed me but it works.
                  Really? That's awesome. Do only the newer versions of excel utilize this feature?

                    Comment

                    • sarettah
                      see you later, I'm gone
                      • Oct 2002
                      • 14353
                      #6
                      Originally posted by brizzad
                      Really? That's awesome. Do only the newer versions of excel utilize this feature?
                      I have no idea...lol. Know it works in 97 and 2000.

                      It came up when we were trying to get our server admin to install excel on the server so we could odbc to excel to write reports. He was very resistant, so we found a way around him.

                      It is a simple little trick but makes a lot of stuff easier to do once you play with it for a bit.

                      I haven't figured out how to do multiple page workbooks yet but the single page trick saves a lot of exporting and importing data when you need a quick little report.

                      I don't think it actually converts the data to an excel sheet. It keeps it in html but it allows you to navigate it and all that in excel.
                      All cookies cleared!

                        Comment

                        • DWB
                          Registered User
                          • Jul 2003
                          • 31779
                          #7
                          Originally posted by sarettah
                          I have no idea...lol. Know it works in 97 and 2000.

                          It came up when we were trying to get our server admin to install excel on the server so we could odbc to excel to write reports. He was very resistant, so we found a way around him.

                          It is a simple little trick but makes a lot of stuff easier to do once you play with it for a bit.

                          I haven't figured out how to do multiple page workbooks yet but the single page trick saves a lot of exporting and importing data when you need a quick little report.

                          I don't think it actually converts the data to an excel sheet. It keeps it in html but it allows you to navigate it and all that in excel.
                          Hmmmmmm. Sounds interesting.

                            Comment

                            • CaptainHowdy
                              Too lazy to set a custom title
                              • Dec 2004
                              • 94114
                              #8
                              If you're using PHPMyAdmin that's an easy task...

                                Comment

                                • sarettah
                                  see you later, I'm gone
                                  • Oct 2002
                                  • 14353
                                  #9
                                  Originally posted by CaptainHowdy
                                  If you're using PHPMyAdmin that's an easy task...
                                  I think he wants it embedded into the site update to automatically happen. I am not sure that you can do that with phpmyadmin. Not sure though because I have only used it a time or two.
                                  All cookies cleared!

                                    Comment

                                    • Tempest
                                      Too lazy to set a custom title
                                      • May 2004
                                      • 10217
                                      #10
                                      Looks like it would be easy to do with the pear excel write package with php. I'd help you out but it's looking like I'm not going to have any time today.

                                        Comment

                                        • DWB
                                          Registered User
                                          • Jul 2003
                                          • 31779
                                          #11
                                          I've got someone looking it it now. Will let you guys know if he is not able to do it.

                                          Thanks all!!!

                                            Comment

                                            • CaptainHowdy
                                              Too lazy to set a custom title
                                              • Dec 2004
                                              • 94114
                                              #12
                                              Originally posted by DirtyWhiteBoy
                                              I've got someone looking it it now. Will let you guys know if he is not able to do it.

                                              Thanks all!!!
                                              I love you DWB!

                                              [IMG]http://galleries.trannyhunt.com/***/tmpl/tgp/4/images/faces/05.jpg[/IMG]

                                                Comment

                                                Previous template Next
                                                Working...