Node "Excel Writer" Error/bug in KNIME 5.3.1

KNIME Analytics Platform
1

Hello Community,

We use the “Excel Writer” Node to write our results to file system. This file is used to update PowerBI.
With KNIME 5.2.1 no problem.
with KNIME 5.3.1 Power BI reports failure. (Can´t find the right sheet, it has problems with the navigation)
If we open with KNIME 5.3.1. written “result.xlsx” with Excel directly and save it without changes, Power BI loads without failure.
Are there any changes made in the Excel Writer Node with KNIME 5.3.1 ?
Greetings Alex

2

@Wile welcome to the KNIME forum. This sounds like this problem. You might try and remove the properties from the saved excel file:

1 Like
3

Thank you for your fast reply, I will test it!

4

tested and: It works!
But it´s not an issue with the author. We adapted the phyton script just to open and close the excel. and now it works:

import knime.scripting.io as knio
import pandas as pd
import openpyxl
import datetime
import os

Retrieve the file path from KNIME flow variables

v_excel_file = knio.flow_variables[“file_path”]
v_data_path = knio.flow_variables[“context.workflow.data-path”]

Load the Excel workbook

fh = openpyxl.load_workbook(v_excel_file)

Save the updated Excel workbook

fh.save(v_excel_file)

from my point of view this should not be. It seems that the original “Excel Writer” does something wrong.

1 Like
5

@Wile Excel as a way to transfer data is not optimal. In another thread there was the suggestion to use parquet to bring data to PowerBI. Maybe also try this.

1 Like
6

Thank you for your suggestion. We have to evaluate it, because some Excel files are also used by “humans” :slight_smile:
But also good to know, that the general issue is already known, so I can looking foward to any KNIME updates

1 Like