• Resolved spikerzz

    (@spikerzz)


    I can’t seem to import an excel sheet that is about 62MB, it uploades to about 28% then starts again at 0% then goes back to 28% and so on for a few times than I get a “This site can’t be reached”page

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

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

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Yes, this Excel file might be too big then. Please try saving it to a CSV file in Excel and try again with that.

    Regards,
    Tobias

    Thread Starter spikerzz

    (@spikerzz)

    When I do that I loose all my conditional formatting, is there a way to keep the conditional formatting?

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    what exactly do you mean with “conditional formatting”? Something like coloring of values? You’d be loosing that with the Excel import as well, I’m afraid, as TablePress can only import the data of tables from files.

    Regards,
    Tobias

    Thread Starter spikerzz

    (@spikerzz)

    Can I send you the excel file to show you what I would like and ask if TablePress can do it?

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    sure, I’ll gladly take a look! The address is in the main plugin file “tablepress.php”.

    Regards,
    Tobias

    Thread Starter spikerzz

    (@spikerzz)

    I have to send it through WE Transfer because of the size, but it is sent now ??

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    thanks for the file! I did receive it and had a quick look.

    Unfortunately, I can’t offer a directly usable solution to highlight those cells based on the current date in different colors automatically.

    However, I can point you to a few resources that might help in developing a custom solution:
    There is a TablePress Extension to highlight cells based on static table data, with more information available at https://tablepress.org/download/extension/tablepress-cell-highlighting.zip (For details and an example, please see the PHP file source code, which has one in the comment at the top.)
    In addition, there’s a TablePress Extension that can be used to filter out (hide) table rows that contain dates in the past or future, see https://tablepress.org/download/extension/tablepress-row-filter-date.zip (instructions in the PHP file again).
    You could maybe take ideas and code from this to adjust the first Extension to achieve what you need.

    Regards,
    Tobias

    Thread Starter spikerzz

    (@spikerzz)

    k thanks, I will try that:D

    Plugin Author Tobias B?thge

    (@tobiasbg)

    Hi,

    no problem, you are very welcome! ?? I hope this helps!

    Best wishes,
    Tobias

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Can’t Import Excel Sheet’ is closed to new replies.