Continental XLS Formatter Nodes

Dear KNIMErs, dear @Continental_KNIME_Extension_Developer .

I was just playing around with the KNIME XLS formatter nodes, which are awesome.

I am not 100% sure but is it limited to 50,000 lines in the Excel files?

Thank you in advance!

1 Like

Dear @kowisoft,
Thanks for testing our nodes! You are right, this actually is a known bug. The XLS specification allows a maximum of 65,000 different styles per workbook. But our corresponding implementation currently doesn’t check the distinct number of required styles, but the number of cells with formatting instructions. This will be fixed in our next release, probably in April.

(disclaimer: this post expresses my personal opinion)

7 Likes

thank you!!!

Hello

I’m hijacking the thread, since the original post was solved.

I’m trying to get the continental nodes, but cannot connect to the update server (company firewall …).

is there another way of installing them?

I found them on github (https://github.com/continental/continental-nodes-for-knime)

but cannot get them to work.

happy for any help

best

Andreas

Hi Andreas!

Another option is to install it from a local zip file.

Check out last paragraph from this link: https://www.knime.com/downloads/update

Br,
Ivan

2 Likes

Hi Ivan

I also tried this, but the continental ones are not present in the community contributions zip (vers. 3.7).

is there a usable zip for these nodes available somewhere?

best

Andreas

Hi Andreas!

You are right. Just checked and they are not included. Will get back to you.

Br,
Ivan

Hi Andreas!

It will be included in 3.7.2 version which will come out very soon :wink:

Sry for inconvenience.

Br,
Ivan

Hi Ivan,

alright cheers for checking.

I’ll wait for the 3.7.2 then

many thanks

best

Andreas

1 Like

Hello again,

just for curiosity is there any schedule for the 3.7.2 update?

best

Andreas

Hi Andreas!

Yes there is. Soon :slight_smile:

I will notify you here.

Br,
Ivan

1 Like

Hi Andreas @And_Z !

KNIME version 3.7.2 is out!

Hope Continental nodes are present in zip file :slight_smile:

Br,
Ivan