Access analyzed KNIME data in excel

[yashpatel12]

Hi all,
Please help me out with how to access KNIME-analyzed data in excel?

[mlauber71]

@yashpatel12 I see these options:

• export data to a new Excel sheet which you use then
• export to a CSV file and import in Excel or connect via [Power Query]
  (About Power Query in Excel - Microsoft Support)
• export to a local database and connect via ODBC
• use the Excel Cell Updater to write data to Excel
• use OpenPyxl (now bundled with KNIME/Python) to add data to Excel or manipulate cells or sheets (use Python Pandas and Openpyxl to import and export Excel (sheets) and Export them back – KNIME Community Hub)

Writer Node Issues

@helpmeplease if you want the structure of your Excel file unchanged and just change values there are these options, if you must change data on a pre-formatted sheet (otherwise you might just replace this sheet). The Excel Cell Updater can change values in specific cells. You can use a community node to write to an Excel file without changing the structure or formats: You can the use Python and OpenPyxl to do more complex editings of excel files. You will have to plan ahead what this d…