Can’t Import Excel Sheet

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

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

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

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

Hi,

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

Regards,
Tobias

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

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

k thanks, I will try that:D

Hi,

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

Best wishes,
Tobias