Results 1 to 6 of 6
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Displaying Excel Data in Web format

    This relates to <A target="_blank" HREF=http://www.wopr.com/cgi-bin/w3t/showflat.pl?Cat=&Board=xl&Number=21194&page=0&view =collapsed&sb=5>this thread</A>... If you have any ideas, please help!

    Drk.
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    navir
    Guest

    Re: Displaying Excel Data in Web format

    Hi, Drk:

    I was asked this question so many times, I wrote a brief description of several methods at:

    <A target="_blank" HREF=http://www.htmlchef.com/tips_xltohtml.asp>Convert Excel Spreadsheets to HTML Tables</A>

    I hope it is useful.

    Regards,
    Ivan

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying Excel Data in Web format

    Thanks Ivan!

    What are the possibilities for those of us stuck with the '97 dinosaur? [img]/forums/images/smilies/smile.gif[/img])

    Thanks!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  4. #4
    navir
    Guest

    Re: Displaying Excel Data in Web format

    Hi, Drk:

    The techniques described toward the bottom of the page, work equally well for Excel 2000, 97, 95 or (I think) Excel 1.

    Read the part in the Excel Programming section that begins:

    "... the following pseudo code might be written for each row:

    resultCell = "<tr>"
    for each cell in row
    resultCell = resultCell + "<td>" + cell + "</td>"
    next
    resultCell = resultCell + "</tr>"

    Excel can program the same functionality, as a formula, by replacing the plus (+) character with an ampersand (&), and replacing the cell variable with a reference to a specific cell on the spreadsheet."

    Let me know if you need additional information.

    Regards,
    Ivan

  5. #5
    4 Star Lounger
    Join Date
    Dec 2000
    Location
    London, Ontario, Canada
    Posts
    437
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying Excel Data in Web format

    Hey Drk:
    This is probably another manifestation of my bizarre logic (or lack of) <img src=/S/hairy.gif border=0 alt=hairy width=15 height=15> but, would it be practical for you to export the excel data to an access table (I know you have Acc97). Access makes publishing tables very easy. Just a thought <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>

  6. #6
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Displaying Excel Data in Web format

    Well as soon as I get through the 'Corporate Red Tape' i'll look into that possibility...

    Ideally, we'd have Access 2000, export the data from excel to A2000, and use web-forms to publish up-to-the-minute stats...

    But that'll likely happen when pigs fly... <img src=/S/hairy.gif border=0 alt=hairy width=15 height=15>

    Thanks!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •