Continental XLS Formatter Nodes

#1

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

#2

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

#3

thank you!!!

0 Likes

#4

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

0 Likes

#5

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

#6

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

0 Likes

#7

Hi Andreas!

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

Br,
Ivan

0 Likes

#8

Hi Andreas!

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

Sry for inconvenience.

Br,
Ivan

0 Likes

#9

Hi Ivan,

alright cheers for checking.

I’ll wait for the 3.7.2 then

many thanks

best

Andreas

1 Like

#10

Hello again,

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

best

Andreas

0 Likes

#11

Hi Andreas!

Yes there is. Soon :slight_smile:

I will notify you here.

Br,
Ivan

1 Like

#13

Hi Andreas @And_Z !

KNIME version 3.7.2 is out!

Hope Continental nodes are present in zip file :slight_smile:

Br,
Ivan

0 Likes