Modify an excel file storaged in onedrive from Knime


I want to know if it’s possible modify an excel that is in one drive from Knime.
If the changes made from Knime could be seen on the excel file?

Thank you

Hi @Jalvear , the way it works in Knime is, you don’t really open an Excel file for modification as you would via Excel. In Knime, you read an Excel file where the data is in the form of a Knime table. You then do any manipulation/processing that you need, which will result in a Knime table. You can then save that manipulated data as the same file that you read, which will overwrite the file with the new data.

So the excel file will contain the changes made from Knime after that. This means you will need permission to overwrite the file.


@Jalvear if you want to have a short overview about waht you can and cannot do with KNIME and Excel here is a summary:

To explore further you could have a look at this collection

Then concerning OneDrive you might want to consider your specific settings. Would you write the file to your ‘local’ ONeDrive folder and then it would get synced to the cloud or do you want to write directly to the cloud folder?



When I do this I lost the excel format like the colors in each sheet, conditionals an formulas.

That’s why I’d like to modify from Knime directly in order to not disturb this process

Hi @Jalvear , as I explained, Knime does not open an Excel file for modification. However, you could probably accomplish what you are trying to do via Java (so Java Snippet), there must be some libraries in Java that allows you to open an Excel file and modify the file.

EDIT: It looks like the org.apache.poi library would do.


@Jalvear You could try this community node and see if this can help you

You can update cells with this node:

The formatting of existing cells, rows and columns in the Excel sheet will be preserved.

Maybe you could try some of these. Maybe you could provide us with an example.



Thanks a lot for the explanation given. I’m going to try it. I’ll tell you.


This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.