getting different cell content than what is entered in the XLS file

  • Resolved 3cstudio

    (@3cstudio)


    4 years, 6 months ago

    Hi @tobiasbg, when importing the .xlsx file, everything seems to “translate” just fine, except the “next” month (line that starts with “1-Oct”). When imported, that shows as: 2020-10-01 00:00:00 instead…. even when reentering it properly in the .xlsx file before import. Any ideas why that won’t convert properly?
    Thanks in advance — really like using TablePress.

    The page I need help with: [log in to see the link]

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Unfortunately, the direct XLSX import into TablePress is still experimental, as it still has problems with imports of date and time information.
    The best solution here is to save the table to a CSV file in Excel and then import that .csv file into TablePress. This should give you the correct format.

    Regards,
    Tobias

    Thread Starter 3cstudio

    (@3cstudio)

    OK, thanks for the suggestion, Tobias. We’ll see how that looks!

    -S

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    no problem, you are very welcome! ?? Good to hear that this helped!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘getting different cell content than what is entered in the XLS file’ is closed to new replies.