Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. The Lounge
  3. Web page question

Web page question

Scheduled Pinned Locked Moved The Lounge
questionphpcom
24 Posts 10 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • 7 73Zeppelin

    Is there any possible way to capture this[^] data table directly into Excel? Somebody please tell me yes...

    J Offline
    J Offline
    Jeff Martin
    wrote on last edited by
    #2

    Select the table, Ctrl+C to copy, open Excel right click and choose Paste Special... and then choose HTML and click OK. Voila. Jeff Martin My Blog

    M 7 2 Replies Last reply
    0
    • 7 73Zeppelin

      Is there any possible way to capture this[^] data table directly into Excel? Somebody please tell me yes...

      M Offline
      M Offline
      Marc Clifton
      wrote on last edited by
      #3

      Well, cut&paste it into notepad, replace the spaces with something like |, then iteratively replace || with |, then import into Excel telling it the delimeter is |. Marc Pensieve

      7 1 Reply Last reply
      0
      • J Jeff Martin

        Select the table, Ctrl+C to copy, open Excel right click and choose Paste Special... and then choose HTML and click OK. Voila. Jeff Martin My Blog

        M Offline
        M Offline
        Marc Clifton
        wrote on last edited by
        #4

        Cool. Much better than my solution! Marc Pensieve

        1 Reply Last reply
        0
        • J Jeff Martin

          Select the table, Ctrl+C to copy, open Excel right click and choose Paste Special... and then choose HTML and click OK. Voila. Jeff Martin My Blog

          7 Offline
          7 Offline
          73Zeppelin
          wrote on last edited by
          #5

          Ah, thanks! I had been trying to do it with Quattro Pro, but Paste Special did not give the option of pasting as HTML -- which just screams the question: WHY NOT??

          1 Reply Last reply
          0
          • M Marc Clifton

            Well, cut&paste it into notepad, replace the spaces with something like |, then iteratively replace || with |, then import into Excel telling it the delimeter is |. Marc Pensieve

            7 Offline
            7 Offline
            73Zeppelin
            wrote on last edited by
            #6

            Also an option...the HTML solution above was quite nice. Doesn't appear to work with Corel's Quattro Pro, however...

            1 Reply Last reply
            0
            • 7 73Zeppelin

              Is there any possible way to capture this[^] data table directly into Excel? Somebody please tell me yes...

              N Offline
              N Offline
              netclectic
              wrote on last edited by
              #7

              Open Excel, go File -> Open, Paste in the URL

              B 7 N 3 Replies Last reply
              0
              • N netclectic

                Open Excel, go File -> Open, Paste in the URL

                7 Offline
                7 Offline
                73Zeppelin
                wrote on last edited by
                #8

                netclectic wrote:

                Open Excel, go File -> Open, Paste in the URL

                Apparently the document has moved....

                N 1 Reply Last reply
                0
                • N netclectic

                  Open Excel, go File -> Open, Paste in the URL

                  B Offline
                  B Offline
                  benjymous
                  wrote on last edited by
                  #9

                  Yikes! I'd have never thought something like that'd work Scary! -- Help me! I'm turning into a grapefruit! Buzzwords!

                  N 1 Reply Last reply
                  0
                  • B benjymous

                    Yikes! I'd have never thought something like that'd work Scary! -- Help me! I'm turning into a grapefruit! Buzzwords!

                    N Offline
                    N Offline
                    Nish Nishant
                    wrote on last edited by
                    #10

                    benjymous wrote:

                    Yikes! I'd have never thought something like that'd work

                    Yeah, I was stunned too! Regards, Nish

                    My blog : Nish’s thoughts on MFC, C++/CLI and .NET

                    1 Reply Last reply
                    0
                    • N netclectic

                      Open Excel, go File -> Open, Paste in the URL

                      N Offline
                      N Offline
                      Nish Nishant
                      wrote on last edited by
                      #11

                      netclectic wrote:

                      Open Excel, go File -> Open, Paste in the URL

                      :omg: Just tried it out! Awesome! Regards, Nish

                      My blog : Nish’s thoughts on MFC, C++/CLI and .NET

                      7 1 Reply Last reply
                      0
                      • 7 73Zeppelin

                        Did it work for you Nish? I got a message telling me the document had been permanently moved...:confused:

                        N Offline
                        N Offline
                        Nish Nishant
                        wrote on last edited by
                        #12

                        thealj wrote:

                        Did it work for you Nish?

                        Yes. I tried it again just to be sure. I used the following URL :- http://www.westernmininghistory.com/data/gold_production.php[^] Regards, Nish

                        My blog : Nish’s thoughts on MFC, C++/CLI and .NET

                        1 Reply Last reply
                        0
                        • 7 73Zeppelin

                          netclectic wrote:

                          Open Excel, go File -> Open, Paste in the URL

                          Apparently the document has moved....

                          N Offline
                          N Offline
                          Nish Nishant
                          wrote on last edited by
                          #13

                          thealj wrote:

                          Apparently the document has moved....

                          No it hasn't, I tried it 1 minute ago and it worked. Regards, Nish

                          My blog : Nish’s thoughts on MFC, C++/CLI and .NET

                          1 Reply Last reply
                          0
                          • N Nish Nishant

                            netclectic wrote:

                            Open Excel, go File -> Open, Paste in the URL

                            :omg: Just tried it out! Awesome! Regards, Nish

                            My blog : Nish’s thoughts on MFC, C++/CLI and .NET

                            7 Offline
                            7 Offline
                            73Zeppelin
                            wrote on last edited by
                            #14

                            Did it work for you Nish? I got a message telling me the document had been permanently moved...:confused:

                            N 2 Replies Last reply
                            0
                            • 7 73Zeppelin

                              Did it work for you Nish? I got a message telling me the document had been permanently moved...:confused:

                              N Offline
                              N Offline
                              Nish Nishant
                              wrote on last edited by
                              #15

                              BTW I use Excel 2003. Regards, Nish

                              My blog : Nish’s thoughts on MFC, C++/CLI and .NET

                              7 1 Reply Last reply
                              0
                              • N Nish Nishant

                                BTW I use Excel 2003. Regards, Nish

                                My blog : Nish’s thoughts on MFC, C++/CLI and .NET

                                7 Offline
                                7 Offline
                                73Zeppelin
                                wrote on last edited by
                                #16

                                It would appear that it does not work with Excel 2000. I did, however, fire up Quattro Pro 11 and it worked. Quite interesting, never knew you could use File->Open for a URL.

                                N N 2 Replies Last reply
                                0
                                • 7 73Zeppelin

                                  It would appear that it does not work with Excel 2000. I did, however, fire up Quattro Pro 11 and it worked. Quite interesting, never knew you could use File->Open for a URL.

                                  N Offline
                                  N Offline
                                  Nish Nishant
                                  wrote on last edited by
                                  #17

                                  thealj wrote:

                                  It would appear that it does not work with Excel 2000.

                                  Maybe, that's it. Regards, Nish

                                  My blog : Nish’s thoughts on MFC, C++/CLI and .NET

                                  1 Reply Last reply
                                  0
                                  • 7 73Zeppelin

                                    Is there any possible way to capture this[^] data table directly into Excel? Somebody please tell me yes...

                                    R Offline
                                    R Offline
                                    Rama Krishna Vavilala
                                    wrote on last edited by
                                    #18

                                    With excel 2003 you could capture and even refresh table automatically. 1. Select Data->Import External data->New Web Query 2. Type the URL of the website in the address field 3. Execl automatically allows you to select the table 4. Finally click on Import 5. Select the cells where you want to place the table. 6. You can refresh the data whenever you desire by clicking on refresh data

                                    D 1 Reply Last reply
                                    0
                                    • R Rama Krishna Vavilala

                                      With excel 2003 you could capture and even refresh table automatically. 1. Select Data->Import External data->New Web Query 2. Type the URL of the website in the address field 3. Execl automatically allows you to select the table 4. Finally click on Import 5. Select the cells where you want to place the table. 6. You can refresh the data whenever you desire by clicking on refresh data

                                      D Offline
                                      D Offline
                                      Don Miguel
                                      wrote on last edited by
                                      #19

                                      Good tip indeed! Thanks.

                                      1 Reply Last reply
                                      0
                                      • 7 73Zeppelin

                                        It would appear that it does not work with Excel 2000. I did, however, fire up Quattro Pro 11 and it worked. Quite interesting, never knew you could use File->Open for a URL.

                                        N Offline
                                        N Offline
                                        netclectic
                                        wrote on last edited by
                                        #20

                                        Excel 2000 here and it works fine.

                                        7 1 Reply Last reply
                                        0
                                        • N netclectic

                                          Excel 2000 here and it works fine.

                                          7 Offline
                                          7 Offline
                                          73Zeppelin
                                          wrote on last edited by
                                          #21

                                          netclectic wrote:

                                          Excel 2000 here and it works fine

                                          Very strange. It will not work for me under Excel 2000. It informs me that the document is no longer available. Quattro Pro, on the other hand, will perform the operation successfully.

                                          1 Reply Last reply
                                          0
                                          Reply
                                          • Reply as topic
                                          Log in to reply
                                          • Oldest to Newest
                                          • Newest to Oldest
                                          • Most Votes


                                          • Login

                                          • Don't have an account? Register

                                          • Login or register to search.
                                          • First post
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • World
                                          • Users
                                          • Groups