locked
Excel table to html table code. RRS feed

  • Question

  • User-977583538 posted

    I want to make one editor application which can convert excel table to html table.

    My requirement is that when user copy excel table in multiline textbox and press convert button then the html table code should generate in another textbox of same GUI.

    The main functionality includes in html table code:

    1. Colspan & rowspan

    Ex. colspan="2"


    2. Hide row border

    <td style="border-left:hidden;border-right:hidden;”>555 77 854</td>


    I don’t want to display any CSS style in html table code only simple code should generate as given in below example:

    Input:

    --------------

    Name

              Telephone

    Bill Gates

       555 77 854

         555 77 855

    Output:

    --------------

    <table>
    <tr>
      <tr>Name</tr>
      <tr colspan="2">Telephone</tr>
    </tr>

    <tr>
      <td>Bill Gates</td>
      <td>555 77 854</td>
      <td>555 77 855</td>
    </tr>
    </table>

    -------------------------------------------

    Input:

    --------------

    First Name

          Bill Gates

    Telephone

          555 77 854

          555 77 855

    Output:

    --------------

    <table>
    <tr>
      <tr rowspan="2">Telephone:</tr>
      <td style="border-left:hidden;border-right:hidden;”>555 77 854</td>
    </tr>
    <tr>
      <td>555 77 855</td>
    </tr>
    </table>

    Wednesday, September 14, 2011 2:08 AM

All replies