Hi knime Experts
@manojmadhu you can use an R package “readODS” to read and write ODS files
Thanks for sharing this sir
@manojmadhu this is also possible to read (and write) ODS file with Python and KNIME :
Thank you for you replay sir
@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 .
@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:
@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.
system
October 11, 2022, 8:56am
7
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
