WordPress.org

Forums

WP-Table Reloaded
HTML upload garbled (7 posts)

  1. rvbinder
    Member
    Posted 4 years ago #

    I saved an excel xlxs as html, and then uploaded. The result is garbled: the row/column mapping is completely off.

    Please advise.

  2. TobiasBg
    Member
    Plugin Author

    Posted 4 years ago #

    Hi,

    it is hard to tell what caused this, without seeing the HTML file.

    So, it would be great, if you could upload that somewhere.

    Also, please try saving to CSV and importing that. That's actually a "more recommended" way for Excel files.

    Regards,
    Tobias

  3. rvbinder
    Member
    Posted 4 years ago #

    Here's a link to page with the garbled table.
    http://www.robertvbinder.com/home/thought-leadership/articles/biblography/

    You should be able to view/download the html file from
    http://www.robertvbinder.com/pubs-list.html

    Thanks
    Bob

  4. rvbinder
    Member
    Posted 4 years ago #

    PS -- the file has commas in many fields, and I want to preserve the links where they exist. Excel doesn't support setting a non-comma csv delimiter on output, afiak.

  5. TobiasBg
    Member
    Plugin Author

    Posted 4 years ago #

    Hi,

    thanks for the link!
    I assume that the reason for this problem is the not really valid HTML in the file. Excel does a bad job there, as it adds attributes to the tags without properly wrapping them in quotation marks. That likely throws the import library off.

    For the CSV: You are correct that Excel uses commas as the delimiter, it does however correctly escape commas in cells. This is detected by the import library, so you should actually have no problems with the CSV file.

    Regards,
    Tobias

  6. rvbinder
    Member
    Posted 4 years ago #

    The csv export is correctly parsed for rows/columns.

    But, none of the hyperlinks are transfered, so I think I'll hand hack the Excel output and just paste that in. Also there are some unicode (Chinese) characters that are dropped.

    Anyway, thanks for the prompt follow up -- these limitations aside, this is a very nice tool with great documentation.

    Bob

  7. TobiasBg
    Member
    Plugin Author

    Posted 4 years ago #

    Hi Bob,

    yes, the hyperlinks seem not to be exported to CSV by Excel :-(

    And those Unicode characters likely get lost during some kind of character encoding conversion... :-/

    Best wishes,
    Tobias

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WP-Table Reloaded
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic