importing of datas from excel

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    10 years, 2 months ago

    Hi,

    thanks for your post, and sorry for the trouble.

    Rounding of figures can be done with the math functions that are described at http://tablepress.org/tablepress-features-formulas/
    However, as you would have to modify every cell, that’s not a feasible approach really (you could then just fix the format manually).

    Instead, I suggest to not use the Excel format (.xls or .xlsx) for exporting/importing the table. Instead, save the table to CSV in Excel. That should then save the data in your table in exactly the same format as it is visible in Excel. You won’t have to do modifications then.

    Regards,
    Tobias

    Thread Starter owjass

    (@owjass)

    10 years, 2 months ago

    Hi Tobias,

    I have tried to save the table to CSV in Excel, but it still doesn’t work, is there a way I can send you the screenshots of my tablepress to see if I have done anything wrong? it looks alright in the setting but different in website. Thank you.
    Best regards
    Jas

    Thread Starter owjass

    (@owjass)

    10 years, 2 months ago

    Hi Tobias, I have managed to do get it by saving to CSV. I am not sure what happen to my system just now but after a few tries its successful. Thanks a lot.

    Best regards
    Jas

    Plugin Author TobiasBg

    (@tobiasbg)

    10 years, 2 months ago

    Hi,

    very cool! Great to hear that it’s working now! 🙂

    Best wishes,
    Tobias

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘importing of datas from excel’ is closed to new replies.