Excel Reader - How to retain empty cells?

My guess is that when it broke the export into 2 files, it didn’t properly recreate the filters in one of the files. You will notice that data 27 lacks the filter controls at the column header which are present on data 28.

Something like that - but, in fact, the two files are manually created rather than auto-split by a single export. I’m going to find out how that was set up (wasn’t me).

1 Like

@LB_Knime the OpenPyxl is quite easy to use in case someone sees this thread in the future. It basically works like this:

import knime.scripting.io as knio
import pandas as pd

v_excel_file = knio.flow_variables['file_path']
v_name_sheet = knio.flow_variables['Name_Excel_sheet']

df = pd.read_excel(v_excel_file, sheet_name=v_name_sheet, engine='openpyxl')

knio.output_tables[0] = knio.Table.from_pandas(df)
3 Likes

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