Icon

kn_​example_​python_​excel_​import_​knime

KNIME - use Pandas and OpenPyxl to import a protected and formatted excel sheet - where import is otherwise slow

KNIME - use Pandas and OpenPyxl to import a protected and formatted excel sheet - where import is otherwise slow

KNIME - use Pandas and OpenPyxl to import a protected and formatted excel sheet - where import is otherwise slowhttps://forum.knime.com/t/knime-4-5-2-excel-reader-extremely-slow-when-reading-from-other-sheet-different-than-the-first/41008/15?u=mlauber71 ############################################### import the KNIME moduleimport knime.scripting.io as knioimport numpy as npimport pandas as pdvpy_excel_file = knio.flow_variables['var_excel_file_import']vpy_sheet_name = knio.flow_variables['v_excel_sheet']vpy_rows_to_skip = knio.flow_variables['v_rows_to_skip']vpy_rows_to_load = knio.flow_variables['v_rows_to_load']# vpy_cols_to_use = knio.flow_variables['v_cols_to_use']# , nrows=Nonedf = pd.read_excel(vpy_excel_file, sheet_name=vpy_sheet_name, header=1, skiprows=vpy_rows_to_skip, nrows=vpy_rows_to_load) knio.output_tables[0] = knio.Table.from_pandas(df) KNIME and Python — Setting up and managing Conda environmentshttps://medium.com/p/2ac217792539How to Set Up Your Python Extensionshttps://www.knime.com/blog/how-to-setup-the-python-extension Date&Time1Date&Time2duration secondslocate and create/data/ folderwith absolute pathsv_excel_fileHoja Trabajo MPS official - ALEJANDRA SOLIS CASTROv_excel_sheetSTATUS INVENTARIOvar_excel_file_importSTATUS INVENTARIOSTATUS INVENTARIOSTATUS INVENTARIOv_rows_to_skipv_rows_to_loaddefault 1.000MODULARMODULARv_rows_to_skipv_excel_sheet MODULARv_rows_to_loaddefault 1.000MODULAR"Dia" Missing -> exclude"Dia" Missing -> excludevar_table_file_exportvar_table_file_exportSTATUS INVENTARIOvar_table_file_exportvar_table_file_exportMODULARduration secondsDate&Time1Date&Time2flow_variables['var_py_version_pandas'] = pd.__version__flow_variables['var_py_version_numpy'] = np.__version__flow_variables['var_py_version'] = sys.version_infoflow_variables['var_sys_path'] = sys.pathCreate Date&TimeRange Create Date&TimeRange Date&TimeDifference Collect LocalMetadata determine paths StringConfiguration StringConfiguration Java EditVariable (simple) Merge Variables Python Script Merge Variables IntegerConfiguration IntegerConfiguration Merge Variables Merge Variables IntegerConfiguration StringConfiguration IntegerConfiguration Python Script Row Filter Row Filter Java EditVariable (simple) String to Path(Variable) Table Writer Java EditVariable (simple) String to Path(Variable) Table Writer Joiner Date&TimeDifference Create Date&TimeRange Create Date&TimeRange Joiner Python Script Variable toTable Row KNIME - use Pandas and OpenPyxl to import a protected and formatted excel sheet - where import is otherwise slowhttps://forum.knime.com/t/knime-4-5-2-excel-reader-extremely-slow-when-reading-from-other-sheet-different-than-the-first/41008/15?u=mlauber71 ############################################### import the KNIME moduleimport knime.scripting.io as knioimport numpy as npimport pandas as pdvpy_excel_file = knio.flow_variables['var_excel_file_import']vpy_sheet_name = knio.flow_variables['v_excel_sheet']vpy_rows_to_skip = knio.flow_variables['v_rows_to_skip']vpy_rows_to_load = knio.flow_variables['v_rows_to_load']# vpy_cols_to_use = knio.flow_variables['v_cols_to_use']# , nrows=Nonedf = pd.read_excel(vpy_excel_file, sheet_name=vpy_sheet_name, header=1, skiprows=vpy_rows_to_skip, nrows=vpy_rows_to_load) knio.output_tables[0] = knio.Table.from_pandas(df) KNIME and Python — Setting up and managing Conda environmentshttps://medium.com/p/2ac217792539How to Set Up Your Python Extensionshttps://www.knime.com/blog/how-to-setup-the-python-extension Date&Time1Date&Time2duration secondslocate and create/data/ folderwith absolute pathsv_excel_fileHoja Trabajo MPS official - ALEJANDRA SOLIS CASTROv_excel_sheetSTATUS INVENTARIOvar_excel_file_importSTATUS INVENTARIOSTATUS INVENTARIOSTATUS INVENTARIOv_rows_to_skipv_rows_to_loaddefault 1.000MODULARMODULARv_rows_to_skipv_excel_sheet MODULARv_rows_to_loaddefault 1.000MODULAR"Dia" Missing -> exclude"Dia" Missing -> excludevar_table_file_exportvar_table_file_exportSTATUS INVENTARIOvar_table_file_exportvar_table_file_exportMODULARduration secondsDate&Time1Date&Time2flow_variables['var_py_version_pandas'] = pd.__version__flow_variables['var_py_version_numpy'] = np.__version__flow_variables['var_py_version'] = sys.version_infoflow_variables['var_sys_path'] = sys.pathCreate Date&TimeRange Create Date&TimeRange Date&TimeDifference Collect LocalMetadata determine paths StringConfiguration StringConfiguration Java EditVariable (simple) Merge Variables Python Script Merge Variables IntegerConfiguration IntegerConfiguration Merge Variables Merge Variables IntegerConfiguration StringConfiguration IntegerConfiguration Python Script Row Filter Row Filter Java EditVariable (simple) String to Path(Variable) Table Writer Java EditVariable (simple) String to Path(Variable) Table Writer Joiner Date&TimeDifference Create Date&TimeRange Create Date&TimeRange Joiner Python Script Variable toTable Row

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: A9699459
Created at: 2022-06-21
On NodePit since: 2022-06-22
Last update: 2024-04-27
Created with KNIME version: v4.7.8
Tags: knimepythonopenpyxlimportexcelxlsx

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!