How to Read ODS files with the help of python and loop?

[mlauber71]

@manojmadhu glad you liked the example.

@manojmadhu

aposecell

I have never used this package although I have done a few things with Excel and KNIME with the help of OpenPyxl.

Excel Reader - Transformation -Removing Columns Multiple Sheets

@mb7846 I think we would first have to establish what you and and cannot do with generic Excel functions in KNIME right now you can load almost all Excel sheets in various settings (all sheets from one file at once if they have the same structure), loop thru a lot of Excel files, read all sheet names to make decisions about them and so on. So you can import all kinds of dats from Excel then you can EXPORT data either by writing a new file or replacing a single sheet (which will be a plain data…

You could try and see if you could employ aposecell in a similar way. Maybe you have and example of waht you want to do. Some dummy data and Python code maybe.

Also there are some Excel community nodes that might be interesting:

Modify an excel file storaged in onedrive from Knime

@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.