Excel as HTML

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Sonnich
    #1

    Excel as HTML

    Hi all!

    We discussed it lately, how to create xls files.

    I use(d) a way to save in html format, which excel can open nicely.
    However, now I need 2 sheets, and I am stuck on that.

    Any ideas?

    I have

    <html><head><ST YLE TYPE="text/css"<!-- .number2dec {mso-number-
    format: Fixed;}
    .number0dec {mso-number-format: 0\;} -->
    </STYLE></head>
    <table border=1 name="sheet1">
    <tr><td>2006/01</td><td class="number2d ec">66.66666666 6667</td><td
    class="number2d ec">25.66666666 6667</td></tr>
    </table>
    <table border=1 name="sheet2">
    <tr><td>abc</td></tr>
    </table>
    </html>

    but that merges them into one sheet.... there probably is a way

    S

    Tags: None
    • Nick Gerber
      #2
      Re: Excel as HTML

      Hi

      As this is a PHP Newsgroup I'd recommend Spreadsheet_Exc el_Writer
      (http://pear.php.net/package/Spreadsh...er/redirected).

      Nick

      Sonnich wrote:
      Hi all!
      >
      We discussed it lately, how to create xls files.
      >
      I use(d) a way to save in html format, which excel can open nicely.
      However, now I need 2 sheets, and I am stuck on that.
      >
      Any ideas?
      >
      I have
      >
      <html><head><ST YLE TYPE="text/css"<!-- .number2dec {mso-number-
      format: Fixed;}
      .number0dec {mso-number-format: 0\;} -->
      </STYLE></head>
      <table border=1 name="sheet1">
      <tr><td>2006/01</td><td class="number2d ec">66.66666666 6667</td><td
      class="number2d ec">25.66666666 6667</td></tr>
      </table>
      <table border=1 name="sheet2">
      <tr><td>abc</td></tr>
      </table>
      </html>
      >
      but that merges them into one sheet.... there probably is a way
      >
      S
      >

        Comment

        • Captain Paralytic
          #3
          Re: Excel as HTML

          On 2 Feb, 13:39, "Sonnich" <sonnich.jen... @elektrobit.com wrote:
          Hi all!
          >
          We discussed it lately, how to create xls files.
          >
          I use(d) a way to save in html format, which excel can open nicely.
          However, now I need 2 sheets, and I am stuck on that.
          >
          Any ideas?
          >
          I have
          >
          <html><head><ST YLE TYPE="text/css"<!-- .number2dec {mso-number-
          format: Fixed;}
          .number0dec {mso-number-format: 0\;} -->
          </STYLE></head>
          <table border=1 name="sheet1">
          <tr><td>2006/01</td><td class="number2d ec">66.66666666 6667</td><td
          class="number2d ec">25.66666666 6667</td></tr>
          </table>
          <table border=1 name="sheet2">
          <tr><td>abc</td></tr>
          </table>
          </html>
          >
          but that merges them into one sheet.... there probably is a way
          >
          S
          I would tend to save in XML format which Excel can also read well.
          Whether saving in XML or HTML, try saving from Excel in the prescribed
          format and copy what it does. However for multi-sheet books, if you
          want only one file, you will need to use either a web archive (.mht)
          or an xml file.

            Comment

            • Cord-Heinrich Pahlmann
              #4
              Re: Excel as HTML

              On 2 Feb., 15:14, Nick Gerber <ng7...@gmx.com wrote:
              Hi
              >
              As this is a PHP Newsgroup I'd recommend Spreadsheet_Exc el_Writer
              (http://pear.php.net/package/Spreadsh...er/redirected).
              >
              Nick
              >
              Sonnich wrote:
              Hi all!
              >
              We discussed it lately, how to create xls files.
              >
              I use(d) a way to save in html format, which excel can open nicely.
              However, now I need 2 sheets, and I am stuck on that.
              >
              Any ideas?
              >
              I have
              >
              <html><head><ST YLE TYPE="text/css"<!-- .number2dec {mso-number-
              format: Fixed;}
              .number0dec {mso-number-format: 0\;} -->
              </STYLE></head>
              <table border=1 name="sheet1">
              <tr><td>2006/01</td><td class="number2d ec">66.66666666 6667</td><td
              class="number2d ec">25.66666666 6667</td></tr>
              </table>
              <table border=1 name="sheet2">
              <tr><td>abc</td></tr>
              </table>
              </html>
              >
              but that merges them into one sheet.... there probably is a way
              >
              S
              I also use the pear Excel writer in some of my projects and it has
              been working very nicely...

                Comment

                • Sanders Kaufman
                  #5
                  Re: Excel as HTML

                  Sonnich wrote:
                  Hi all!
                  >
                  We discussed it lately, how to create xls files.
                  >
                  I use(d) a way to save in html format, which excel can open nicely.
                  However, now I need 2 sheets, and I am stuck on that.
                  >
                  Any ideas?
                  >
                  Open Excel and create a two pager, then save it as HTML.
                  Then you'll be able to see how Excel likes to do this.
                  That will probably be wildly complex because Excel is gonna try
                  to do a zillion XML things to it.

                    Comment

                    Previous template Next
                    Working...