Hello after installation I only see Utility group but XLS Formatter and nodes – aren’t visible.
I look at the forum and found users which have the same or similar problem. For example:
This problem is only in one computer and my admin supposed that it’s caused, that this computer didn’t have MS Excel installation. I tried reinstall many times, use “-clean” option in *.ini file and nothing helped.
Can I move some library’s (MS Excel) on this comp to pressure it to work?
Hi @gab1one I upgraded Knime from 3.6 to the newest version 4.1.3 and install Continental Nodes for KNIME - 1.2.0.v202004281515.
I also made a fresh Knime installation form zip file.
@ipazin it’s not only a theory Today we made an experiment. Computer with this problem is a kind of server, because I share folder with Knime installation in network and allow another users to run Knime only in runtime mode using batches and prepared workflows. As I said, when admin run Knime on this “server” (don’t have MS Excel) we can see nodes with XLS formatting options from Continental. If we use another computer (never had Knime installation, but has MS Excel installation) and run Knime from shared “server” folder the nodes appear!
So We supposed that the problem with lack of some Ms Excel library’s…
Unfortunately, the extension was uninstalled so we install them again, but still nothing happened.
On the computer on which there is Ms Excel and we launched Knime from shared localization - everythink is OK.
We install Ms Excel on the server, but it doesn’t helped.
We use another computer without Ms Excel and run Knime form shared folder from server and everything was ok, so it’s another kind of problem.
Admin now installing patches in OS - windows 2012 R2 Standard Edition, and we will see if it help…
In tha meantime, admin installed Knime on the other serwer and everything was ok…
After install all Windows updates on the main server - everything work properly - thank you guys… my admin is
Glad to hear that the problem is solved now. Thanks for reporting the issue. As @gab1one says, there was a minor fix in the latest release which we hope to fix this issue.
Just to clarify for other users as well: The extension does not require an Excel installation. All libraries used are included in KNIME itself (not even shipped via the extension).
Hi @arbe your last sentence i true - Knime don’t need Excel installation. But my problem didn’t gone, unfortunately. Next day, all XLS nodes from Continental Extension gone
My admin gave me new server with clear system. I made some test on Knime 4.1.3 and my summary is:
XLS node appears only in version 0.8.2
when I installed continental version 1.1 and 1.2 it’s only “utility node”
I will use lowest version of this extension but I have a problem with existing workflows. I supposed that the resolved is in version 1.1:
•added “from long/unpivoted layout to wide XLS Control Table” option to XLS Control Table Generator
On the main server where we upgraded Knime to 4.1.3 version and installed Continental extension we can see xls nodes only in version 0.8.2. When we installed version 1.1 or 1.2 - they gone. Operating system is Windows Server 2012 R2 Standard
Admin run only for me - new server with Windows Served 2019 Standard and Knime 4.1.3 - the situation is the same.
On my personal computer every think is ok (Knime 4.1.3 + Continental Extension v. 1.2). When I installed Knime on my colleague personal computer with Windows 10, every think is OK still. It’s seems that the problem is only on servers?
Hey, we tried the 4.1.2 and there it works fine. But we just updated the whole institute from 3.7.2 to 4.1.3 including the KNIME Servers and now we can not go back.
I also tested LInux this morning with 4.1.3 and have the same result. Therefore, as stated the issue is 4.1.3. Can we get a fixed version of the nodes?
Furthermore, the 4.2 also works . . . but the next update round will not be this year
due to the huge effort.
I just tried to reproduce this issue on 4.1.3 and indeed the xls formatter nodes were not initially available after installation. I was however able to restore them by starting KNIME AP using the -clean parameter once. I did this by navigating to the installation location on the command line and executing ./knime -clean.
This should get you started with relative little effort.